Using the BO.Seek() method to find duplicate record in current view....

StrataFrame Forum

Back

Using the BO.Seek() method to find duplicate record in current view....

Using the BO.Seek() method to find duplicate record in current...

Author	Message
Edhy Rijo	E Edhy Rijo posted 17 Years Ago HOT Topic Details Share Topic
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Hi All, I have a process that will create some customer payment records, in this process I can not allow a duplicate record to be created, so in my process I need to look for any possible duplicate record and then skip the creation of the duplicate one. I am trying to do this with the BO.Seek, but I am getting an error which I can not properly identify. Here my code: strSeekWhere("FK_InsuredCustomer=51 and FK_Vehicle=0 and FK_Policy=34 and PaymentNumber=0 and PaymentDueDate=5/31/2008 12:00:00 AM and PaymentAmount=500.0000") If loCurrentPaymentScheduleBO.Seek(strSeekWhere) Then Continue For End If Here is the exeption error: SyntaxErrorException Syntax error: Missing operand after '12' operator. Source : System.Data Stack Trace: at System.Data.ExpressionParser.Parse() at System.Data.DataExpression..ctor(DataTable table, String expression, Type type) at System.Data.Select..ctor(DataTable table, String filterExpression, String sort, DataViewRowState recordStates) at System.Data.DataTable.Select(String filterExpression, String sort, DataViewRowState recordStates) at MicroFour.StrataFrame.Business.BusinessLayer.Seek(String WhereClause) at IBS_BOL.PolicyBO.CreatePaymentSchedule(Int32 pInsuredCustomerPK, PaymentScheduleBO loCurrentPaymentScheduleBO, DateTime PaymentStartDate, Int32 pVehiclePK) in E:\Visual Studio 2008 Projects\StrataFrame\Insurance Broker System (SF)\BOL\IBS_BOL\Main Forms BOs\PolicyBO.vb:line 217 at IBS_UI.frmPolicy.tsbCreatePaymentSchedule_Click(Object sender, EventArgs e) in E:\Visual Studio 2008 Projects\StrataFrame\Insurance Broker System (SF)\UI\Main Forms\frmPolicy.vb:line 389 at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m) at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) What am I doing wrong here? or is there any other way to try to identify a possible duplicate record in the BO.CurrentView. Edhy Rijo
	Reply Like 0
Replies
Edhy Rijo	E Edhy Rijo posted 17 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Greg McGuffey (06/05/2008) you aren't delimiting the date. Try putting ## around the date... Hi Greg, That was it! I am trying to format the values use in the filter and did not noticed that the date was coming out without the ##. I am falling in love with the String.Format command, here the final version: strSeekWhere = String.Format("FK_InsuredCustomer={0} and FK_Vehicle={1} and FK_Policy={2} and PaymentNumber={3} and PaymentDueDate=#{4}# and PaymentAmount={5}", pInsuredCustomerPK, pVehiclePK, Me.PK_Policy, PaymentNumber, PaymentDueDateItem, PaymentAmountDueItem) Thanks a lot! Edhy Rijo
	Reply Like 0
Trent Taylor	Trent Taylor posted 17 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 6.9K	All good stuff...the only time that this will not work for you Edhy, is if you don't have all of the records in the BO itself. In that case, you will want to create a scalar method and query the server...this is generally what we will do. For example: Private Function IsUniqueCode(ByVal currentRecordPk As Integer, ByVal customerCode as String) As Boolean Dim cmd As New SqlCommand("SELECT COUNT(*) FROM Customers WHERE cs_pk != @currentRecordPk AND cs_CustomerCode = @customerCode") '-- Create the parms. The reason you include the current record PK is so that the current record ' will be ignored and only look for other records with the same code value. cmd.Parameters.AddWithValue("@currentRecordPk",currentRecordPk).SqlDbType = SqlDbType.Int cmd.Parameters.AddWithValue("@customerCode",customerCode).SqlDbType = SqlDbType.VarChar '-- Execute and return the results Return CType(Me.ExecuteScalar(cmd), Integer) = 0 End Function If you have the need, you can then combine an internal search of the BO with the testing of the value on the server.
	Reply Like 0
Edhy Rijo	E Edhy Rijo posted 17 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Trent, Greg, Thanks again for the good advice. I will create the scalar method just to be on the safe side. In this case, the payments will be created only by one user, just to make sure it is correct, and this is done once a year. I just wanted to add a bit of code to make sure in case that person need to delete a payment record (which of course has not been paid) could do so and that the routine to do it should make sure not duplicate payments records be created. In this case the PaymentScheduleBO should always have filled with all the payments to validate, but the scalar method idea will add another safety and fool proof this process even more. Edhy Rijo
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

Using the BO.Seek() method to find duplicate record in current...

Edhy Rijo - 17 Years Ago

you aren't delimiting the date. Try putting ## around the date......

Greg McGuffey - 17 Years Ago

Oops, I tried to bold the #, which didn't show up very well and left a...

Greg McGuffey - 17 Years Ago

Good to hear Edhy! Yeah, I use the string format command a lot too....

Greg McGuffey - 17 Years Ago

[quote][b]Greg McGuffey (06/05/2008)[/b][hr]you aren't delimiting the...

Edhy Rijo - 17 Years Ago

All good stuff...the only time that this will not work for you Edhy,...

Trent L. Taylor - 17 Years Ago

Trent, Greg, Thanks again for the good advice. I will create the...

Edhy Rijo - 17 Years Ago

Hi I take a look to the samples provided for check for duplicates,...

Juan Carlos Pazos - 17 Years Ago

Hi Juan. Have a look at your table and see if you don't have already...

Ivan George Borges - 17 Years Ago

Hi Ivan I have one record, after add the first if I add a new one...

Juan Carlos Pazos - 17 Years Ago

Sorry Juan, I should have read it more carefully. Have a look at your...

Ivan George Borges - 17 Years Ago

Hi Ivan ;) You are right. Thanks Before read this, I take a look to...

Juan Carlos Pazos - 17 Years Ago

Glad you got it going, Juan! Just for you to think about, have a look...

Ivan George Borges - 17 Years Ago

One other thought to cap off this post, all of the server side query...

Trent L. Taylor - 17 Years Ago

Hi Trent Thanks for you comment. The other solution is in the BO,...

Juan Carlos Pazos - 17 Years Ago

They would both go in the BO when validating through the...

Trent L. Taylor - 17 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login