// GET: MaterialPlanning
public ActionResult Index()
{
FillItemRM();
//FillPartNo();
InitDropdown();
FillBatch();
MaterialPlanning mp = new MaterialPlanning();
mp.ItemId = 0;
return(View("Index", mp));
}
public ActionResult FGPrint(string Itmname = "", int Itmid = 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "MaterialPlanningFG.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("Batch");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
//-------DT
ds.Tables["Items"].Columns.Add("Material");
ds.Tables["Items"].Columns.Add("PartNo");
ds.Tables["Items"].Columns.Add("WRQty");
ds.Tables["Items"].Columns.Add("PndIssQty");
ds.Tables["Items"].Columns.Add("MinStk");
ds.Tables["Items"].Columns.Add("TotalReqqty");
ds.Tables["Items"].Columns.Add("Currstk");
ds.Tables["Items"].Columns.Add("IntransitQty");
ds.Tables["Items"].Columns.Add("pndlpoQty");
ds.Tables["Items"].Columns.Add("Short");
ds.Tables["Items"].Columns.Add("Uom");
OrganizationRepository repo = new OrganizationRepository();
var Head = repo.GetOrganization(OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["Item"] = Itmname;
dr["OrganizationName"] = Head.OrganizationName;
dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1;
ds.Tables["Head"].Rows.Add(dr);
MaterialPlanningRepository repo1 = new MaterialPlanningRepository();
//var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName);
var Items = repo1.GetMaterialPlanningFGPrint(Itmid);
foreach (var item in Items)
{
var SupplyOrderRegItem = new MaterialPlanning
{
ItemName = item.ItemName,
PartNo = item.PartNo,
WRQTY = item.WRQTY,
WRPndIssQty = item.WRPndIssQty,
MinLevel = item.MinLevel,
TotalQty = item.TotalQty,
CurrentStock = item.CurrentStock,
InTransitQty = item.InTransitQty,
PendingPRQty = item.PendingPRQty,
ShortorExcess = item.ShortorExcess,
UnitName = item.UnitName,
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["Material"] = SupplyOrderRegItem.ItemName;
dri["PartNo"] = SupplyOrderRegItem.PartNo;
dri["WRQty"] = SupplyOrderRegItem.PENWRQTY;
dri["PndIssQty"] = SupplyOrderRegItem.WRPndIssQty;
dri["MinStk"] = SupplyOrderRegItem.MinLevel;
dri["TotalReqqty"] = SupplyOrderRegItem.TotalQty;
dri["Currstk"] = SupplyOrderRegItem.CurrentStock;
dri["IntransitQty"] = SupplyOrderRegItem.InTransitQty;
dri["pndlpoQty"] = SupplyOrderRegItem.PendingPRQty;
dri["Short"] = SupplyOrderRegItem.ShortorExcess;
dri["Uom"] = SupplyOrderRegItem.UnitName;
ds.Tables["Items"].Rows.Add(dri);
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "MaterialPlanningFG.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;
}
}
