public ActionResult SaleRegister(DateTime?from, DateTime?to, int?project, int id = 0)
{
from = from ?? Convert.ToDateTime("01/" + DateTime.Today.Month + "/" + DateTime.Today.Year);
to = to ?? DateTime.Today;
var list = new SalesRegisterRepository().GetSalesRegister(from, to, id, OrganizationId, project);
Session["SalesInvoiceRegister"] = list;
return(PartialView("_SaleRegister", list));
//return PartialView("_SaleRegister", new SalesRegisterRepository().GetSalesRegister(from, to, id, OrganizationId, project));
}
public ActionResult Print(DateTime?from, DateTime?to)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "SalesAnalysisProductWise.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("WorkDescr");
ds.Tables["Items"].Columns.Add("Qty");
ds.Tables["Items"].Columns.Add("Amount");
ds.Tables["Items"].Columns.Add("per");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(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);
SalesRegisterRepository repo1 = new SalesRegisterRepository();
//var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName);
var Items = repo1.GetSalesAnalysisProductWiseDTPrint(from, to, OrganizationId);
foreach (var item in Items)
{
var SupplyOrderRegItem = new SalesRegister
{
SaleOrderRefNo = item.SaleOrderRefNo,
WorkDescrShortName = item.WorkDescrShortName,
Quantity = item.Quantity,
Amount = item.Amount,
Perc = item.Perc,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["SO.NO"] = SupplyOrderRegItem.SaleOrderRefNo;
dri["WorkDescr"] = SupplyOrderRegItem.WorkDescrShortName;
dri["Qty"] = SupplyOrderRegItem.Quantity;
dri["Amount"] = SupplyOrderRegItem.Amount;
dri["per"] = SupplyOrderRegItem.Perc;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "SalesAnalysisProductWise.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("SalesAnalysisProductWise.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;
}
}
public ActionResult Print(string name = "", int id = 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "ProductWiseSalesRegister.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
// //-------HEAD
ds.Tables["Head"].Columns.Add("Customer");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
//-------DT
ds.Tables["Items"].Columns.Add("Workdes");
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");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["Customer"] = name;
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.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName);
var Items = repo1.GetProductWiseSalesRegisterDTPrint(id: id, OrganizationId: OrganizationId, FYStartdate: FYStartdate, FYEnddate: FYEnddate);
foreach (var item in Items)
{
var SupplyOrderRegItem = new SalesRegister
{
WorkDescr = item.WorkDescr,
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
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["Workdes"] = SupplyOrderRegItem.WorkDescr;
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;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "ProductWiseSalesRegister.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("ProductWiseSalesRegister.pdf")));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult Print(string Itmid = "", string PartNo = "")
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "GINRegister.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
//-------HEAD
ds.Tables["Head"].Columns.Add("Item");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
ds.Tables["Head"].Columns.Add("PartNo");
//-------DT
ds.Tables["Items"].Columns.Add("MaterialCode");
ds.Tables["Items"].Columns.Add("Material");
ds.Tables["Items"].Columns.Add("PartNo");
ds.Tables["Items"].Columns.Add("Stock");
ds.Tables["Items"].Columns.Add("Unit");
ds.Tables["Items"].Columns.Add("WR.No");
ds.Tables["Items"].Columns.Add("RequiredQty");
ds.Tables["Items"].Columns.Add("IssuedQty");
ds.Tables["Items"].Columns.Add("BalanceQty");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["Item"] = Itmid;
dr["OrganizationName"] = Head.OrganizationName;
dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1;
dr["PartNo"] = PartNo;
ds.Tables["Head"].Rows.Add(dr);
SalesRegisterRepository repo1 = new SalesRegisterRepository();
//var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName);
var Items = repo1.GetGINRegisterDataDetailsPrint(id: Itmid, OrganizationId: OrganizationId, partno: PartNo);
foreach (var item in Items)
{
var SupplyOrderRegItem = new GINRegister
{
ItemRefNo = item.ItemRefNo,
ItemName = item.ItemName,
PartNo = item.PartNo,
STOCK = item.STOCK,
UnitName = item.UnitName,
WorkShopRequestRefNo = item.WorkShopRequestRefNo,
Quantity = item.Quantity,
ISSQTY = item.ISSQTY,
BALQTY = item.BALQTY,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["MaterialCode"] = SupplyOrderRegItem.ItemRefNo;
dri["Material"] = SupplyOrderRegItem.ItemName;
dri["PartNo"] = SupplyOrderRegItem.PartNo;
dri["Stock"] = SupplyOrderRegItem.STOCK;
dri["Unit"] = SupplyOrderRegItem.UnitName;
dri["WR.No"] = SupplyOrderRegItem.WorkShopRequestRefNo;
dri["RequiredQty"] = SupplyOrderRegItem.Quantity;
dri["IssuedQty"] = SupplyOrderRegItem.ISSQTY;
dri["BalanceQty"] = SupplyOrderRegItem.BALQTY;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "GINRegister.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("GINRegister.pdf")));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult Print(DateTime?from, DateTime?to, int id = 0, string name = "")
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "PendingSaleOrderRegister.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("CusHead");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
//-------DT
ds.Tables["Items"].Columns.Add("Customer");
ds.Tables["Items"].Columns.Add("SO.NO");
ds.Tables["Items"].Columns.Add("Date");
ds.Tables["Items"].Columns.Add("WorkDescr");
ds.Tables["Items"].Columns.Add("QtyAsPerSO");
ds.Tables["Items"].Columns.Add("QtySold");
ds.Tables["Items"].Columns.Add("Balance");
ds.Tables["Items"].Columns.Add("Status");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["From"] = from.Value.ToShortDateString();
dr["To"] = to.Value.ToShortDateString();
dr["CusHead"] = name;
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.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName);
var Items = repo1.GetPendingSODTPrint(from, to, id, OrganizationId);
foreach (var item in Items)
{
var SupplyOrderRegItem = new SalesRegister
{
CustomerName = item.CustomerName,
SaleOrderRefNo = item.SaleOrderRefNo,
SaleOrderDate = item.SaleOrderDate,
WorkDescr = item.WorkDescr,
Quantity = item.Quantity,
INVQTY = item.INVQTY,
BALQTY = item.BALQTY,
Status = item.Status,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["Customer"] = SupplyOrderRegItem.CustomerName;
dri["SO.NO"] = SupplyOrderRegItem.SaleOrderRefNo;
dri["Date"] = SupplyOrderRegItem.SaleOrderDate.ToString("dd-MMM-yyyy");
dri["WorkDescr"] = SupplyOrderRegItem.WorkDescr;
dri["QtyAsPerSO"] = SupplyOrderRegItem.Quantity;
dri["QtySold"] = SupplyOrderRegItem.INVQTY;
dri["Balance"] = SupplyOrderRegItem.BALQTY;
dri["Status"] = SupplyOrderRegItem.Status;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "PendingSaleOrderRegister.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("PendingSaleOrderRegister.pdf")));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult Print(string name = "", int id = 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "TargetVsAchieved.rpt"));
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
// //-------HEAD
ds.Tables["Head"].Columns.Add("Month");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
//-------DT
ds.Tables["Items"].Columns.Add("MonthName");
ds.Tables["Items"].Columns.Add("WorkDescr");
ds.Tables["Items"].Columns.Add("Target");
ds.Tables["Items"].Columns.Add("Achieved");
ds.Tables["Items"].Columns.Add("Varience");
ds.Tables["Items"].Columns.Add("Varperc");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["Month"] = name;
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.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName);
var Items = repo1.GetTargetVsAchievedDTPrint(id: id, OrganizationId: OrganizationId, FYStartdate: FYStartdate, FYEnddate: FYEnddate);
foreach (var item in Items)
{
var SupplyOrderRegItem = new SalesRegister
{
MonthName = item.MonthName,
WorkDescr = item.WorkDescr,
Target = item.Target,
Achieved = item.Achieved,
Varience = item.Varience,
Varperc = item.Varperc
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["MonthName"] = SupplyOrderRegItem.MonthName;
dri["WorkDescr"] = SupplyOrderRegItem.WorkDescr;
dri["Target"] = SupplyOrderRegItem.Target;
dri["Achieved"] = SupplyOrderRegItem.Achieved;
dri["Varience"] = SupplyOrderRegItem.Varience;
dri["Varperc"] = SupplyOrderRegItem.Varperc;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "TargetVsAchieved.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("TargetVsAchieved.pdf")));
}
catch (Exception ex)
{
throw;
}
}
