public ActionResult Summary(DateTime fromDate, DateTime ToDate, string Supplier = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "GRNSummary.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("Supplier"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("GRNNo"); ds.Tables["Items"].Columns.Add("GRNDate"); ds.Tables["Items"].Columns.Add("Supplier"); ds.Tables["Items"].Columns.Add("LPONo"); ds.Tables["Items"].Columns.Add("DCNo"); ds.Tables["Items"].Columns.Add("Amount"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = fromDate.ToString("dd-MMM-yyyy"); dr["To"] = ToDate.ToString("dd-MMM-yyyy"); dr["Supplier"] = Supplier; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); GRNRegisterRepository repo1 = new GRNRegisterRepository(); var Items = repo1.GRNSummary(from: fromDate, to: ToDate, supplier: Supplier); foreach (var item in Items) { var GRNSummaryItem = new GRNRegister { GRNNo = item.GRNNo, GRNDate = item.GRNDate, SupplierName = item.SupplierName, SupplyOrderNo = item.SupplyOrderNo, DCNo = item.DCNo, Amount = item.Amount, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["GRNNo"] = GRNSummaryItem.GRNNo; dri["GRNDate"] = GRNSummaryItem.GRNDate.ToString("dd-MMM-yyyy"); dri["Supplier"] = GRNSummaryItem.SupplierName; dri["LPONo"] = GRNSummaryItem.SupplyOrderNo; dri["DCNo"] = GRNSummaryItem.DCNo; dri["Amount"] = GRNSummaryItem.Amount; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "GRNSummary.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("GRNSummary.pdf")); return(File(stream, "application/pdf")); } catch (Exception ex) { throw; } }
public ActionResult Detailed(DateTime fromDate, DateTime ToDate, string matGrpName = "", int matGrpid = 0, string matName = "", string PartNo = "", string supplier = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "GRNDetailed.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("MaterialGroup"); ds.Tables["Head"].Columns.Add("MaterialName"); ds.Tables["Head"].Columns.Add("PartNo"); ds.Tables["Head"].Columns.Add("Supplier"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("GRNNo"); ds.Tables["Items"].Columns.Add("GRNDate"); ds.Tables["Items"].Columns.Add("Supplier"); ds.Tables["Items"].Columns.Add("LPONo"); ds.Tables["Items"].Columns.Add("DCNo"); ds.Tables["Items"].Columns.Add("Material"); ds.Tables["Items"].Columns.Add("PartNo"); ds.Tables["Items"].Columns.Add("Qty"); ds.Tables["Items"].Columns.Add("Rate"); ds.Tables["Items"].Columns.Add("Amount"); ds.Tables["Items"].Columns.Add("Unit"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = fromDate.ToString("dd-MMM-yyyy"); dr["To"] = ToDate.ToString("dd-MMM-yyyy"); dr["MaterialGroup"] = matGrpName; dr["MaterialName"] = matName; dr["PartNo"] = PartNo; dr["Supplier"] = supplier; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); GRNRegisterRepository repo1 = new GRNRegisterRepository(); var Items = repo1.GRNDetailed(from: fromDate, to: ToDate, id: matGrpid, material: matName, partno: PartNo, supplier: supplier); foreach (var item in Items) { var GRNDetailedItem = new GRNRegister { GRNNo = item.GRNNo, GRNDate = item.GRNDate, SupplierName = item.SupplierName, SupplyOrderNo = item.SupplyOrderNo, DCNo = item.DCNo, ItemName = item.ItemName, PartNo = item.PartNo, Quantity = item.Quantity, Rate = item.Rate, Amount = item.Amount, UnitName = item.UnitName, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["GRNNo"] = GRNDetailedItem.GRNNo; dri["GRNDate"] = GRNDetailedItem.GRNDate.ToString("dd-MMM-yyyy"); dri["Supplier"] = GRNDetailedItem.SupplierName; dri["LPONo"] = GRNDetailedItem.SupplyOrderNo; dri["DCNo"] = GRNDetailedItem.DCNo; dri["Material"] = GRNDetailedItem.ItemName; dri["PartNo"] = GRNDetailedItem.PartNo; dri["Qty"] = GRNDetailedItem.Quantity; dri["Rate"] = GRNDetailedItem.Rate; dri["Amount"] = GRNDetailedItem.Amount; dri["Unit"] = GRNDetailedItem.UnitName; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "GRNDetailed.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")); } catch (Exception ex) { throw; } }