public ActionResult DeleteProductName(string ID, ProductName_Model objModel, int page = 1, int pageSize = 10)
{
ProductNameManager context = new ProductNameManager(new DataContext());
if (!string.IsNullOrEmpty(ID))
{
int pId = Convert.ToInt32(ID);
List <Productname> lst = context.GetAll(c => c.PrdID == pId).ToList();
context.DeleteProductName(lst);
}
if (objModel.StaticPageSize != 0)
{
pageSize = objModel.StaticPageSize;
}
objModel.StaticPageSize = pageSize;
BindProductNameGrid(objModel, page, pageSize);
return(PartialView("ProductNameList", objModel));
}
public ActionResult SetGanttChart1(string BON = "")
{
ProdcutGroupGanttManager objPGGantttManager = new ProdcutGroupGanttManager(new DataContext());
BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext());
BuyerListManager objBuyerListManager = new BuyerListManager(new DataContext());
ProcessListManager objProcessListManager = new ProcessListManager(new DataContext());
ProductNameManager objProductNameManager = new ProductNameManager(new DataContext());
List <VW_ProdcutGroupGantt> lstData = new List <VW_ProdcutGroupGantt>();
if (string.IsNullOrEmpty(BON))
{
lstData = objPGGantttManager.GetAll().ToList();
}
else
{
lstData = objPGGantttManager.GetAll(c => c.Buyername == BON).ToList();
}
List <TaskViewModel> lstTData = new List <TaskViewModel>();
List <string> lstBDN = objBuyerListManager.GetAll().ToList().Select(c => c.BuyerName).ToList();
List <string> lstODN = objBuyerOrderNumberListManager.GetAll().ToList().Select(c => c.BuyerOrderNumberName).ToList();
List <string> lstPSN = objProcessListManager.GetAll().ToList().Select(c => c.ProcessName).ToList();
List <string> lstPDN = objProductNameManager.GetAll().ToList().Select(c => c.ProductName).ToList();
int ord = 1;
foreach (string bo in lstBDN)
{
var lstByBON = lstData.Where(c => c.Buyername == bo);
if (lstByBON.Count() > 0)
{
DateTime sDateBON = lstByBON.Min(c => c.StartDate).Value;
DateTime eDateBON = lstByBON.Max(c => c.SPCDate).Value;
DateTime?skusDate = lstByBON.Min(c => c.SKUStartDate);
DateTime?skueeDate = lstByBON.Max(c => c.SKUEndDate);
if (skusDate == null)
{
}
TaskViewModel obj = new TaskViewModel();
obj.ID = ord;
obj.Title = bo;
obj.ParentID = null;
obj.PercentComplete = Convert.ToDouble(lstByBON.FirstOrDefault().Done) / 100.00;
obj.OrderID = ord;
obj.ChildId = ord;
obj.Start = DateTime.SpecifyKind(sDateBON, DateTimeKind.Utc);
obj.End = DateTime.SpecifyKind(eDateBON, DateTimeKind.Utc);
obj.Expanded = true;
obj.Summary = true;
obj.Done = lstByBON.Max(c => c.Done);
obj.DelayedDays = lstByBON.Max(c => c.DelayedDays);
obj.SKUStart = skusDate;
obj.SKUEnd = skueeDate;
lstTData.Add(obj);
ord++;
foreach (string ps in lstODN)
{
var lstByPS = lstData.Where(c => c.Buyername == bo && c.BuyerOrderNumberName == ps);
if (lstByPS.Count() > 0)
{
DateTime sDatePS = lstByPS.Min(c => c.StartDate).Value;
DateTime eDatePS = lstByPS.Max(c => c.SPCDate).Value;
DateTime?skusDate1 = lstByBON.Min(c => c.SKUStartDate);
DateTime?skueeDate1 = lstByBON.Max(c => c.SKUEndDate);
if (skusDate1 == null)
{
}
TaskViewModel obj1 = new TaskViewModel();
obj1.ID = ord;
obj1.Title = ps;
obj1.ParentID = obj.ID;
obj1.Start = DateTime.SpecifyKind(sDatePS, DateTimeKind.Utc);
obj1.End = DateTime.SpecifyKind(eDatePS, DateTimeKind.Utc);
obj1.PercentComplete = Convert.ToDouble(lstByPS.FirstOrDefault().Done) / 100.00;
obj1.OrderID = ord;
obj1.ChildId = ord;
obj1.Expanded = true;
obj1.Summary = true;
obj1.Done = lstByPS.Max(c => c.Done);
obj1.DelayedDays = lstByPS.Max(c => c.DelayedDays);
obj1.SKUStart = skusDate1;
obj1.SKUEnd = skueeDate1;
lstTData.Add(obj1);
ord++;
foreach (string vs in lstPSN)
{
var lstByVS = lstData.Where(c => c.Buyername == bo && c.BuyerOrderNumberName == ps && c.Processname == vs);
if (lstByVS.Count() > 0)
{
DateTime sDateVS = lstByVS.Min(c => c.StartDate).Value;
DateTime eDateVS = lstByVS.Max(c => c.SPCDate).Value;
DateTime?skusDate2 = lstByBON.Min(c => c.SKUStartDate);
DateTime?skueeDate2 = lstByBON.Max(c => c.SKUEndDate);
if (skusDate1 == null)
{
}
TaskViewModel obj2 = new TaskViewModel();
obj2.ID = ord;
obj2.Title = vs;
obj2.ParentID = obj1.ID;
obj2.Start = DateTime.SpecifyKind(sDatePS, DateTimeKind.Utc);
obj2.End = DateTime.SpecifyKind(eDatePS, DateTimeKind.Utc);
obj2.PercentComplete = Convert.ToDouble(lstByVS.FirstOrDefault().Done) / 100.00;
obj2.OrderID = ord;
obj2.ChildId = ord;
obj2.Expanded = true;
obj2.Summary = true;
obj2.Done = lstByVS.Max(c => c.Done);
obj2.DelayedDays = lstByVS.Max(c => c.DelayedDays);
obj2.SKUStart = skusDate2;
obj2.SKUEnd = skueeDate2;
lstTData.Add(obj2);
ord++;
foreach (string pd in lstPDN)
{
var lstByPD = lstData.Where(c => c.Buyername == bo && c.BuyerOrderNumberName == ps && c.Processname == vs && c.Productname == pd);
if (lstByPD.Count() > 0)
{
foreach (var objData in lstByPD)
{
DateTime?skusDate3 = objData.SKUStartDate;
DateTime?skueeDate3 = objData.SKUEndDate;
if (skusDate3 == null)
{
}
TaskViewModel obj3 = new TaskViewModel();
obj3.Title = objData.Productname;
obj3.ID = ord;
obj3.Start = DateTime.SpecifyKind(objData.StartDate.Value, DateTimeKind.Utc);
obj3.End = DateTime.SpecifyKind(objData.SPCDate.Value, DateTimeKind.Utc);
obj3.ParentID = obj2.ID;
obj3.PercentComplete = Convert.ToDouble(objData.Done) / 100.00;
obj3.OrderID = ord;
obj3.ChildId = ord;
obj3.Expanded = true;
obj3.Summary = false;
obj3.NoDays = objData.NoDays;
obj3.Done = objData.Done;
obj3.DelayedDays = objData.DelayedDays;
obj3.SKUStart = skusDate3;
obj3.SKUEnd = skueeDate3;
lstTData.Add(obj3);
ord++;
}
}
}
}
}
}
}
}
}
return(Json(new { data = lstTData }));
}