public void CustomerEntry(string billNo, decimal sumTotal, CustomerBillData cusBill, CustomerInfoDetails custInfo) { var database = new InventoryEntities(); var billTypeIDList = (from c in database.BillTypes where c.BillTypeName == "Cash" select new { c.BillTypeID }).FirstOrDefault(); var custInfoTable = new CustomerInfo(); var billInfoTable = new BillInfo(); custInfoTable.CustomerName = custInfo.custName; custInfoTable.CustomerAddress = custInfo.custAddress; custInfoTable.Mobile = custInfo.custMobile; custInfoTable.Email = custInfo.custEmail; database.CustomerInfoes.Add(custInfoTable); billInfoTable.BillNumber = billNo; billInfoTable.BillTypeID = billTypeIDList.BillTypeID;//Cash or Credit Bill billInfoTable.TotalAmount = sumTotal; billInfoTable.Discount = custInfo.custDiscount; billInfoTable.BillDate = custInfo.billDate; billInfoTable.UpdatedOn = DateTime.Now; billInfoTable.CustomerInfo = custInfoTable; //database.CustomerInfoes.Add(custInfoTable); database.BillInfoes.Add(billInfoTable); database.SaveChanges(); }
public void CallBackFromReport(string billno, CustomerBillData cusBill, CustomerInfoDetails custInfo, ProductSale prodSale) { //MessageBox.Show("Please enter First Name!" + billno); customerBillData = cusBill; customerInfoDetails = custInfo; ProductFinalSale(billno); prodSale.dataGridViewSale.Rows.Clear(); }
public void showBill(CustomerBillData cusBill, CustomerInfoDetails custInfo) { customerBillData = cusBill; customerInfoDetails = custInfo; rs.Name = "DataSetCustBillProd"; rs.Value = cusBill.billData; _billNo = cusBill.billNo; this.reportViewerCustBill.LocalReport.DataSources.Clear(); this.reportViewerCustBill.LocalReport.DataSources.Add(rs); this.reportViewerCustBill.LocalReport.ReportEmbeddedResource = "RawForms.Reports.CustomerBill.rdlc"; rp.Add(new ReportParameter("gstNumber", cusBill.gstn)); rp.Add(new ReportParameter("custName", custInfo.custName)); rp.Add(new ReportParameter("custAddress", custInfo.custAddress)); rp.Add(new ReportParameter("billDate", custInfo.billDate.ToString("dd-MM-yyyy"))); rp.Add(new ReportParameter("billNumber", cusBill.billNo)); rp.Add(new ReportParameter("shopName", cusBill.shopName)); rp.Add(new ReportParameter("shopAddress", cusBill.shopAddress)); rp.Add(new ReportParameter("discount", custInfo.custDiscount.ToString())); this.reportViewerCustBill.LocalReport.SetParameters(rp); this.reportViewerCustBill.RefreshReport(); }
public void SendProductinfForBill() { List <CustomerBillProduct> billProdList = new List <CustomerBillProduct>(); billProdList.Clear(); //CustomerBillForm cust = new CustomerBillForm(); CustomerDetails custinfo = new CustomerDetails(this); for (int i = 0; i <= dataGridViewSale.RowCount - 2; i++) //count-2 because one header and one grand total at last row { var custBillProduct = new CustomerBillProduct { Productdesc = Convert.ToString(dataGridViewSale.Rows[i].Cells["Description"].Value), Productprice = Convert.ToDecimal(dataGridViewSale.Rows[i].Cells["SalesPrice"].Value), Productunit = Convert.ToDecimal(dataGridViewSale.Rows[i].Cells["Quantity"].Value), Totalprice = Convert.ToDecimal(dataGridViewSale.Rows[i].Cells["Total"].Value) }; billProdList.Add(custBillProduct); } var database = new InventoryEntities(); var shopInfo = (from c in database.ShopInfoes select c).FirstOrDefault(); string shopAddress = shopInfo.ShopAddress + " " + shopInfo.City + " " + shopInfo.Dist + " " + shopInfo.State + " " + shopInfo.ZIP + " Tel :" + shopInfo.PhoneNo; var customerBillData = new CustomerBillData(); customerBillData.gstn = shopInfo.Gstn; customerBillData.shopName = shopInfo.ShopName; customerBillData.shopAddress = shopAddress; customerBillData.billNo = _globalBillNo; customerBillData.billData = billProdList; custinfo.prodBillInfoPass(customerBillData, _globalBillNo); custinfo.ShowDialog(this); }
public void prodBillInfoPass(CustomerBillData custBillData, string billno) { custBillInfoData = custBillData; _billnumber = billno; }
public void ReportBuilder(string lclbillNo) { List <CustomerBillProduct> billProdList = new List <CustomerBillProduct>(); billProdList.Clear(); var billedItems = (from c in database.TransactionDetails join d in database.ProductInfoes on c.ProductID equals d.ProductID where c.BillNumber == lclbillNo select new { c.Quantity, c.UnitPrice, c.TotalPrice, d.Description }); var billingInfo = (from c in database.BillInfoes join d in database.CustomerInfoes on c.CustomerID equals d.CustomerID where c.BillNumber == lclbillNo select new { c.BillDate, c.Discount, c.TotalAmount, d.CustomerName, d.CustomerAddress, d.Mobile, d.Email, }).FirstOrDefault(); var shopInfo = (from c in database.ShopInfoes select c).FirstOrDefault(); string shopAddress = shopInfo.ShopAddress + " " + shopInfo.City + " " + shopInfo.Dist + " " + shopInfo.State + " " + shopInfo.ZIP + " Tel :" + shopInfo.PhoneNo; foreach (var row in billedItems) { var custBillProduct = new CustomerBillProduct { Productdesc = Convert.ToString(row.Description), Productprice = Convert.ToDecimal(row.UnitPrice), Productunit = Convert.ToDecimal(row.Quantity), Totalprice = Convert.ToDecimal(row.TotalPrice), }; billProdList.Add(custBillProduct); } var customerBillData = new CustomerBillData(); customerBillData.gstn = shopInfo.Gstn; customerBillData.shopName = shopInfo.ShopName; customerBillData.shopAddress = shopAddress; customerBillData.billNo = lclbillNo; customerBillData.billData = billProdList; var custDetails = new CustomerInfoDetails(); custDetails.custAddress = billingInfo.CustomerAddress; custDetails.custName = billingInfo.CustomerName; custDetails.custMobile = billingInfo.Mobile; custDetails.custEmail = billingInfo.Email; custDetails.billDate = (DateTime)billingInfo.BillDate; custDetails.custDiscount = Convert.ToDecimal(billingInfo.Discount); int printonlyBill = 1; var printBill = new CustomerBillForm(printonlyBill); printBill.showBill(customerBillData, custDetails); printBill.ShowDialog(this); }