public void GenerateReturnInvoice(Return _Return) { if (_Return != null) { DataTable orderdDT = new DataTable(); rptDataSet.dtInvoice1DataTable dt = new rptDataSet.dtInvoice1DataTable(); Supplier oSupplier = _Return.Supplier; DataSet ds = new DataSet(); db = new DEWSRMEntities(); if (_Return.ReturnDetails.Count != 0) { var RDData = (from rd in _Return.ReturnDetails join std in db.StockDetails on rd.SDetailID equals std.SDetailID join p in db.Products on std.ProductID equals p.ProductID join com in db.Companies on p.CompanyID equals com.CompanyID join cat in db.Categorys on p.CategoryID equals cat.CategoryID join col in db.Colors on std.ColorID equals col.ColorID group rd by new { rd.ProductID, p.ProductName, std.ColorID, col.Description, com.CompanyID, Comapny = com.Description, cat.CategoryID, category = cat.Description } into g select new { g.Key.ProductID, ProductName = g.Key.ProductName, ColorName = g.Key.Description, CompanyName = g.Key.Comapny, CategoryName = g.Key.category, g.Key.ColorID, Quantity = g.Sum(o => o.Quantity), UnitPrice = g.Select(o => o.UnitPrice).FirstOrDefault(), UTAmount = g.Sum(o => o.UTAmount) }); foreach (var item in RDData) { dt.Rows.Add(item.ProductName, item.CompanyName, item.CategoryName, item.ColorName, item.Quantity, "Pcs", item.UnitPrice, " 0 %", item.UTAmount, 0, 0); } } orderdDT = dt.AsEnumerable().OrderBy(o => (String)o["ProductName"]).CopyToDataTable(); dt.TableName = "rptDataSet_dtInvoice"; ds.Tables.Add(dt); string embededResource = "INVENTORY.UI.RDLC.AMReturnInvoice.rdlc"; ReportParameter rParam = new ReportParameter(); List <ReportParameter> parameters = new List <ReportParameter>(); string sInwodTk = Global.TakaFormat(Convert.ToDouble(_Return.GrandTotal)); rParam = new ReportParameter("GTotal", _Return.GrandTotal.ToString()); parameters.Add(rParam); rParam = new ReportParameter("Paid", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("CurrDue", oSupplier.TotalDue.ToString()); parameters.Add(rParam); rParam = new ReportParameter("TDiscount", _Return.PaidAmount.ToString());//oOrder.TDAmount.ToString() parameters.Add(rParam); rParam = new ReportParameter("Total", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("PreDue", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("TotalDue", oSupplier.TotalDue.ToString()); parameters.Add(rParam); rParam = new ReportParameter("InvoiceNo", _Return.InvoiceNo); parameters.Add(rParam); rParam = new ReportParameter("InvoiceDate", _Return.ReturnDate.ToString()); parameters.Add(rParam); rParam = new ReportParameter("Company", oSupplier.OwnerName); parameters.Add(rParam); rParam = new ReportParameter("CAddress", oSupplier.Address); parameters.Add(rParam); rParam = new ReportParameter("Name", oSupplier.Name); parameters.Add(rParam); rParam = new ReportParameter("MobileNo", oSupplier.ContactNo); parameters.Add(rParam); rParam = new ReportParameter("PrintedBy", Global.CurrentUser.UserName); parameters.Add(rParam); rParam = new ReportParameter("LaborCost", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("JobNumber", ""); parameters.Add(rParam); rParam = new ReportParameter("LessAmt", _Return.PaidAmount.ToString()); parameters.Add(rParam); //rParam = new ReportParameter("Logo1", Application.StartupPath + @"\Logo1.bmp"); //parameters.Add(rParam); rParam = new ReportParameter("InWordTK", sInwodTk); parameters.Add(rParam); fReportViewer frm = new fReportViewer(); frm.CommonReportViewer(embededResource, ds, parameters, true); } }
public void GenerateInvoice() { if (_Return != null) { DataTable orderdDT = new DataTable(); rptDataSet.dtInvoice1DataTable dt = new rptDataSet.dtInvoice1DataTable(); Customer customer = _Return.Customer; List <Product> products = db.Products.ToList(); Product product = null; DataSet ds = new DataSet(); foreach (ReturnDetail item in _Return.ReturnDetails) { product = products.FirstOrDefault(o => o.ProductID == item.ProductID); dt.Rows.Add(product.ProductName, product.Company.Description, product.Category.Description, "", item.Quantity, "Pcs", item.UnitPrice, " 0 %", item.UTAmount, 0, 0); } orderdDT = dt.AsEnumerable().OrderBy(o => (String)o["ProductName"]).CopyToDataTable(); dt.TableName = "rptDataSet_dtInvoice"; ds.Tables.Add(dt); string embededResource = "INVENTORY.UI.RDLC.AMReturnInvoice.rdlc"; ReportParameter rParam = new ReportParameter(); List <ReportParameter> parameters = new List <ReportParameter>(); string sInwodTk = Global.TakaFormat(Convert.ToDouble(_Return.GrandTotal)); rParam = new ReportParameter("GTotal", _Return.GrandTotal.ToString()); parameters.Add(rParam); rParam = new ReportParameter("Paid", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("CurrDue", _Return.Customer.TotalDue.ToString()); parameters.Add(rParam); rParam = new ReportParameter("TDiscount", _Return.PaidAmount.ToString());//oOrder.TDAmount.ToString() parameters.Add(rParam); rParam = new ReportParameter("Total", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("PreDue", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("TotalDue", _Return.Customer.TotalDue.ToString()); parameters.Add(rParam); rParam = new ReportParameter("InvoiceNo", _Return.InvoiceNo); parameters.Add(rParam); rParam = new ReportParameter("InvoiceDate", _Return.ReturnDate.ToString()); parameters.Add(rParam); rParam = new ReportParameter("Company", _Return.Customer.CompanyName); parameters.Add(rParam); rParam = new ReportParameter("CAddress", _Return.Customer.Address); parameters.Add(rParam); rParam = new ReportParameter("Name", _Return.Customer.Name); parameters.Add(rParam); rParam = new ReportParameter("MobileNo", _Return.Customer.ContactNo); parameters.Add(rParam); rParam = new ReportParameter("PrintedBy", Global.CurrentUser.UserName); parameters.Add(rParam); rParam = new ReportParameter("LaborCost", _Return.PaidAmount.ToString()); parameters.Add(rParam); rParam = new ReportParameter("JobNumber", ""); parameters.Add(rParam); rParam = new ReportParameter("LessAmt", _Return.PaidAmount.ToString()); parameters.Add(rParam); //rParam = new ReportParameter("Logo1", Application.StartupPath + @"\Logo1.bmp"); //parameters.Add(rParam); rParam = new ReportParameter("InWordTK", sInwodTk); parameters.Add(rParam); fReportViewer frm = new fReportViewer(); frm.CommonReportViewer(embededResource, ds, parameters, true); } }