public IActionResult PlanCreate(int Pid, int prod, int plant, string actionType)
{
var queryc = (from p in _dbContext.TCustomers
where p.CustId == Pid
select p).SingleOrDefault();
ViewBag.Customer = queryc;
CreateViewBags(Pid, prod, plant, Pid);
var query = (from p in _dbContext.TCCplants
where p.CplantId == plant
select p).FirstOrDefault();
ViewData["truck"] = query.CplantTruckId;
TCCplanning model = (TCCplanning)(from p in _dbContext.TCCplannings
where p.CplanCustId == Pid && p.CplanCplantId == plant
select p).FirstOrDefault();
try{
model.CplanCprodId = prod;
model.CplanDateFrom = System.DateTime.Now;
model.CplanDateTo = System.DateTime.Now;
model.CplanFirmSt = "";
model.CplanQty = 0;
}
catch {
model = new TCCplanning();
model.CplanCplantId = plant;
model.CplanCustId = Pid;
}
return(View(model));
}
public IActionResult PlanEdit(TCCplanning planning, string actionType, int?CplantId, int?CprodId, string sallpprods)
{
bool allpprods = Convert.ToBoolean(sallpprods);
ViewData["panel"] = 4;
ViewData["Allpp"] = allpprods;
int?Pid = planning.CplanCustId;
if (actionType == "Update")
{
if (ModelState.IsValid)
{
try{
//planning.CplanCplantId=CplantId;
//planning.CplanCprodId=CprodId;
_dbContext.TCCplannings.Update(planning);
_dbContext.SaveChanges();
}
catch {}
}
else
{
//loadCustomerViewBag(Pid,porder.CpocplantId);
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(View(planning));
}
}
var model = _dbContext.TCustomers
.SingleOrDefault(u => u.CustId.Equals(Pid));
string cName = model.CustRasoc + " " + model.CustNif;
ViewData["cName"] = cName;
ViewData["CusId"] = Pid;
if (actionType == "Cancel" || actionType == "Update")
{
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(RedirectToAction("Edit", new{ id = Pid, panel = 4, move = 0, prod = planning.CplanCprodId, plant = planning.CplanCplantId, allpprods = allpprods }));
}
else
{
planning.CplanCplantId = CplantId;
planning.CplanCprodId = CprodId;
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(View(planning));
}
}
public IActionResult PlanCreate(TCCplanning planning, int Pid, int prod, int?plant, string actionType, int?CplantId, int?CprodId, int?CPlanTruckId, string sallpprods)
{
bool allpprods = Convert.ToBoolean(sallpprods);
ViewData["Allpp"] = allpprods;
var model = _dbContext.TCustomers
.SingleOrDefault(u => u.CustId.Equals(Pid));
string cName = model.CustRasoc + " " + model.CustNif;
ViewData["cName"] = cName;
ViewData["CusId"] = Pid;
ViewData["panel"] = 4;
if (actionType == "Add")
{
if (ModelState.IsValid)
{
try{
if (planning.CplanCprodId == null || planning.CplanCprodId == 0)
{
planning.CplanCprodId = CprodId;
}
_dbContext.TCCplannings.Add(planning);
_dbContext.SaveChanges();
}
catch { return(View("Error")); }
}
else
{
//loadCustomerViewBag(Pid,product.CprodCplantId);
CreateViewBags(Pid, 0, planning.CplanCplantId);
return(View(planning));
}
}
if (actionType == "Cancel" || actionType == "Add")
{
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(RedirectToAction("Edit", new{ id = Pid, panel = 4, move = 0, prod = planning.CplanCprodId, plant = planning.CplanCplantId, allpprods = allpprods }));
}
else
{
planning.CplanCplantId = CplantId;
planning.CplanCprodId = CprodId;
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(View(planning));
}
}
public IActionResult PlanEdit(TCCplanning planning, string actionType, int?CplantId, int?CprodId)
{
int?Pid = planning.CplanCustId;
if (actionType == "Update")
{
if (ModelState.IsValid)
{
try{
planning.CplanCplantId = CplantId;
planning.CplanCprodId = CprodId;
_dbContext.TCCplannings.Update(planning);
_dbContext.SaveChanges();
}
catch {}
}
else
{
//loadCustomerViewBag(Pid,porder.CpocplantId);
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(View(planning));
}
}
ViewData["panel"] = 4;
if (actionType == "Cancel" || actionType == "Update")
{
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(RedirectToAction("Edit", new{ id = Pid, panel = 4, move = 0, prod = planning.CplanCprodId, plant = planning.CplanCplantId }));
}
else
{
planning.CplanCplantId = CplantId;
planning.CplanCprodId = CprodId;
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(View(planning));
}
}
public IActionResult PlanCreate(TCCplanning planning, int Pid, int prod, int?plant, string actionType, int?CplantId, int?CprodId, int?CPlanTruckId)
{
ViewData["panel"] = 4;
if (actionType == "Add")
{
if (ModelState.IsValid)
{
try{
if (planning.CplanCprodId == null || planning.CplanCprodId == 0)
{
planning.CplanCprodId = CprodId;
}
_dbContext.TCCplannings.Add(planning);
_dbContext.SaveChanges();
}
catch { return(View("Error")); }
}
else
{
//loadCustomerViewBag(Pid,product.CprodCplantId);
CreateViewBags(Pid, 0, planning.CplanCplantId);
return(View(planning));
}
}
if (actionType == "Cancel" || actionType == "Add")
{
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(RedirectToAction("Edit", new{ id = Pid, panel = 4, move = 0, prod = planning.CplanCprodId, plant = planning.CplanCplantId }));
}
else
{
planning.CplanCplantId = CplantId;
planning.CplanCprodId = CprodId;
CreateViewBags(Pid, planning.CplanCprodId, planning.CplanCplantId);
return(View(planning));
}
}
public IActionResult PlanCreate(int Pid, int prod, int plant, string actionType, bool allpprods)
{
ViewData["Allpp"] = allpprods;
if (prod == null)
{
prod = 0;
}
if (plant == null)
{
plant = 0;
}
ViewData["Plant"] = plant;
ViewData["Prod"] = prod;
var queryc = (from p in _dbContext.TCustomers
where p.CustId == Pid
select p).SingleOrDefault();
ViewBag.Customer = queryc;
CreateViewBags(Pid, prod, plant, Pid);
try{
var query = (from p in _dbContext.TCCplants
where p.CplantId == plant
select p).FirstOrDefault();
ViewData["truck"] = query.CplantTruckId;
}
catch {}
object xmodel = null;
try{
TCCplanning model = (TCCplanning)(from p in _dbContext.TCCplannings
where p.CplanCustId == Pid && p.CplanCplantId == plant
select p).FirstOrDefault();
try{
model.CplanCprodId = prod;
model.CplanDateFrom = System.DateTime.Now;
model.CplanDateTo = System.DateTime.Now;
model.CplanFirmSt = "";
model.CplanQty = 0;
}
catch {
model = new TCCplanning();
model.CplanCustId = Pid;
model.CplanCplantId = plant;
model.CplanCprodId = prod;
}
xmodel = model;
}
catch {}
var cmodel = _dbContext.TCustomers
.SingleOrDefault(u => u.CustId.Equals(Pid));
string cName = cmodel.CustRasoc + " " + cmodel.CustNif;
ViewData["cName"] = cName;
ViewData["CusId"] = Pid;
ViewData["panel"] = 4;
return(View(xmodel));
}
