StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Messaging and Adding Broken Rules

Messaging and Adding Broken Rules

Bill Cunnien — Wed, 23 Jan 2008 09:21:33 GMT

I have decided to put my duplicate part number checking in the business object. Well, that's where it belongs, anyway, right?

Here is my code:

private void PartsBO_CheckRulesOnCurrentRow(CheckRulesEventArgs e)
{
    if (IsDuplicatePartNumber())
    {
        this.AddBrokenRuleByKey(this.partnum, "DuplicatePartNumber");
    }
}

private Boolean IsDuplicatePartNumber()
{
    SqlCommand mCommand = new SqlCommand();
    mCommand.CommandText = "SELECT COUNT(*) FROM PartsMaster WHERE partnum = @partnum AND partindex != @partindex";
    mCommand.Parameters.Add(new SqlParameter("@partnum", SqlDbType.VarChar));
    mCommand.Parameters.Add(new SqlParameter("@partindex", SqlDbType.Int));
    mCommand.Parameters["@partnum"].Value = this.partnum;
    mCommand.Parameters["@partindex"].Value = this.partindex;
    return ((int)ExecuteScalar(mCommand) > 0);
}

The window will let me know that a rule is broken. But it does not say which rule, which field, nor does my beautifully crafted message pop up. How do I get the window to do two things: 1) Mark the field that is having the problem; and 2) show my message.

Thanks!
Bill

RE: Messaging and Adding Broken Rules

Trent L. Taylor — Wed, 23 Jan 2008 09:21:33 GMT

[quote]I was tempted to say that I didn't know what you were talking about, but then I realized I don't have administrative priviledges to delete posts on the forum[/quote]

LOL...good thinking here...otherwise I might have been forced to find all of the links :D

RE: Messaging and Adding Broken Rules

Ivan George Borges — Wed, 23 Jan 2008 08:10:07 GMT

[quote][b]Greg McGuffey (01/22/2008)[/b][hr]Oh? And how is this is different from your normal dress? :blink: :w00t: ;)[/quote]

Well, usually I don't wear any... :P

RE: Messaging and Adding Broken Rules

Ivan George Borges — Wed, 23 Jan 2008 08:06:48 GMT

[quote][b]Trent L. Taylor (01/22/2008)[/b][hr]Yeah...but let's lay the foundation as of why...Ivan had offered to all attendees that I buy the beer...or something along those lines...isn't that right, Ivan? ;)[/quote]

Hum... I was tempted to say that I didn't know what you were talking about, but then I realized I don't have administrative priviledges to delete posts on the forum. :P

RE: Messaging and Adding Broken Rules

Greg McGuffey — Tue, 22 Jan 2008 19:05:36 GMT

[quote]Trent once...made me wear a chicken suit on one of his classes.[/quote]

Oh? And how is this is different from your normal dress? :blink: :w00t: ;)

RE: Messaging and Adding Broken Rules

Trent L. Taylor — Tue, 22 Jan 2008 17:05:42 GMT

[quote]Trent once almost made me wear a chicken suit on one of his classes. How is that for an embarassing situation?[/quote]

Yeah...but let's lay the foundation as of why...Ivan had offered to all attendees that I buy the beer...or something along those lines...isn't that right, Ivan? ;)

RE: Messaging and Adding Broken Rules

Ivan George Borges — Tue, 22 Jan 2008 16:03:54 GMT

Nothing to feel embarassed at all. I'm really glad it worked for you.

Trent once almost made me wear a chicken suit on one of his classes. How is that for an embarassing situation? :D

RE: Messaging and Adding Broken Rules

Bill Cunnien — Tue, 22 Jan 2008 15:55:06 GMT

Uh...that was it...:blush:

Embarassing.

Hey...at least, I am learning! :w00t: :w00t: :w00t:

RE: Messaging and Adding Broken Rules

Ivan George Borges — Tue, 22 Jan 2008 15:49:05 GMT

Hi Bill.

I'm glad it is working, you are welcome. :cool:

Regarding the message, I think you should be passing a "Text values" key, not a
"Messages key" from your Messaging Project. Is that the case?

RE: Messaging and Adding Broken Rules

Bill Cunnien — Tue, 22 Jan 2008 15:40:37 GMT

Great! That helps for part one. Now, how do I get the window to recognize the localization message involved? It has the alert icon next to the field now, which alerts the user. The tooltip looks like it is trying to present my custom message, but it is filled with some coding that will scare the average user.

Thanks, again, Ivan! You are a big help!
Bill

RE: Messaging and Adding Broken Rules

Ivan George Borges — Tue, 22 Jan 2008 15:33:54 GMT

Hi Bill.

On this line:

this.AddBrokenRuleByKey(this.partnum, "DuplicatePartNumber");

try this:

this.AddBrokenRuleByKey(PartsBOFieldNames.partnum, "DuplicatePartNumber");

Hope it helps.