Customer_Bill getLastCustomer(Customer_Bill entity) { Customer_Bill customer_bill = (from value in this.DataWorkspace.PMSData.Customer_Bills where value.Customer.Customer_ID == entity.Customer.Customer_ID orderby value.Bill_ID descending select value).FirstOrDefault(); return(customer_bill); }
partial void Customer_Bills_Updating(Customer_Bill entity) { if (entity.Paid_amount != 0) { Customer_Bill customer_bill = getLastCustomer(entity); customer_bill.Total -= entity.Paid_amount; customer_bill.Remarks = "Bill Date: " + String.Format("{0:MM/dd/yyyy}", entity.c_Date) + " paid on " + String.Format("{0:MM/dd/yyyy}", entity.Paid_Date.Value.Date); entity.Customer.Amount_Remaining = customer_bill.Total; } }
partial void Customer_Bills_Inserting(Customer_Bill entity) { var detail = from val in entity.Bill_Details select val; foreach (var value in detail) { entity.Bill_Amount += value.Item_Amount; } Customer_Bill customer_bill = getLastCustomer(entity); if (customer_bill != null) { entity.Total = customer_bill.Total + (decimal)entity.Bill_Amount; // adding current bill amount to previous total of customer } else { entity.Total = (decimal)entity.Bill_Amount; } entity.Customer.Amount_Remaining = entity.Total; // ... copying total to customer }