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);
}
