public ActionResult Edit(purchaseOrderHeader purchaseorderheader)
{
if (acm.cekSession() == false)
return RedirectToAction("Logout", "Account");
lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;
if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false)
return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() });
#region
//ViewBag.ddlVendor = DDLVendor(purchaseorderheader.vendorId);
ViewBag.ddlVendor = DDLVendorByPRId(purchaseorderheader.prId);
loadPO(purchaseorderheader.poId);
#endregion
if (ModelState.IsValid)
{
var countChk = 0;
var countChkMultiple = 0;
bool isProposed = false;
for (int i = 0; i < Request.Form.Count; i++)
{
if (Request.Form.AllKeys.ToList()[i].Contains("txtProductID_"))
countChk++;
else if (Request.Form.AllKeys.ToList()[i].Contains("hdnTypeSubmit"))
if (Request.Form["hdnTypeSubmit"].ToString() == "requested")
isProposed = true;
if (purchaseorderheader.topType == "Multiple")
if (Request.Form.AllKeys.ToList()[i].Contains("txtBuyDate_"))
countChkMultiple++;
}
try
{
using (TransactionScope ts = new TransactionScope())
{
lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;
purchaseorderheader.proposedStatus = isProposed;
purchaseorderheader.modifiedDate = DateTime.Now;
purchaseorderheader.modifiedUser = lvm.userID;
db.Entry(purchaseorderheader).State = EntityState.Modified;
#region insertDetail
bool runFirst = true;
for (int i = 1; i <= countChk; i++)
{
if (runFirst == true)
{
db.purchaseOrderDetails.RemoveRange(db.purchaseOrderDetails.Where(x => x.poId == purchaseorderheader.poId));
runFirst = false;
}
var colVal = Request.Form["txtProductID_" + i];
if (colVal == "")
break;
int t_productID = int.Parse(Request.Form["txtProductID_" + i].ToString());
int t_qty = Request.Form["txtQty_" + i].ToString() != "" ? Convert.ToInt32(Request.Form["txtQty_" + i].ToString().Replace('.', ',')) : 0;
decimal t_price = Request.Form["txtPrice_" + i].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(Request.Form["txtPrice_" + i].ToString().Replace('.', ','))) : 0;
decimal t_disc = Request.Form["txtDisc_" + i].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(Request.Form["txtDisc_" + i].ToString().Replace('.', ','))) : 0;
var editorx = new purchaseOrderHeader.purchaseOrderDetail()
{
poId = purchaseorderheader.poId,
productID = t_productID,
qty = t_qty,
price = t_price,
disc = t_disc
};
db.purchaseOrderDetails.Add(editorx);
}
#endregion
#region insertTOPMultiple
if (purchaseorderheader.topType == "Multiple")
{
runFirst = true;
for (int i = 0; i <= countChkMultiple; i++)
{
if (runFirst == true)
{
db.purchaseOrderTOPs.RemoveRange(db.purchaseOrderTOPs.Where(x => x.poId == purchaseorderheader.poId));
runFirst = false;
}
var colVal = Request.Form["txtBuyDate_" + i];
if (colVal == "")
break;
DateTime t_BuyDate = Convert.ToDateTime(Request.Form["txtBuyDate_" + i].ToString());
decimal t_BuyPercent = Request.Form["txtBuyPercent_" + i].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(Request.Form["txtBuyPercent_" + i].ToString().Replace('.', ','))) : 0;
var editort = new purchaseOrderHeader.purchaseOrderTop()
{
poId = purchaseorderheader.poId,
buyDate = t_BuyDate,
buyPercent = t_BuyPercent
};
db.purchaseOrderTOPs.Add(editort);
}
}
#endregion
db.SaveChanges();
ts.Complete();
}
return RedirectToAction("Index");
}
catch (Exception exc)
{
string a = exc.Message;
}
}
return View(purchaseorderheader);
}
public ActionResult Create(purchaseOrderHeader purchaseorderheader)
{
if (acm.cekSession() == false)
return RedirectToAction("Logout", "Account");
lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;
if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false)
return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() });
//ViewBag.ddlVendor = DDLVendor(string.Empty);
ViewBag.ddlVendor = DDLVendorByPRId(purchaseorderheader.prId);
var xz = db.purchaseRequestHeaders.AsNoTracking().Where(x => !db.purchaseOrderHeaders.Any(y => y.prId == x.prId) && x.proposedStatus == true && x.approvedStatus == true)
//.Join(db.departments, a => a.requestDeptId, b => b.deptID, (a, b) => new { a, b }) ~old process ~sweeping department kebalik dgn divisi
.Join(db.divisis, a => a.requestDeptId, b => b.divisiID, (a, b) => new { a, b })
.Select(c => new { c.a.prId, c.a.requestDeptId, deptName = c.b.divisiName, c.a.typeOrder, c.a.proposalInclude, c.a.specialInstruction, c.a.projectTimeDelivery }).ToList();
ViewData["PRPopUp"] = xz;
var model = new purchaseOrderHeader();
var editor = new purchaseOrderHeader.prPopUp()
{
prId = xz[0].prId,
requestDeptId = xz[0].requestDeptId,
deptName = xz[0].deptName,
typeOrder = xz[0].typeOrder,
proposalInclude = xz[0].proposalInclude,
specialInstruction = xz[0].specialInstruction,
projectTimeDelivery = xz[0].projectTimeDelivery
};
model.PopUpPR.Add(editor);
ViewBag.PRPopUp = model.PopUpPR.ToList();
var modelx = new purchaseRequestHeader();
foreach (var a in db.purchaseRequestDetails.Where(x => x.prId == purchaseorderheader.prId).ToList() as IEnumerable<purchaseRequestHeader.purchaseRequestDetail>)
{
var editorx = new purchaseRequestHeader.purchaseRequestDetail()
{
productId = a.productId,
description = a.description,
qty = a.qty,
unit = a.unit
};
modelx.detailPurchaseRequest.Add(editorx);
}
ViewData["dataDetail"] = modelx.detailPurchaseRequest.ToList();
if (ModelState.IsValid)
{
var countChk = 0;
var countChkMultiple = 0;
bool isProposed = false;
for (int i = 0; i < Request.Form.Count; i++)
{
if (Request.Form.AllKeys.ToList()[i].Contains("txtProductID_"))
countChk++;
else if (Request.Form.AllKeys.ToList()[i].Contains("hdnTypeSubmit"))
if (Request.Form["hdnTypeSubmit"].ToString() == "requested")
isProposed = true;
if (purchaseorderheader.topType == "Multiple")
if (Request.Form.AllKeys.ToList()[i].Contains("txtBuyDate_"))
countChkMultiple++;
}
try
{
using (TransactionScope ts = new TransactionScope())
{
string generateID = prefix + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("d2");
var prIDCreated = db.purchaseOrderHeaders.Where(x => x.poId.Contains(generateID)).OrderByDescending(x => x.createdDate).Select(x => x.poId).ToList();
if (prIDCreated.Count == 0)
{
generateID = generateID + "0001";
}
else
{
generateID = generateID + (Convert.ToInt32(prIDCreated[0].Substring((prIDCreated[0].Length - 4))) + 1).ToString().PadLeft(4, '0');
}
#region ubah vendorID ke vendorCode
int idVendor = 0;
try{
idVendor = int.Parse(purchaseorderheader.vendorId) * 1;
}
catch
{
}
if(idVendor > 0 )
{
var ven = db.vendors.AsNoTracking().Where(x => x.id == idVendor).ToList();
purchaseorderheader.vendorId = ven[0].vendorID;
}
#endregion
purchaseorderheader.poId = generateID;
lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;
purchaseorderheader.createdDate = DateTime.Now;
purchaseorderheader.createdUser = lvm.userID;
purchaseorderheader.proposedBy = lvm.userID;
purchaseorderheader.proposedDate = DateTime.Now;
purchaseorderheader.proposedStatus = isProposed;
db.purchaseOrderHeaders.Add(purchaseorderheader);
#region insertDetail
for (int i = 1; i <= countChk; i++)
{
var colVal = Request.Form["txtProductID_" + i];
if (colVal == "")
break;
int t_productID = int.Parse(Request.Form["txtProductID_" + i].ToString());
int t_qty = Request.Form["txtQty_" + i].ToString() != "" ? Convert.ToInt32(Request.Form["txtQty_" + i].ToString().Replace('.', ',')) : 0;
decimal t_price = Request.Form["txtPrice_" + i].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(Request.Form["txtPrice_" + i].ToString().Replace('.', ','))) : 0;
decimal t_disc = Request.Form["txtDisc_" + i].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(Request.Form["txtDisc_" + i].ToString().Replace('.', ','))) : 0;
var editorx = new purchaseOrderHeader.purchaseOrderDetail()
{
poId = purchaseorderheader.poId,
productID = t_productID,
qty = t_qty,
price = t_price,
disc = t_disc
};
db.purchaseOrderDetails.Add(editorx);
}
#endregion
#region insertTOPMultiple
if(purchaseorderheader.topType == "Multiple")
{
for (int i = 0; i < countChkMultiple; i++)
{
var colVal = Request.Form["txtBuyDate_" + i];
if (colVal == "")
break;
DateTime t_BuyDate = Convert.ToDateTime(Request.Form["txtBuyDate_" + i].ToString());
decimal t_BuyPercent = Request.Form["txtBuyPercent_" + i].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(Request.Form["txtBuyPercent_" + i].ToString().Replace('.', ','))) : 0;
var editort = new purchaseOrderHeader.purchaseOrderTop()
{
poId = purchaseorderheader.poId,
buyDate = t_BuyDate,
buyPercent = t_BuyPercent
};
db.purchaseOrderTOPs.Add(editort);
}
}
#endregion
db.SaveChanges();
ts.Complete();
}
return RedirectToAction("Index");
}
catch (Exception exc)
{
string a = exc.Message;
}
}
return View(purchaseorderheader);
}
