public ActionResult Print1(DateTime?from, DateTime?to, int itmid = 0, string itmName = "", int SupId = 0, string SupName = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "PurchaseBillSummary.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("From"); ds.Tables["Head"].Columns.Add("To"); ds.Tables["Head"].Columns.Add("SupplierHead"); ds.Tables["Head"].Columns.Add("ItemHead"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("Datewise"); ds.Tables["Items"].Columns.Add("Amount"); SupplyOrderRegisterRepository repo = new SupplyOrderRegisterRepository(); var Head = repo.GetSupplyOrderRegisterHD(from, to, OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["SupplierHead"] = SupName; dr["ItemHead"] = itmName; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); PurchaseBillRegisterRepository repo1 = new PurchaseBillRegisterRepository(); var Items = repo1.PurchaseBillSummaryDataDTPrint(from, to, SupId, itmid, OrganizationId); foreach (var item in Items) { var SupplyOrderRegItem = new PurchaseBillRegister { PurchaseBillDate = item.PurchaseBillDate, Amount = item.Amount, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["Datewise"] = SupplyOrderRegItem.PurchaseBillDate; dri["Amount"] = SupplyOrderRegItem.Amount; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "PurchaseBillSummary.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("PurchaseBillSummary.pdf"))); } catch (Exception ex) { throw; } }
public ActionResult Print(DateTime?from, DateTime?to, int id = 0, int itmid = 0) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "SupplyOrderRegister.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("From"); ds.Tables["Head"].Columns.Add("To"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("SO.No."); ds.Tables["Items"].Columns.Add("Date"); ds.Tables["Items"].Columns.Add("Supplier"); ds.Tables["Items"].Columns.Add("Material"); ds.Tables["Items"].Columns.Add("Quantity"); ds.Tables["Items"].Columns.Add("Unit"); ds.Tables["Items"].Columns.Add("rate"); ds.Tables["Items"].Columns.Add("Amount"); ds.Tables["Items"].Columns.Add("TotalAmount"); //ds.Tables["Head"].Columns.Add("OrganizationName"); //ds.Tables["Head"].Columns.Add("Image1"); SupplyOrderRegisterRepository repo = new SupplyOrderRegisterRepository(); var Head = repo.GetSupplyOrderRegisterHD(from, to, OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); SupplyOrderRegisterRepository repo1 = new SupplyOrderRegisterRepository(); var Items = repo1.GetSupplyOrderRegisterDT(from, to, id, itmid, OrganizationId); foreach (var item in Items) { var SupplyOrderRegItem = new SupplyOrderRegister { SupplyOrderNo = item.SupplyOrderNo, SupplyOrderDate = item.SupplyOrderDate, SupplierName = item.SupplierName, ItemName = item.ItemName, OrderedQty = item.OrderedQty, UnitName = item.UnitName, Rate = item.Rate, Amount = item.Amount, TotalAmount = item.TotalAmount }; DataRow dri = ds.Tables["Items"].NewRow(); dri["SO.No."] = SupplyOrderRegItem.SupplyOrderNo; dri["Date"] = SupplyOrderRegItem.SupplyOrderDate.ToString("dd-MMM-yyyy"); dri["Supplier"] = SupplyOrderRegItem.SupplierName; dri["Material"] = SupplyOrderRegItem.ItemName; dri["Quantity"] = SupplyOrderRegItem.OrderedQty; dri["Unit"] = SupplyOrderRegItem.UnitName; dri["rate"] = SupplyOrderRegItem.Rate; dri["Amount"] = SupplyOrderRegItem.Amount; dri["TotalAmount"] = SupplyOrderRegItem.TotalAmount; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "SupplyOrderRegister.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("SupplyOrderRegister.pdf"))); } catch (Exception ex) { throw; } }
public ActionResult Print(int?project, DateTime?from, DateTime?to, int id = 0, string name = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "SalesRegister.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("From"); ds.Tables["Head"].Columns.Add("To"); ds.Tables["Head"].Columns.Add("Customer"); ds.Tables["Head"].Columns.Add("type"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("SalesInvoiceRefNo"); ds.Tables["Items"].Columns.Add("Date"); ds.Tables["Items"].Columns.Add("CustomerName"); ds.Tables["Items"].Columns.Add("WorkDescr"); ds.Tables["Items"].Columns.Add("Quantity"); ds.Tables["Items"].Columns.Add("Rate"); ds.Tables["Items"].Columns.Add("Amount"); ds.Tables["Items"].Columns.Add("Discount"); ds.Tables["Items"].Columns.Add("Unit"); ds.Tables["Items"].Columns.Add("TotalAmount"); SupplyOrderRegisterRepository repo = new SupplyOrderRegisterRepository(); var Head = repo.GetSupplyOrderRegisterHD(from, to, OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["Customer"] = name; dr["type"] = project == null ? "All" : project == 1 ? "Project" : "Transport"; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); SalesRegisterRepository repo1 = new SalesRegisterRepository(); //var Items = repo1.GetSalesRegisterDTPrint(from, to, id, OrganizationId); var Items = repo1.GetSalesRegister(from, to, id, OrganizationId, project); foreach (var item in Items) { var SupplyOrderRegItem = new SalesRegister { SalesInvoiceRefNo = item.SalesInvoiceRefNo, SalesInvoiceDate = item.SalesInvoiceDate, CustomerName = item.CustomerName, WorkDescr = item.WorkDescr, Quantity = item.Quantity, Rate = item.Rate, Amount = item.Amount, Discount = item.Discount, TotalAmount = item.TotalAmount, UnitName = item.UnitName }; DataRow dri = ds.Tables["Items"].NewRow(); dri["SalesInvoiceRefNo"] = SupplyOrderRegItem.SalesInvoiceRefNo; dri["Date"] = SupplyOrderRegItem.SalesInvoiceDate.ToString("dd-MMM-yyyy"); dri["CustomerName"] = SupplyOrderRegItem.CustomerName; dri["WorkDescr"] = SupplyOrderRegItem.WorkDescr; dri["Quantity"] = SupplyOrderRegItem.Quantity; dri["Discount"] = SupplyOrderRegItem.Discount; dri["Unit"] = SupplyOrderRegItem.UnitName; dri["rate"] = SupplyOrderRegItem.Rate; dri["Amount"] = SupplyOrderRegItem.Amount; dri["TotalAmount"] = SupplyOrderRegItem.TotalAmount; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "SalesRegister.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf"));//, String.Format("SalesRegister.pdf")); } catch (Exception ex) { throw; } }