public ActionResult UpdateOpenBalance(OpenBal OpnBal) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("GL_OpenBal_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } var defAc = LoadDropDown.GetDefAc(); string eCode = ""; string isAsset = OpnBal.Accode.Substring(0, 1); if (isAsset == defAc.AssAc) { OpnBal.OpenBalance = OpnBal.OpenBalance; } else if (isAsset == defAc.LiaAc) { OpnBal.OpenBalance = OpnBal.OpenBalance * (-1); } using (var transaction = new TransactionScope()) { try { OpenBal UpOpnBal = new OpenBal(); UpOpnBal = _pR_OpenBalanceService.All().ToList().FirstOrDefault(x => x.Id == OpnBal.Id); if (UpOpnBal != null) { OpnBal.FinYear = Session["FinYear"].ToString(); Misclns.CopyPropertiesTo(OpnBal, UpOpnBal); _pR_OpenBalanceService.Update(UpOpnBal); _pR_OpenBalanceService.Save(); var THolidayID = UpOpnBal.Id; TransactionLogService.SaveTransactionLog(_transactionLogService, "OpenBal", "Update", THolidayID.ToString(), Session["UserName"].ToString()); eCode = "1"; } else { eCode = "2"; } transaction.Complete(); return(Json(eCode, JsonRequestBehavior.AllowGet)); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }
public ActionResult GetOpenBalForEdit(int OpenBalId) { try { OpenBal GLOB = new OpenBal(); var defAc = LoadDropDown.GetDefAc(); var Obal = _pR_OpenBalanceService.All().ToList().FirstOrDefault(x => x.Id == OpenBalId); string isAsset = Obal.Accode.Substring(0, 1); if (Obal != null) { GLOB.Id = Obal.Id; GLOB.ProjCode = Obal.ProjCode; GLOB.BranchCode = Obal.BranchCode; GLOB.Accode = Obal.Accode; if (isAsset == defAc.AssAc) { GLOB.OpenBalance = Obal.OpenBalance; } else if (isAsset == defAc.LiaAc) { GLOB.OpenBalance = Obal.OpenBalance * (-1); } } var serializerSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects }; string json = JsonConvert.SerializeObject(GLOB, Formatting.Indented, serializerSettings); if (GLOB != null && GLOB.Id > 0) { return(Json(json, JsonRequestBehavior.AllowGet)); } else { return(Json(new EmptyResult(), JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult SaveOpenBalance(OpenBal OpnBal) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("GL_OpenBal_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } string eCode = ""; var defAc = LoadDropDown.GetDefAc(); // Checking and operation Data for save database string isAsset = OpnBal.Accode.Substring(0, 1); if (isAsset == defAc.AssAc) { OpnBal.OpenBalance = OpnBal.OpenBalance; } else if (isAsset == defAc.LiaAc) { OpnBal.OpenBalance = OpnBal.OpenBalance * (-1); } using (var transaction = new TransactionScope()) { try { // query for check existing data and then if null go to transaction var objOpnBal = _pR_OpenBalanceService.All().ToList() .Where(x => x.Accode == OpnBal.Accode && x.BranchCode == OpnBal.BranchCode && x.ProjCode == OpnBal.ProjCode).ToList(); if (objOpnBal.Count == 0) { //// should not here , in setOpnBal OpnBal.FinYear = Session["FinYear"].ToString(); _pR_OpenBalanceService.Add(OpnBal); _pR_OpenBalanceService.Save(); var OpenBalanceID = 1; // not defined TransactionLogService.SaveTransactionLog(_transactionLogService, "SaveOpnBal", "Save", OpenBalanceID.ToString(), Session["UserName"].ToString()); eCode = "1"; } else { eCode = "2"; } transaction.Complete(); return(Json(eCode, JsonRequestBehavior.AllowGet)); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }