private void button1_Click(object sender, EventArgs e) { ReceiptHistory rh = new ReceiptHistory(); rh.Table_id = tableidtext.Text; rh.Type = "Dinein"; // rh.Amount = (Convert.ToInt32(amounttxt)); rh.Date = dateTimePicker1.Value; // rh.Due = (Convert.ToInt32(duetxt)); sdbe.ReceiptHistories.Add(rh); sdbe.SaveChanges(); MessageBox.Show("Item Added"); }
public ReceiptHistory GetReceiptHistoryByCustomerID(DateTime fromDate, DateTime toDate, int referenceTypeID, long referenceID, int branchID) { List <Payment> list = new List <Payment>(); ReceiptHistory receiptHistory = new ReceiptHistory(); List <TicketSale> ticketSaleList = new List <TicketSale>(); list = GetPaymentAll().Where(ts => ((fromDate == DateTime.MinValue || (fromDate != DateTime.MinValue && ts.PaymentDate.Date >= fromDate.Date)) && (toDate == DateTime.MinValue || (toDate != DateTime.MinValue && ts.PaymentDate.Date <= toDate.Date)) && (referenceTypeID <= 0 || (referenceTypeID > 0 && ts.ReferenceTypeID == referenceTypeID)) && (referenceID <= 0 || (referenceID > 0 && ts.ReferenceID == referenceID)) && (branchID <= 0 || (branchID > 0 && ts.BranchID == branchID)) //&& (ts.Status != Convert.ToInt32(EnumCollection.PaymentStatus.Paid)) )).ToList(); ticketSaleList = GetTicketSaleByCustomerID(referenceID, fromDate, toDate, branchID); if (ticketSaleList.Count > 0) { decimal totalCustomerReceivable = 0; foreach (TicketSale ticketSale in ticketSaleList) { totalCustomerReceivable += ticketSale.CustomerReceivable; } decimal totalReceived = 0; foreach (Payment payment in list) { totalReceived += payment.PaidAmount; } receiptHistory.TotalReceivable = totalCustomerReceivable; receiptHistory.TotalReceived = totalReceived; receiptHistory.TotalDue = totalCustomerReceivable - totalReceived; receiptHistory.ReferenceType = referenceTypeID; receiptHistory.ReferenceID = referenceID; receiptHistory.ReferenceName = ticketSaleList[0].Customer.Name; } return(receiptHistory); }