public async Task<ActionResult> LoadDetailBankCashPaymentVoucher(string dataDetail, string act, string voucherNo)
{
string[] data = dataDetail.Split('|');
var model = new bankCashPaymentVoucher();
for (int i = 0; i < data.Count(); i++)
{
string[] value = data[i].Split(';');
if (value[1].ToString() == "")
break;
string idxRows = value[0].ToString();
string t_accountNo = value[1].ToString();
//string t_accountName = value[2].ToString();
decimal t_amount = value[2].ToString() != "" ? Convert.ToDecimal(value[2].ToString()) : 0;
var editor = new bankCashPaymentVoucher.bankCashPaymentVoucherDetail()
{
voucherNo = voucherNo,
accountNo = t_accountNo,
amount = t_amount
};
model.detailBankCashPaymentVoucher.Add(editor);
}
ViewData["dataDetail"] = model.detailBankCashPaymentVoucher.ToList();
ViewBag.COA = ccm.ddlAccountCOA(string.Empty);
return PartialView("_PartialPageBCP1");
}
protected void loadDetail(string id)
{
var model = new bankCashPaymentVoucher();
var tempDetail = db.bankCashPaymentVoucherDetails.Where(x => x.voucherNo == id).ToList();
foreach (var a in tempDetail)
{
string t_accountNo = a.accountNo;
decimal t_amount = Convert.ToDecimal(a.amount);
var editor = new bankCashPaymentVoucher.bankCashPaymentVoucherDetail()
{
accountNo = t_accountNo,
amount = t_amount
};
model.detailBankCashPaymentVoucher.Add(editor);
}
ViewData["dataDetail"] = model.detailBankCashPaymentVoucher.ToList();
}
public ActionResult Edit([Bind(Include="voucherNo,voucherDate,bankID,remarks,says,preparedBy,preparedDate,preparedStatus,checkedBy,checkedDate,checkedStatus,approvedBy,approvedDate,approvedStatus,acknowledgeBy,acknowledgeDate,acknowledgeStatus,createdUser,createdDate,modifiedUser,modifiedDate")] bankCashPaymentVoucher bankcashpaymentvoucher)
{
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 collect detail purchase request
var countChk = 0;
for (int i = 0; i < Request.Form.Count; i++)
{
if (Request.Form.AllKeys.ToList()[i].Contains("txtAccountNo_"))
countChk++;
}
var model = new bankCashPaymentVoucher();
for (int i = 1; i <= countChk; i++)
{
var colVal = Request.Form["txtAccountNo_" + i];
if (colVal == "")
break;
string t_accountNo = Request.Form["txtAccountNo_" + i].ToString();
decimal t_amount = Request.Form["txtAmount_" + i].ToString() != "" ? Convert.ToDecimal(Request.Form["txtAmount_" + i].ToString().Replace('.', ',')) : 0;
var editor = new bankCashPaymentVoucher.bankCashPaymentVoucherDetail()
{
voucherNo = "",
accountNo = t_accountNo,
amount = t_amount
};
model.detailBankCashPaymentVoucher.Add(editor);
}
ViewData["dataDetail"] = model.detailBankCashPaymentVoucher.ToList();
#endregion
ViewBag.Bank = ccm.ddlBank(bankcashpaymentvoucher.bankID.ToString());
ViewBag.COA = ccm.ddlAccountCOA(string.Empty);
if (ModelState.IsValid)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;
bankcashpaymentvoucher.modifiedUser = lvm.userID;
bankcashpaymentvoucher.modifiedDate = DateTime.Now;
db.Entry(bankcashpaymentvoucher).State = EntityState.Modified;
#region insertDetail
bool runFirst = true;
for (int i = 1; i <= countChk; i++)
{
if (runFirst == true)
{
db.bankCashPaymentVoucherDetails.RemoveRange(db.bankCashPaymentVoucherDetails.Where(x => x.voucherNo == bankcashpaymentvoucher.voucherNo));
runFirst = false;
}
var colVal = Request.Form["txtAccountNo_" + i];
if (colVal == "")
break;
string t_accountNo = Request.Form["txtAccountNo_" + i].ToString();
decimal t_amount = Request.Form["txtAmount_" + i].ToString() != "" ? Convert.ToDecimal(Request.Form["txtAmount_" + i].ToString().Replace('.', ',')) : 0;
var editor = new bankCashPaymentVoucher.bankCashPaymentVoucherDetail()
{
voucherNo = bankcashpaymentvoucher.voucherNo,
accountNo = t_accountNo,
amount = t_amount
};
db.bankCashPaymentVoucherDetails.Add(editor);
}
#endregion
db.SaveChanges();
ts.Complete();
}
return RedirectToAction("Index");
}
catch (Exception exc)
{
string a = exc.Message;
}
}
return View(bankcashpaymentvoucher);
}
public ActionResult Create([Bind(Include="voucherNo,voucherDate,bankID,remarks,says,preparedBy,preparedDate,preparedStatus,checkedBy,checkedDate,checkedStatus,approvedBy,approvedDate,approvedStatus,acknowledgeBy,acknowledgeDate,acknowledgeStatus,createdUser,createdDate,modifiedUser,modifiedDate")] bankCashPaymentVoucher bankcashpaymentvoucher)
{
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 collect detail bank cash
var countChk = 0;
for (int i = 0; i < Request.Form.Count; i++)
{
if (Request.Form.AllKeys.ToList()[i].Contains("txtAccountNo_"))
countChk++;
}
var model = new bankCashPaymentVoucher();
for (int i = 1; i <= countChk; i++)
{
var colVal = Request.Form["txtAccountNo_" + i];
if (colVal == "")
break;
string t_accountNo = Request.Form["txtAccountNo_" + i].ToString();
decimal t_amount = Request.Form["txtAmount_" + i].ToString() != "" ? Convert.ToDecimal(Request.Form["txtAmount_" + i].ToString().Replace('.', ',')) : 0;
var editor = new bankCashPaymentVoucher.bankCashPaymentVoucherDetail()
{
voucherNo = "",
accountNo = t_accountNo,
amount = t_amount
};
model.detailBankCashPaymentVoucher.Add(editor);
}
ViewData["dataDetail"] = model.detailBankCashPaymentVoucher.ToList();
#endregion
ViewBag.Bank = ccm.ddlBank(bankcashpaymentvoucher.bankID.ToString());
ViewBag.COA = ccm.ddlAccountCOA(string.Empty);
if (ModelState.IsValid)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
string generateID = prefix + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("d2");
var apvCreated = db.bankCashPaymentVouchers.Where(x => x.voucherNo.Contains(generateID)).OrderByDescending(x => x.createdDate).Select(x => x.voucherNo).ToList();
if (apvCreated.Count == 0)
{
generateID = generateID + "0001";
}
else
{
generateID = generateID + (Convert.ToInt32(apvCreated[0].Substring((apvCreated[0].Length - 4))) + 1).ToString().PadLeft(4, '0');
}
bankcashpaymentvoucher.voucherNo = generateID;
lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;
bankcashpaymentvoucher.createdUser = lvm.userID;
bankcashpaymentvoucher.createdDate = DateTime.Now;
bankcashpaymentvoucher.preparedBy = lvm.userID;
bankcashpaymentvoucher.preparedDate = DateTime.Now;
bankcashpaymentvoucher.preparedStatus = true;
db.bankCashPaymentVouchers.Add(bankcashpaymentvoucher);
#region insertDetail
for (int i = 1; i <= countChk; i++)
{
var colVal = Request.Form["txtAccountNo_" + i];
if (colVal == "")
break;
string t_accountNo = Request.Form["txtAccountNo_" + i].ToString();
decimal t_amount = Request.Form["txtAmount_" + i].ToString() != "" ? Convert.ToDecimal(Request.Form["txtAmount_" + i].ToString().Replace('.', ',')) : 0;
var editor = new bankCashPaymentVoucher.bankCashPaymentVoucherDetail()
{
voucherNo = bankcashpaymentvoucher.voucherNo,
accountNo = t_accountNo,
amount = t_amount
};
db.bankCashPaymentVoucherDetails.Add(editor);
}
#endregion
db.SaveChanges();
ts.Complete();
}
return RedirectToAction("Index");
}
catch (Exception exc)
{
string a = exc.Message;
}
}
return View(bankcashpaymentvoucher);
}