i am using SQL server 2005 and visual studio 2005 and llblgen version:2.5

I got a table which consists of customer issues and another table as customer. Every customer got fixed issues and everyday extra issues can be added and for that it has a seperate column. once the invoice is updated that extra issue needs to be updated to 0.

The problem i have is that intead of updating it creates a new row in issues table.

here is my coding:

protected void btnConfirm_Click(object sender, EventArgs e) { PublicationMasterEntity publicationcost = PublicationMaster.Get(Pubcode); foreach (IssueMaintenanceEntity issue in IssueMaint) { string customercode = Convert.ToString(issue.CustomerCode); Boolean validcust = CustomerMaster.GetValidCustomer(customercode); if (validcust) { CustomerMasterEntity customer = CustomerMaster.Get(customercode);

                       IssueMaintenanceEntity updateextraissue = IssueMaintenance.Get(Pubcode, customercode);
                        Boolean chargedvat = customer.Vat;
                        Boolean chargedfree = customer.Free;
                        string weekday = Date.DayOfWeek.ToString();
                        switch (publicationcost.IssueFreq)
                        {
                            case "D":
                            case "W":
                                {
                                    switch (weekday)
                                    {
                                        case "Monday":
                                            totalissue = issue.Monday + issue.MonExtra;
                                            updateextraissue.MonExtra = 0;
                                            break;
                                        case "Tuesday":
                                            totalissue = issue.Tuesday + issue.TueExtra;
                                            updateextraissue.TueExtra = 0;
                                            break;
                                        case "Wednesday":
                                            totalissue = issue.Wednesday + issue.WedExtra;
                                            updateextraissue.WedExtra = 0;
                                            break;
                                        case "Thursday":
                                            totalissue = issue.Thursday + issue.ThuExtra;
                                            updateextraissue.ThuExtra = 0;
                                            break;
                                        case "Friday":
                                            totalissue = issue.Friday + issue.FriExtra;
                                            updateextraissue.FriExtra = 0;
                                            break;
                                        case "Saturday":
                                            totalissue = Convert.ToInt32(issue.Saturday) + Convert.ToInt32(issue.SatExtra);
                                            updateextraissue.SatExtra = Convert.ToInt32(0);
                                            break;
                                        case "Sunday":
                                            totalissue = issue.Sunday + issue.SunExtra;
                                            updateextraissue.SunExtra = 0;
                                            break;
                                    }
                                }
                                break;
                        }

                       adapter.SaveEntity(updateextraissue);

} }

any sugesstions please...................

IssueMaintenance.Get(Pubcode, customercode);

What does that method do? Could you post the code?