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