public async Task<ActionResult> LoadDetailCategoryProducts(string dataDetail, string act)
        {
            string[] data = dataDetail.Split('|');
            
            var model = new journalHeader();
            for (int i = 0; i < data.Count(); i++ )
            {
                string[] value = data[i].Split(';');

                if (value[1].ToString() == "")
                    break;

                int idCoa = Convert.ToInt32(value[1].ToString());
                string othrAccountName = value[2].ToString();
                string remak = value[3].ToString();
                decimal debt = value[4].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(value[4].ToString().Replace('.', ','))) : 0;
                decimal credt = value[5].ToString() != "" ? Convert.ToDecimal(Convert.ToDouble(value[5].ToString().Replace('.', ','))) : 0;

                var editor = new journalHeader.journalDetail()
                {
                    coaId = idCoa,
                    accountNameOther = othrAccountName,
                    remarks = remak,
                    debit = debt,
                    credit = credt
                };
                model.detailJournal.Add(editor);

                ViewData["ddlAccount" + (i + 1)] = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { x.id, accountName = x.accountName + " [" + x.accountNo + "]" }), "id", "accountName", idCoa);
            }
            ViewData["dataDetail"] = model.detailJournal.ToList();

            //ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { x.id, accountName = /*"[" + */x.accountNo/* + "] " +  x.accountName */ }), "id", "accountName");
            ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { id = x.id + "-" + x.accountName, accountName = x.accountName + " [" + x.accountNo + "]" }), "id", "accountName");
            //var lookupId = int.Parse(categoryId);
            ////var model = await this.GetFullAndPartialViewModel(lookupId);
            return PartialView("_PartialPage1");
        }
        // GET: /JournalAdjustment/Delete/5
        public ActionResult Delete(string id)
        {
            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() });

            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            journalHeader journalheader = db.journalHeaders.Find(id);
            if (journalheader == null)
            {
                return HttpNotFound();
            }

            #region getDataDetail
            var data = db.journalDetails.Where(x => x.voucherNo == id).ToList();
            var model = new journalHeader();
            for (int i = 0; i < data.Count(); i++)
            {
                int idCoa = Convert.ToInt32(data[i].coaId.ToString());
                string othrAccountName = data[i].accountNameOther.ToString();
                string remak = data[i].remarks.ToString();
                decimal debt = Convert.ToDecimal(data[i].debit.ToString());
                decimal credt = Convert.ToDecimal(data[i].credit.ToString());

                var coaName = db.chartOfAccounts.Where(x => x.id == idCoa).ToList();
                var editor = new journalHeader.journalDetail()
                {
                    coaId = idCoa,
                    accountNameOther = coaName[0].accountName/*othrAccountName*/,
                    remarks = remak,
                    debit = debt,
                    credit = credt
                };
                model.detailJournal.Add(editor);

                //ViewData["ddlAccount" + (i + 1)] = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { x.id, accountName = /*"[" + */x.accountNo/* + "] " +  x.accountName */ }), "id", "accountName", idCoa);
                ViewData["ddlAccount" + (i + 1)] = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { id = x.id + "-" + x.accountName, accountName = x.accountNo }), "id", "accountName", (idCoa + "-" + coaName[0].accountName));
            }
            ViewData["dataDetail"] = model.detailJournal.ToList();

            //ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { x.id, accountName = /*"[" + */x.accountNo/* + "] " +  x.accountName */ }), "id", "accountName");
            ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { id = x.id + "-" + x.accountName, accountName = x.accountNo }), "id", "accountName");
            #endregion

            return View(journalheader);
        }
        public ActionResult Edit([Bind(Include = "voucherNo,voucherDate,journalType,remark,createdDate,createdUser,modifiedDate,modifiedUser")] journalHeader journalheader, string hdnTotalRows)
        {
            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 journal
            var countChk = 0;
            for (int i = 0; i < Request.Form.Count; i++)
            {
                if (Request.Form.AllKeys.ToList()[i].Contains("ddlAccount_"))
                    countChk++;
            }

            var model = new journalHeader();
            for (int i = 1; i <= countChk; i++)
            {
                var ddlValue = Request.Form["ddlAccount_" + i];
                if (ddlValue == "")
                    break;

                var acctName = Request.Form["txtAccountName_" + i];
                var remark = Request.Form["txtRemark_" + i];
                var debit = Request.Form["txtDebit_" + i].Trim() == "" ? "0" : Request.Form["txtDebit_" + i];
                var credit = Request.Form["txtCredit_" + i].Trim() == "" ? "0" : Request.Form["txtCredit_" + i];

                string[] ddlVal = ddlValue.ToString().Split('-');
                var editor = new journalHeader.journalDetail()
                {
                    coaId = Convert.ToInt32(ddlVal[0].ToString()),
                    accountNameOther = acctName.ToString(),
                    remarks = remark.ToString(),
                    debit = Convert.ToDecimal(Convert.ToDouble(debit.ToString().Replace('.', ','))),
                    credit = Convert.ToDecimal(Convert.ToDouble(credit.ToString().Replace('.', ',')))
                };
                model.detailJournal.Add(editor);

                ViewData["ddlAccount_" + i] = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { x.id, accountName = /*"[" + */x.accountNo/* + "] " +  x.accountName */ }), "id", "accountName", ddlValue);
            }
            ViewData["dataDetail"] = model.detailJournal.ToList();
            #endregion

            ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { id = x.id + "-" + x.accountName, accountName = x.accountName + " [" + x.accountNo + "]" }), "id", "accountName");
            if (ModelState.IsValid)
            {
                lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;

                try
                {
                    using (TransactionScope ts = new TransactionScope())
                    {
                        var ids = db.journalHeaders.AsNoTracking().Where(x => x.voucherNo == journalheader.voucherNo).ToList();
                        long id = ids[0].id;

                        journalheader.id = id;
                        journalheader.modifiedDate = DateTime.Now;
                        journalheader.modifiedUser = lvm.userID;
                        db.Entry(journalheader).State = EntityState.Modified;
                        //db.SaveChanges();

                        #region insertDetail
                        bool runFirst = true;
                        for (int i = 1; i <= countChk; i++)
                        {
                            if (runFirst == true)
                            {                                
                                db.journalDetails.RemoveRange(db.journalDetails.Where(x => x.voucherNo == journalheader.voucherNo));
                                //db.SaveChanges();
                                runFirst = false;
                            }

                            var ddlValue = Request.Form["ddlAccount_" + i];
                            if (ddlValue == "" || ddlValue == null)
                                break;

                            var acctName = Request.Form["txtAccountName_" + i];
                            var remark = Request.Form["txtRemark_" + i];
                            var debit = Request.Form["txtDebit_" + i].Trim() == "" ? "0" : Request.Form["txtDebit_" + i];
                            var credit = Request.Form["txtCredit_" + i].Trim() == "" ? "0" : Request.Form["txtCredit_" + i];
                            
                            string[] ddlVal = ddlValue.ToString().Split('-');
                            db.journalDetails.Add(new journalHeader.journalDetail()
                            {
                                voucherNo = journalheader.voucherNo,
                                //coaId = Convert.ToInt32(ddlValue.ToString()),
                                coaId = Convert.ToInt32(ddlVal[0].ToString()),
                                accountNameOther = acctName.ToString(),
                                remarks = remark.ToString(),
                                debit = Convert.ToDecimal(Convert.ToDouble(debit.ToString().Replace('.', ','))),
                                credit = Convert.ToDecimal(Convert.ToDouble(credit.ToString().Replace('.', ',')))
                            });
                        }
                        #endregion

                        db.SaveChanges();
                        ts.Complete();
                    }
                    return RedirectToAction("Index");
                }
                catch(Exception exc)
                {

                }
            }
            return View(journalheader);
        }
        public ActionResult Create([Bind(Include = "voucherNo,voucherDate,journalType,remark,createdDate,createdUser,modifiedDate,modifiedUser")] journalHeader journalheader, string hdnTotalRows)
        {
            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.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { x.id, accountName = x.accountName + " [" + x.accountNo + "]" }), "id", "accountName");
            ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { id = x.id + "-" + x.accountName, accountName = x.accountName + " [" + x.accountNo + "]" }), "id", "accountName");

            #region collect detail journal
            var countChk = 0;
            for (int i = 0; i < Request.Form.Count; i++)
            {
                if (Request.Form.AllKeys.ToList()[i].Contains("ddlAccount_"))
                    countChk++;
            }

            var model = new journalHeader();
            for (int i = 1; i <= countChk; i++)
            {
                var ddlValue = Request.Form["ddlAccount_"+i];
                if (ddlValue == "")
                    break;

                var acctName = Request.Form["txtAccountName_" + i];
                var remark = Request.Form["txtRemark_" + i];
                var debit = Request.Form["txtDebit_" + i].Trim() == "" ? "0" : Request.Form["txtDebit_" + i];
                var credit = Request.Form["txtCredit_" + i].Trim() == "" ? "0" : Request.Form["txtCredit_" + i];

                string[] ddlVal = ddlValue.ToString().Split('-');
                var editor = new journalHeader.journalDetail()
                {
                    coaId = Convert.ToInt32(ddlVal[0].ToString()),
                    accountNameOther = acctName.ToString(),
                    remarks = remark.ToString(),
                    debit = Convert.ToDecimal(Convert.ToDouble(debit.ToString().Replace('.', ','))),
                    credit = Convert.ToDecimal(Convert.ToDouble(credit.ToString().Replace('.', ',')))
                };
                model.detailJournal.Add(editor);

                ViewData["ddlAccount_" + i] = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountNo != "").Select(x => new { x.id, accountName = /*"[" + */x.accountNo/* + "] " +  x.accountName */ }), "id", "accountName", ddlValue);
            }
            ViewData["dataDetail"] = model.detailJournal.ToList();
            #endregion 

            if (ModelState.IsValid)
            {
                lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin;

                try
                {
                    using(TransactionScope ts = new TransactionScope())
                    {
                        string vouchNo = "ADJ" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString("d2");
                        //var voucherNoCreated = db.journalHeaders.Where(x => x.voucherNo.Contains("ADJ")).OrderByDescending(x => x.id).Select(x => x.id).ToList();
                        var voucherNoCreated = db.journalHeaders.Where(x => x.voucherNo.Contains(vouchNo)).OrderByDescending(x => x.id).Select(x => x.voucherNo).ToList();
                        if (voucherNoCreated.Count == 0)
                        {
                            journalheader.voucherNo = "ADJ" + DateTime.Now.Year + DateTime.Now.Month.ToString("d2") + "0001";
                        }
                        else
                        {
                            journalheader.voucherNo = "ADJ" + DateTime.Now.Year + DateTime.Now.Month.ToString("d2") + (Convert.ToInt32(voucherNoCreated[0].Substring((voucherNoCreated[0].Length - 4))) + 1).ToString().PadLeft(4, '0');
                        }

                        journalheader.createdDate = DateTime.Now;
                        journalheader.createdUser = "";
                        db.journalHeaders.Add(journalheader);
                        db.SaveChanges();

                        if (journalheader.id > 0)//var groupIdH = db.UserGroupHs.OrderByDescending(x => x.id).Select(x => x.id).First(); <--cara lain
                        {
                            #region insertDetail
                            for (int i = 1; i <= countChk; i++)
                            {
                                var ddlValue = Request.Form["ddlAccount_" + i];
                                if (ddlValue == "" || ddlValue == null)
                                    break;

                                var acctName = Request.Form["txtAccountName_" + i];
                                var remark = Request.Form["txtRemark_" + i];
                                var debit = Request.Form["txtDebit_" + i].Trim() == "" ? "0" : Request.Form["txtDebit_" + i];
                                var credit = Request.Form["txtCredit_" + i].Trim() == "" ? "0" : Request.Form["txtCredit_" + i];

                                
                                string[] ddlVal = ddlValue.ToString().Split('-');
                                db.journalDetails.Add(new journalHeader.journalDetail()
                                {
                                    voucherNo = journalheader.voucherNo,
                                    //coaId = Convert.ToInt32(ddlValue.ToString()),
                                    coaId = Convert.ToInt32(ddlVal[0].ToString()),
                                    accountNameOther = acctName.ToString(),
                                    remarks = remark.ToString(),
                                    debit = Convert.ToDecimal(Convert.ToDouble(debit.ToString().Replace('.', ','))),
                                    credit = Convert.ToDecimal(Convert.ToDouble(credit.ToString().Replace('.', ',')))//Convert.ToInt32(credit.ToString())
                                });
                            }
                            db.SaveChanges();
                            #endregion
                        }

                        ts.Complete();
                    }
                    return RedirectToAction("Index");
                }
                catch(Exception exc)
                {
                    string a = exc.Message;
                }
            }

            return View(journalheader);
        }