public ActionResult Print(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"), "PurchaseBillRegister.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("BillNo&Date");
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("rate");
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["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.GetPurchaseBillRegisterDataDTPrint(from, to, SupId, itmid, OrganizationId);
foreach (var item in Items)
{
var SupplyOrderRegItem = new PurchaseBillRegister
{
PurchaseBillNoDate = item.PurchaseBillNoDate,
PurchaseBillDate = item.PurchaseBillDate,
SupplierName = item.SupplierName,
ItemName = item.ItemName,
Quantity = item.Quantity,
Rate = item.Rate,
Amount = item.Amount,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["BillNo&Date"] = SupplyOrderRegItem.PurchaseBillNoDate;
dri["Date"] = SupplyOrderRegItem.PurchaseBillDate.ToString("dd-MMM-yyyy");
dri["Supplier"] = SupplyOrderRegItem.SupplierName;
dri["Material"] = SupplyOrderRegItem.ItemName;
dri["Quantity"] = SupplyOrderRegItem.Quantity;
dri["rate"] = SupplyOrderRegItem.Rate;
dri["TotalAmount"] = SupplyOrderRegItem.Amount;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "PurchaseBillRegister.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("PurchaseBillRegister.pdf")));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult Print(int SupId = 0, string SupName = "")
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "PurchaseMonthlyItemwise.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
// //-------HEAD
ds.Tables["Head"].Columns.Add("SupplierHead");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
//-------DT
ds.Tables["Items"].Columns.Add("ItemDes");
ds.Tables["Items"].Columns.Add("Jan");
ds.Tables["Items"].Columns.Add("Feb");
ds.Tables["Items"].Columns.Add("Mar");
ds.Tables["Items"].Columns.Add("Apr");
ds.Tables["Items"].Columns.Add("May");
ds.Tables["Items"].Columns.Add("Jun");
ds.Tables["Items"].Columns.Add("Jul");
ds.Tables["Items"].Columns.Add("Aug");
ds.Tables["Items"].Columns.Add("Sep");
ds.Tables["Items"].Columns.Add("Oct");
ds.Tables["Items"].Columns.Add("Nov");
ds.Tables["Items"].Columns.Add("Dec");
ds.Tables["Items"].Columns.Add("Total");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["SupplierHead"] = SupName;
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.GetPurchaseMonthlyItemWiseDataDTPrint(SupId: SupId, OrganizationId: OrganizationId, FYStartdate: FYStartdate, FYEnddate: FYEnddate);
foreach (var item in Items)
{
var SupplyOrderRegItem = new PurchaseBillRegister
{
ItemName = item.ItemName,
Jan = item.Jan,
Feb = item.Feb,
Mar = item.Mar,
Apr = item.Apr,
May = item.May,
Jun = item.Jun,
Jul = item.Jul,
Aug = item.Aug,
Sep = item.Sep,
Oct = item.Oct,
Nov = item.Nov,
Dece = item.Dece,
Total = item.Total
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["ItemDes"] = SupplyOrderRegItem.ItemName;
dri["Jan"] = SupplyOrderRegItem.Jan;
dri["Feb"] = SupplyOrderRegItem.Feb;
dri["Mar"] = SupplyOrderRegItem.Mar;
dri["Apr"] = SupplyOrderRegItem.Apr;
dri["May"] = SupplyOrderRegItem.May;
dri["Jun"] = SupplyOrderRegItem.Jun;
dri["Jul"] = SupplyOrderRegItem.Jul;
dri["Aug"] = SupplyOrderRegItem.Aug;
dri["Sep"] = SupplyOrderRegItem.Sep;
dri["Oct"] = SupplyOrderRegItem.Oct;
dri["Aug"] = SupplyOrderRegItem.Aug;
dri["Sep"] = SupplyOrderRegItem.Sep;
dri["Oct"] = SupplyOrderRegItem.Oct;
dri["Nov"] = SupplyOrderRegItem.Nov;
dri["Dec"] = SupplyOrderRegItem.Dece;
dri["Total"] = SupplyOrderRegItem.Total;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "PurchaseMonthlyItemwise.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("PurchaseMonthlyItemwise.pdf")));
}
catch (Exception ex)
{
throw;
}
}
