public ActionResult Gantt()
{
ProductManager objProductManager = new ProductManager(new DataContext());
BuyerListManager objBuyername = new BuyerListManager(new DataContext());
BuyerOrderNumberListManager objBuyerOrderNumber = new BuyerOrderNumberListManager(new DataContext());
ProcessListManager objProcessListManager = new ProcessListManager(new DataContext());
List <BuyerOrderNumber> lstBuyerOrderNumber = objBuyerOrderNumber.GetAll();
List <ProductUpdateGrid> lstProductUpdateGrid = objProductManager.GetProductMasterList();
int i = 1;
List <ProductGantt> lst = new List <ProductGantt>();
foreach (BuyerOrderNumber obj in lstBuyerOrderNumber)
{
ProductGantt obj1 = new ProductGantt();
obj1.id = i;
obj1.name = obj.BuyerOrderNumberName;
List <Series> s1 = lstProductUpdateGrid.Where(c => c.BuyerOrderNumberName == obj.BuyerOrderNumberName).Select(c => new Series {
start = c.StartDate.Value, end = c.SPCDate.Value, name = c.Processname, color = null
}).ToList();
obj1.series = s1;
lst.Add(obj1);
i++;
}
ProductGantt_Model model = new ProductGantt_Model();
model.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname");
model.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumber.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName");
model.SeriesList = lst;
model.Json = JsonConvert.SerializeObject(lst);
return(View(model));
}
public ActionResult ResetGantt(string ProcessName, string BuyerOrderNumberName)
{
ProductManager objProductManager = new ProductManager(new DataContext());
BuyerOrderNumberListManager objBuyerOrderNumber = new BuyerOrderNumberListManager(new DataContext());
ProcessListManager objProcessListManager = new ProcessListManager(new DataContext());
List <BuyerOrderNumber> lstBuyerOrderNumber = new List <BuyerOrderNumber>();
List <ProductUpdateGrid> lstProductUpdateGrid = new List <ProductUpdateGrid>();
if (!string.IsNullOrEmpty(BuyerOrderNumberName) && !string.IsNullOrEmpty(ProcessName))
{
lstBuyerOrderNumber = objBuyerOrderNumber.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName).ToList();
lstProductUpdateGrid = objProductManager.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName && c.Processname == ProcessName).ToList();
}
else if (string.IsNullOrEmpty(BuyerOrderNumberName) && !string.IsNullOrEmpty(ProcessName))
{
lstBuyerOrderNumber = objBuyerOrderNumber.GetAll().ToList();
lstProductUpdateGrid = objProductManager.GetAll(c => c.Processname == ProcessName).ToList();
}
else if (!string.IsNullOrEmpty(BuyerOrderNumberName) && string.IsNullOrEmpty(ProcessName))
{
lstBuyerOrderNumber = objBuyerOrderNumber.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName).ToList();
lstProductUpdateGrid = objProductManager.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName).ToList();
}
else
{
lstBuyerOrderNumber = objBuyerOrderNumber.GetAll().ToList();
lstProductUpdateGrid = objProductManager.GetAll().ToList();
}
ProductGantt_Model model = new ProductGantt_Model();
model.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname");
model.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumber.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName");
if (lstProductUpdateGrid.Count() > 0)
{
int i = 1;
List <ProductGantt> lst = new List <ProductGantt>();
foreach (BuyerOrderNumber obj in lstBuyerOrderNumber)
{
ProductGantt obj1 = new ProductGantt();
obj1.id = i;
obj1.name = obj.BuyerOrderNumberName;
List <Series> s1 = lstProductUpdateGrid.Where(c => c.BuyerOrderNumberName == obj.BuyerOrderNumberName).Select(c => new Series {
start = c.StartDate.Value, end = c.SPCDate.Value, name = c.Processname, color = null
}).ToList();
obj1.series = s1;
lst.Add(obj1);
i++;
}
model.SeriesList = lst;
model.Json = JsonConvert.SerializeObject(lst);
}
else
{
model.SeriesList = new List <ProductGantt>();
model.Json = "";
}
return(View("Gantt", model));
}
