public IActionResult BLDCreate(int id, int Pid, string actionType)
{
CreateViewBags(Pid);
TInputBLH mat = (from ma in _dbContext.TInputBLHs
where ma.InBLId == Pid select ma).SingleOrDefault();
ViewData["panel"] = 1;
VTBLDet queryco = (from ma in _dbContext.TInputBLHs
join co in _dbContext.TInputBLDs on ma.InBLId equals co.InBLId
into RefComp
from pco in RefComp.DefaultIfEmpty()
where ma.InBLId == Pid
select new VTBLDet {
InBLDId = 0,
InBLId = Pid,
//InBLDateRec=System.DateTime.Now,
InBLDMatUnMed = "",
InBLDMDescr = "",
InBLDMRefer = "",
//InBLDNum="",
InBLDProdId = 0,
InBLDQty = 0,
InBLDStat = "",
InBLDUM = 0,
InBLDUMRef = ""
}).Distinct().SingleOrDefault();
//ViewBag.ListMatComp=queryco;
return(View((VTBLDet)queryco));
}
public IActionResult BLHCreate()
{
CreateViewBags(0);
ViewData["panel"] = 1;
TInputBLH model = (from pl in _dbContext.TInputBLHs
select new TInputBLH {
InBLDateRec = System.DateTime.Now,
InBLId = 0,
InBLnum = "",
InBLObser = "",
InBLStatus = "PR",
InBLSupId = 0
}).FirstOrDefault();
return(View(model));
}
public IActionResult BLHCreate(TInputBLH model, string actionType)
{
ViewData["panel"] = 1;
if (actionType == "Add")
{
if (ModelState.IsValid)
{
try{
_dbContext.TInputBLHs.Add(model);
_dbContext.SaveChanges();
}
catch { return(View("Error")); }
}
else
{
CreateViewBags(0);
return(View(model));
}
}
CreateViewBags(0);
ViewData["panel"] = 1;
return(RedirectToAction("Index", new{ panel = 1 }));
}
public IActionResult BLHEdit(TInputBLH material, int id, string actionType)
{
if (actionType == "Update")
{
if (ModelState.IsValid)
{
try{
material.InBLId = id;
_dbContext.TInputBLHs.Update(material);
_dbContext.SaveChanges();
}
catch {}
}
else
{
CreateViewBags(id);
ViewData["panel"] = 1;
return(View(material));
}
}
if (actionType == "PostBL")
{
try{
material.InBLId = id;
material.InBLStatus = "CR";
material.InBLDateStat = System.DateTime.Now;
_dbContext.TInputBLHs.Update(material);
_dbContext.SaveChanges();
}
catch (Exception ex) {
string mensaje = ex.Message;
}
}
if (actionType == "Accept")
{
try{
material.InBLId = id;
material.InBLStatus = "AC";
material.InBLDateStat = System.DateTime.Now;
_dbContext.TInputBLHs.Update(material);
_dbContext.SaveChanges();
}
catch (Exception ex) {
string mensaje = ex.Message;
}
}
if (actionType == "Invoice")
{
try{
material.InBLId = id;
material.InBLStatus = "FA";
material.InBLDateStat = System.DateTime.Now;
_dbContext.TInputBLHs.Update(material);
_dbContext.SaveChanges();
}
catch (Exception ex) {
string mensaje = ex.Message;
}
}
CreateViewBags(id);
ViewData["panel"] = 1;
return(RedirectToAction("Index"));
}
