//bill generating part
public bool insertInvoice(int BillNo, int ItemID, string ItemName, int ItemQty, int ItemUnitPrice, int ItemSumPrice, string Cashier, string Branch, string date)
{
invoiceTB newInvoice = new invoiceTB();
newInvoice.BillNo = BillNo;
newInvoice.ItemID = ItemID;
newInvoice.ItemName = ItemName;
newInvoice.ItemQty = ItemQty;
newInvoice.ItemUnitPrice = ItemUnitPrice;
newInvoice.ItemSumPrice = ItemSumPrice;
newInvoice.Cashier = Cashier;
newInvoice.Branch = Branch;
newInvoice.Date = date;
myCashDB.invoiceTBs.InsertOnSubmit(newInvoice);
myCashDB.SubmitChanges();
return(true);
}
partial void DeleteinvoiceTB(invoiceTB instance);
partial void UpdateinvoiceTB(invoiceTB instance);
partial void InsertinvoiceTB(invoiceTB instance);