private string SaveItemSSGrp(VMMasterForm MstrInf) { var DesigCode = _designationService.All().ToList().FirstOrDefault(x => x.DesigCode == MstrInf.Code); if (DesigCode == null) { Designation _desig = new Designation(); _desig.DesigCode = MstrInf.Code; _desig.DesigName = MstrInf.Name; _desig.DesigLocalName = MstrInf.LocalName; _desig.DesigDesc = MstrInf.Descr; _designationService.Add(_desig); _designationService.Save(); var DesigID = _desig.DesigID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveDesignationInfo", DesigID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("2"); } }
private string SaveBranchInfo(VMMasterForm MstrInf) { var BrCode = _brInfoService.All().ToList().FirstOrDefault(x => x.BranchCode == MstrInf.Code); if (BrCode == null) { Branch _brInfo = new Branch(); _brInfo.BranchCode = MstrInf.Code; _brInfo.BranchName = MstrInf.Name; _brInfo.BrLocalName = MstrInf.LocalName; _brInfo.BrAddress = MstrInf.Descr; _brInfoService.Add(_brInfo); _brInfoService.Save(); var BrID = _brInfo.BrID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveBranchInfo", BrID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("2"); } }
private string SaveUnitInfo(VMMasterForm MstrInf) { var UnitCode = _unitInfoService.All().ToList().FirstOrDefault(x => x.UnitCode == MstrInf.Code); if (UnitCode == null) { UnitInfo _unit = new UnitInfo(); _unit.UnitCode = MstrInf.Code; _unit.UnitName = MstrInf.Name; _unit.UnitLocalName = MstrInf.LocalName; _unit.UnitDesc = MstrInf.Descr; _unitInfoService.Add(_unit); _unitInfoService.Save(); var UnitID = _unit.UnitID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveUnitInfo", UnitID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("2"); } }
private string UpdateLocationInfo(VMMasterForm MstrInf) { var LocInfo = _LocationService.All().ToList().FirstOrDefault(x => x.LocId == MstrInf.ID); if (LocInfo != null) { var DsgInfList = _LocationService.All().ToList().Where(c => c.LocId != MstrInf.ID).ToList(); var IsCodExst = DsgInfList.FirstOrDefault(x => x.LocCode == MstrInf.Code); if (IsCodExst == null) { LocInfo.LocName = MstrInf.Name; _LocationService.Update(LocInfo); _LocationService.Save(); var DesigID = LocInfo.LocCode; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateDesignationInfo", DesigID, Session["UserName"].ToString()); return("1"); } else { return("3"); } } else { return("2"); } }
private string SaveProjectInfo(VMMasterForm MstrInf) { var ProjCode = _projInfoService.All().ToList().FirstOrDefault(x => x.ProjCode == MstrInf.Code); if (ProjCode == null) { ProjInfo _proj = new ProjInfo(); _proj.ProjCode = MstrInf.Code; _proj.ProjName = MstrInf.Name; _proj.ProjLocalName = MstrInf.LocalName; _proj.ProjDescrip = MstrInf.Descr; _projInfoService.Add(_proj); _projInfoService.Save(); var ProjID = _proj.ProjID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveProjectInfo", ProjID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("2"); } }
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 SaveVM_Adjustment(VM_Adjustment VM_Adjustment) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("VMAdjustment_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } string content = "An error occured during the save."; var serSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects }; string jsonCov = JsonConvert.SerializeObject(VM_Adjustment, Formatting.Indented, serSettings); HttpResponseMessage response = GlobalVariabls.VatApiClient.PostAsJsonAsync("VM_Adjustment/PostVM_Adjustment", VM_Adjustment).Result; content = response.StatusCode.ToString(); if (content == "OK") { TransactionLogService.SaveTransactionLog(_transactionLogService, "VDS Payment", "Save", VM_Adjustment.AdjNo, Session["UserName"].ToString()); return(Json("1", JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(ex.ToString(), JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateVM_TrDep(VM_TrDep VM_TrDep) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("TreasuryChallan_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } string content = "An error occured during the update."; var serializerSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects }; string json = JsonConvert.SerializeObject(VM_TrDep, Formatting.Indented, serializerSettings); HttpResponseMessage response = GlobalVariabls.VatApiClient.PutAsJsonAsync("VM_TrDep/PutVM_TrDep", VM_TrDep).Result; content = response.StatusCode.ToString(); if (content == "OK") { TransactionLogService.SaveTransactionLog(_transactionLogService, "VM Treasury Challan", "Update", VM_TrDep.TrDepNo, Session["UserName"].ToString()); return(Json("1", JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(ex.ToString(), JsonRequestBehavior.AllowGet)); } }
public ActionResult PostCancel(string InvoiceNo, string CancelType) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("MRCancel")) { return(Json("C", JsonRequestBehavior.AllowGet)); } string ReturnSTR = ""; using (AcclineERPContext dbContext = new AcclineERPContext()) { var resultParameter = new SqlParameter("@ReturnMSG", SqlDbType.VarChar, 300) { Direction = ParameterDirection.Output }; dbContext.Database.ExecuteSqlCommand("MRCancel @MRNo, @ReturnMSG out", new SqlParameter("@MRNo", InvoiceNo), resultParameter); ReturnSTR = (string)resultParameter.Value; TransactionLogService.SaveTransactionLog(_transactionLogService, "Cancel", "MRCancel", InvoiceNo, Session["UserName"].ToString()); } return(Json(ReturnSTR, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteRateChart(int Id) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("GL_OpenBal_Delete")) { return(Json("D", JsonRequestBehavior.AllowGet)); } using (var transaction = new TransactionScope()) { try { var IsExist = _RateChartService.All().ToList().FirstOrDefault(x => x.RateChartId == Id); if (IsExist != null) { _RateChartService.Delete(IsExist); _RateChartService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "RateChart", "Delete", Session["UserName"].ToString(), Session["FinYear"].ToString()); } else { return(Json("2", JsonRequestBehavior.AllowGet)); } transaction.Complete(); return(Json("1", JsonRequestBehavior.AllowGet)); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }
private string SaveDepartmentInfo(VMMasterForm MstrInf) { var DeptCode = _departmentService.All().ToList().FirstOrDefault(x => x.DeptCode == MstrInf.Code); if (DeptCode == null) { Department _dept = new Department(); _dept.DeptCode = MstrInf.Code; _dept.DeptName = MstrInf.Name; _dept.DeptLocalName = MstrInf.LocalName; _dept.DeptDesc = MstrInf.Descr; _departmentService.Add(_dept); _departmentService.Save(); var DeptID = _dept.DeptID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveDepartmentInfo", DeptID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("2"); } }
public ActionResult SaveItem(ItemInfo item) { //if (ModelState.IsValid) //{ using (var transaction = new TransactionScope()) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("Item_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } var items = _ItemInfoService.All().ToList().FirstOrDefault(x => x.ItemCode == item.ItemCode && x.ItemName == item.ItemName); if (items == null) { _ItemInfoService.Add(item); ItemMap iM = new ItemMap(); iM.ItemTypeCode = (int)item.ItemType; iM.GroupID = item.GroupID; iM.SGroupID = item.SGroupID; iM.SSGroupID = item.SSGroupID; iM.ItemCode = item.ItemCode; var serializerSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects }; string json = JsonConvert.SerializeObject(iM, Formatting.Indented, serializerSettings); HttpResponseMessage response = GlobalVariabls.WebApiClient.PostAsJsonAsync("ItemMaps/PostItemMap", iM).Result; _ItemInfoService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Item", "Save", item.ItemCode, Session["UserName"].ToString()); transaction.Complete(); return(Json("1", JsonRequestBehavior.AllowGet)); } else { return(Json("Item already exists!!!", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } //} //else //{ // return Json("0", JsonRequestBehavior.AllowGet); //} } }
public ActionResult UpdateBankReceipt(BankReceipt bankReceipt) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankReceipt_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); var gset = _gsetService.All().LastOrDefault(); try { bankReceipt.BranchCode = Session["BranchCode"].ToString(); bankReceipt.FinYear = Session["FinYear"].ToString(); bankReceipt.bankAccode = Session["BankAccode"].ToString(); bankReceipt.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.purAccode.Trim()); bankReceipt.bankNewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.bankAccode.Trim()); using (var transaction = new TransactionScope()) { try { _BankReceiptAppService.Update(bankReceipt); _BankReceiptAppService.Save(); //delete to provision //var entryNo = Convert.ToInt64(bankReceipt.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0'); var entryNo = bankReceipt.BReceiptNo; LoadDropDown.journalVoucherRemoval("BR", entryNo, bankReceipt.VoucherNo, bankReceipt.FinYear); var sysSet = _sysSetService.All().FirstOrDefault(); if (sysSet.CashRule == "O") { LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString()); } //insert to provision LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "Bank Receipt", "Update", bankReceipt.BReceiptNo, User.Identity.Name); CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetBackupDB() { if (Session["UserID"] != null) { // read connectionstring from config file var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; // read backup folder from config file ("C:/BackupDB/") var backupFolder = ConfigurationManager.AppSettings["BackupFolder"]; var sqlConStrBuilder = new SqlConnectionStringBuilder(connectionString); // set backupfilename (you will get something like: "C:/temp/MyDatabase-2013-12-07.bak") var backupFileName = String.Format("{0}{1}-{2}.bak", backupFolder, sqlConStrBuilder.InitialCatalog, DateTime.Now.ToString("yyyy-MM-dd")); using (var connection = new SqlConnection(sqlConStrBuilder.ConnectionString)) { var query = String.Format("BACKUP DATABASE {0} TO DISK='{1}'", sqlConStrBuilder.InitialCatalog, backupFileName); using (var command = new SqlCommand(query, connection)) { connection.Open(); command.ExecuteNonQuery(); } } string PhyscPath = backupFileName; try { byte[] fileByte = System.IO.File.ReadAllBytes(PhyscPath); string DownFileName = String.Format("{0}_{1}.bak", sqlConStrBuilder.InitialCatalog, DateTime.Now.ToString("yyyy-MM-dd")); TransactionLogService.SaveTransactionLog(_transactionLogService, "BackupDB", "", "01", Session["UserName"].ToString()); return(File(fileByte, System.Net.Mime.MediaTypeNames.Application.Octet, DownFileName)); } catch (Exception) { return(RedirectToAction("BackupDB", "BackupDB")); } finally { System.IO.File.Delete(backupFileName); } } else { return(RedirectToAction("SecUserLogin", "SecUserLogin")); } }
public ActionResult Save(RateChart RateChart) { //RBACUser rUser = new RBACUser(Session["UserName"].ToString()); //if (!rUser.HasPermission("")) //{ // return Json("X", JsonRequestBehavior.AllowGet); //} string eCode = ""; using (var transaction = new TransactionScope()) { try { // query for check existing data and then if null go to transaction var objRateChart = _RateChartService.All().ToList() .Where(x => x.ItemCode == RateChart.ItemCode && x.CustCode == RateChart.CustCode).ToList(); //if (objRateChart.Count == 0) if (objRateChart.Count == 0) { RateChart SaveRateChart = new RateChart(); Misclns.CopyPropertiesTo(RateChart, SaveRateChart); _RateChartService.Add(SaveRateChart); _RateChartService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "RateChart", "Save", DateTime.Now.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 UpdateHOR(HORemit hoRemit) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("Remittance_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); var gset = _gsetService.All().LastOrDefault(); try { hoRemit.BranchCode = Session["BranchCode"].ToString(); hoRemit.FinYear = Session["FinYear"].ToString(); hoRemit.bankAccode = Session["BankAccode"].ToString(); using (var transaction = new TransactionScope()) { try { _hoRemitService.Update(hoRemit); _hoRemitService.Save(); //Delete to provition // var entryNo = Convert.ToInt64(hoRemit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0'); var entryNo = hoRemit.RemitNo; LoadDropDown.journalVoucherRemoval("RT", entryNo, hoRemit.VoucherNo, hoRemit.FinYear); //Insert to provision LoadDropDown.journalVoucherSave("RT", "I", hoRemit.RemitNo, hoRemit.VoucherNo, hoRemit.FinYear, "01", hoRemit.BranchCode, hoRemit.RemitDate, gset.GCA_HO, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "HORemittance", "Update", hoRemit.RemitNo, User.Identity.Name); CashOPVM = GetAllRemittances(hoRemit.RemitDate, hoRemit.BranchCode, hoRemit.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteMasterRecord(string Type, string DeleteID) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("MasterInformation_Delete")) { return(Json("D", JsonRequestBehavior.AllowGet)); } using (var transaction = new TransactionScope()) { try { //DeleteMemberImages(MemberId); int DelStatus = 0; using (AcclineERPContext dbContext = new AcclineERPContext()) { var resultParameter = new SqlParameter("@Result", SqlDbType.Int) { Direction = ParameterDirection.Output }; dbContext.Database.ExecuteSqlCommand("MasterRecordDelete @Type, @DeleteID, @Result out", new SqlParameter("@Type", Type), new SqlParameter("@DeleteID", DeleteID), resultParameter); DelStatus = (int)resultParameter.Value; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "Delete", string.Empty, Session["UserName"].ToString()); } transaction.Complete(); return(Json(DelStatus, JsonRequestBehavior.AllowGet)); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }
public ActionResult UpdateItem(ItemInfo item) { using (var transaction = new TransactionScope()) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("Item_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } _ItemInfoService.Update(item); _ItemInfoService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Item", "Update", item.ItemCode, Session["UserName"].ToString()); ItemMap ItemMap = new ItemMap(); ItemMap.Id = item.Id; ItemMap.ItemTypeCode = (int)item.ItemType; ItemMap.GroupID = item.GroupID; ItemMap.SGroupID = item.SGroupID; ItemMap.SSGroupID = item.SSGroupID; ItemMap.ItemCode = item.ItemCode; var serializerSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects }; string json = JsonConvert.SerializeObject(ItemMap, Formatting.Indented, serializerSettings); HttpResponseMessage response = GlobalVariabls.WebApiClient.PutAsJsonAsync("ItemMaps/" + item.Id, ItemMap).Result; transaction.Complete(); return(Json("1", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }
public ActionResult SaveVat4P3(Vat4P3 Vat4P3, List <CM_Ingredient> CMIngredient, List <CM_CostExp> CMCostExp) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("CostSheet_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } #region For VAT VM_4P3 VM_4P3VM VM_4P3VM = new VM_4P3VM(); VM_4P3VM.VM_4P3 = Vat4P3; VM_4P3VM.CM_CostExp = CMCostExp; VM_4P3VM.CM_Ingredient = CMIngredient; string content = "An error occured during the save."; var serSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects }; string jsonCov = JsonConvert.SerializeObject(VM_4P3VM, Formatting.Indented, serSettings); HttpResponseMessage response = GlobalVariabls.VatApiClient.PostAsJsonAsync("VM_4P3/PostVM_4P3", VM_4P3VM).Result; content = response.StatusCode.ToString(); if (content == "OK") { TransactionLogService.SaveTransactionLog(_transactionLogService, "Vat 4.3", "Save", Vat4P3.DeclarationNo, Session["UserName"].ToString()); return(Json(new { Msg = "1", returnValue = "4.3;" }, JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } #endregion } catch (Exception ex) { return(Json(ex.ToString(), JsonRequestBehavior.AllowGet)); } }
private string UpdateDesignationInfo(VMMasterForm MstrInf) { var DesigInfo = _designationService.All().ToList().FirstOrDefault(x => x.DesigID == MstrInf.ID); if (DesigInfo != null) { var DsgInfList = _designationService.All().ToList().Where(c => c.DesigID != MstrInf.ID).ToList(); var IsCodExst = DsgInfList.FirstOrDefault(x => x.DesigCode == MstrInf.Code); if (IsCodExst == null) { DesigInfo.DesigCode = MstrInf.Code; DesigInfo.DesigName = MstrInf.Name; DesigInfo.DesigLocalName = MstrInf.LocalName; DesigInfo.DesigDesc = MstrInf.Descr; _designationService.Update(DesigInfo); _designationService.Save(); var DesigID = DesigInfo.DesigID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateDesignationInfo", DesigID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("3"); } } else { return("2"); } }
private string UpdateBranchInfo(VMMasterForm MstrInf) { var BrInfo = _brInfoService.All().ToList().FirstOrDefault(x => x.BrID == MstrInf.ID); if (BrInfo != null) { var BInfList = _brInfoService.All().ToList().Where(c => c.BrID != MstrInf.ID).ToList(); var IsCodExst = BInfList.FirstOrDefault(x => x.BranchCode == MstrInf.Code); if (IsCodExst == null) { //BrInfo.BranchCode = MstrInf.Code; BrInfo.BranchName = MstrInf.Name; BrInfo.BrLocalName = MstrInf.LocalName; BrInfo.BrAddress = MstrInf.Descr; _brInfoService.Update(BrInfo); _brInfoService.Save(); var BrID = BrInfo.BrID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateBranchInfo", BrID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("3"); } } else { return("2"); } }
private string UpdateProjectInfo(VMMasterForm MstrInf) { var ProjInfo = _projInfoService.All().ToList().FirstOrDefault(x => x.ProjID == MstrInf.ID); if (ProjInfo != null) { var PInfList = _projInfoService.All().ToList().Where(c => c.ProjID != MstrInf.ID).ToList(); var IsCodExst = PInfList.FirstOrDefault(x => x.ProjCode == MstrInf.Code); if (IsCodExst == null) { ProjInfo.ProjCode = MstrInf.Code; ProjInfo.ProjName = MstrInf.Name; ProjInfo.ProjLocalName = MstrInf.LocalName; ProjInfo.ProjDescrip = MstrInf.Descr; _projInfoService.Update(ProjInfo); _projInfoService.Save(); var ProjID = ProjInfo.ProjID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateProjectInfo", ProjID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("3"); } } else { return("2"); } }
public ActionResult DeleteVM_BIN(int Id) { //RBACUser rUser = new RBACUser(Session["UserName"].ToString()); //if (!rUser.HasPermission("GL_VM_BIN_Delete")) //{ // return Json("D", JsonRequestBehavior.AllowGet); //} using (var transaction = new TransactionScope()) { try { var IsExist = _pR_VM_BINService.All().ToList().FirstOrDefault(x => x.Id == Id); if (IsExist != null) { _pR_VM_BINService.Delete(IsExist); _pR_VM_BINService.Save(); var HDHolidayID = 1; TransactionLogService.SaveTransactionLog(_transactionLogService, "SaveVM_BIN", "Delete", HDHolidayID.ToString(), Session["UserName"].ToString()); } else { return(Json("2", JsonRequestBehavior.AllowGet)); } transaction.Complete(); return(Json("1", JsonRequestBehavior.AllowGet)); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }
private string SaveLocInfo(VMMasterForm MstrInf) { var LocCode = _LocationService.All().ToList().FirstOrDefault(x => x.LocCode == MstrInf.Code); if (LocCode == null) { Location _Loc = new Location(); _Loc.LocCode = MstrInf.Code; _Loc.LocName = MstrInf.Name; _LocationService.Add(_Loc); _LocationService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "SaveDesignationInfo", _Loc.LocCode, Session["UserName"].ToString()); return("1"); } else { return("2"); } }
private string UpdateUnitInfo(VMMasterForm MstrInf) { var UnitInfo = _unitInfoService.All().ToList().FirstOrDefault(x => x.UnitID == MstrInf.ID); if (UnitInfo != null) { var UInfList = _unitInfoService.All().ToList().Where(c => c.UnitID != MstrInf.ID).ToList(); var IsCodExst = UInfList.FirstOrDefault(x => x.UnitCode == MstrInf.Code); if (IsCodExst == null) { UnitInfo.UnitCode = MstrInf.Code; UnitInfo.UnitName = MstrInf.Name; UnitInfo.UnitLocalName = MstrInf.LocalName; UnitInfo.UnitDesc = MstrInf.Descr; _unitInfoService.Update(UnitInfo); _unitInfoService.Save(); var UnitID = UnitInfo.UnitID; TransactionLogService.SaveTransactionLog(_transactionLogService, "MasterInformation", "UpdateUnitInfo", UnitID.ToString(), Session["UserName"].ToString()); return("1"); } else { return("3"); } } else { return("2"); } }
public ActionResult SaveDepositToBank(Deposit deposit) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankDeposit_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>(); try { var IfExit = _DepositToBankService.All().Where(x => x.DepositNo == deposit.DepositNo).FirstOrDefault(); if (IfExit == null) { if (!string.IsNullOrEmpty(deposit.bankAccode) && deposit.bankAccode.Trim() != "Select Bank A/C") { deposit.BranchCode = Session["BranchCode"].ToString(); var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault(); if (GCa == null) { var gset = _gsetService.All().LastOrDefault(); GCa = gset.GCa; } deposit.FinYear = Session["FinYear"].ToString(); deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim()); //cashReceipt.Customer = _CustomerService.All().ToList().FirstOrDefault(x => x.CustCode == cashReceipt.CustCode); CashOperation cashOperation = new CashOperation(deposit.DepositDate, 0.0, 0.0, 0.0, 0.0, "", DateTime.Now, false, deposit.FinYear, false, deposit.BranchCode); var isAlreadyClosed = _CashOperationService.All().ToList().FirstOrDefault(x => x.BranchCode == deposit.BranchCode && x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy")); var openBal = GetOpenBal(deposit.DepositDate, deposit.bankAccode); var rcecBal = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount); var payTotal = GetAllPayment(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount); var closBal = openBal + rcecBal - payTotal; BankOperation bankOperation = new BankOperation(deposit.DepositDate, openBal, deposit.Amount, 0.0, closBal, deposit.BranchCode, deposit.FinYear, false, deposit.bankAccode); var sysSet = _sysSetService.All().FirstOrDefault(); var isAlreadySaved = _BankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == deposit.DepositDate.ToString("MM-dd-yyyy") && x.BranchCode == deposit.BranchCode && x.bankAccode == deposit.bankAccode); if (isAlreadyClosed == null || isAlreadySaved == null) { using (var transaction = new TransactionScope()) { try { _CashOperationService.Add(cashOperation); _CashOperationService.Save(); _BankOperationService.Add(bankOperation); _BankOperationService.Save(); _DepositToBankService.Add(deposit); _DepositToBankService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString()); LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString()); CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else if (isAlreadyClosed != null && sysSet.CashRule == "O" ? true : isAlreadyClosed.IsClosed == false) { var rcecBals = GetAllRemittances(deposit.DepositDate, deposit.BranchCode, deposit.bankAccode).Sum(x => x.Amount); isAlreadySaved.RecTotal = rcecBals + deposit.Amount; isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal; using (var transaction = new TransactionScope()) { try { _BankOperationService.Update(isAlreadySaved); _BankReceiptAppService.Save(); _DepositToBankService.Add(deposit); _DepositToBankService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Save", deposit.DepositNo, Session["UserName"].ToString()); LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString()); if (sysSet.CashRule == "O") { LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate); } CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else { return(Json("2", JsonRequestBehavior.AllowGet)); } } else { return(Json("1", JsonRequestBehavior.AllowGet)); } } else { return(Json("3", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateDepositToBank(Deposit deposit, DateTime dateTime) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankDeposit_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } List <CashOperationVModel> CashOPVM = new List <CashOperationVModel>(); if (ModelState.IsValid) { deposit.BranchCode = Session["BranchCode"].ToString(); var GCa = _AcBrService.All().Where(s => s.BranchCode == deposit.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault(); if (GCa == null) { var gset = _gsetService.All().LastOrDefault(); GCa = gset.GCa; } deposit.FinYear = Session["FinYear"].ToString(); deposit.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == deposit.bankAccode.Trim()); CashOperation cashOperation = new CashOperation(); var isClosed = _CashOperationService.All().LastOrDefault(x => x.BranchCode == deposit.BranchCode && Convert.ToDateTime(x.TrDate.ToShortDateString()) <= Convert.ToDateTime(dateTime.ToShortDateString())); if (isClosed.IsClosed == false) { using (var transaction = new TransactionScope()) { try { _DepositToBankService.Update(deposit); _DepositToBankService.Save(); //delete to provision var entryNo = deposit.DepositNo; //var entryNo = Convert.ToInt64(deposit.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0'); LoadDropDown.journalVoucherRemoval("BD", entryNo, deposit.VoucherNo, deposit.FinYear); //insert to provision LoadDropDown.journalVoucherSave("BD", "I", deposit.DepositNo, deposit.VoucherNo, deposit.FinYear, "01", deposit.BranchCode, deposit.DepositDate, GCa, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "Deposit To Bank", "Update", deposit.DepositNo, Session["UserName"].ToString()); var sysSet = _sysSetService.All().FirstOrDefault(); if (sysSet.CashRule == "O") { LoadDropDown.CashRecalculate(Session["ProjCode"].ToString(), deposit.BranchCode, deposit.FinYear, Convert.ToDecimal(deposit.Amount), deposit.DepositDate); } CashOPVM = GetAllExpenseAndDeposit(deposit.DepositDate, deposit.BranchCode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else { return(Json("2", JsonRequestBehavior.AllowGet)); } } return(Json("0", JsonRequestBehavior.AllowGet)); }
public ActionResult SavePayment(Payment payment) { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankPayment_Insert")) { return(Json("X", JsonRequestBehavior.AllowGet)); } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); var gset = _gsetService.All().LastOrDefault(); try { var IfExit = _paymentService.All().Where(x => x.PayCode == payment.PayCode).FirstOrDefault(); if (IfExit == null) { payment.BranchCode = Session["BranchCode"].ToString(); payment.FinYear = Session["FinYear"].ToString(); payment.bankAccode = Session["BankAccode"].ToString(); var openBal = GetOpenBal(payment.PayDate); var rcecBal = GetAllRemittances(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount); var payTotal = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount); var closBal = openBal + rcecBal - payTotal; BankOperation bankOperation = new BankOperation(payment.PayDate, openBal, 0.0, payment.Amount, closBal, payment.BranchCode, payment.FinYear, false, payment.bankAccode); // BankOperation bankOperation = new BankOperation(payment.PayDate, 0.0, 0.0, 0.0, 0.0, payment.BranchCode, payment.FinYear, false, payment.bankAccode); var isAlreadySaved = _bankOperationService.All().ToList().FirstOrDefault(x => x.TrDate.ToString("MM-dd-yyyy") == payment.PayDate.ToString("MM-dd-yyyy") && x.BranchCode == payment.BranchCode && x.bankAccode == payment.bankAccode); if (isAlreadySaved == null) { using (var transaction = new TransactionScope()) { try { _bankOperationService.Add(bankOperation); _bankOperationService.Save(); _paymentService.Add(payment); _paymentService.Save(); //Insert to provision LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Save", payment.PayCode, User.Identity.Name); CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } else { var payTotals = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode).Sum(x => x.Amount); isAlreadySaved.PayTotal = payTotals + payment.Amount; isAlreadySaved.CloseBal = isAlreadySaved.OpenBal + isAlreadySaved.RecTotal - isAlreadySaved.PayTotal; using (var transaction = new TransactionScope()) { try { _bankOperationService.Update(isAlreadySaved); _bankOperationService.Save(); _paymentService.Add(payment); _paymentService.Save(); //Insert to provision LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString()); var sysSet = _sysSetService.All().FirstOrDefault(); if (sysSet.CashRule == "O") { LoadDropDown.BankRecalculate(payment.PayDate, Convert.ToDecimal(payment.Amount), Session["ProjCode"].ToString(), payment.BranchCode, payment.FinYear, payment.bankAccode); } TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Save", payment.PayCode, User.Identity.Name); CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode); transaction.Complete(); } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } return(Json(CashOPVM, JsonRequestBehavior.AllowGet)); } } else { return(Json("1", JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json("0", JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdatePayment(Payment payment) { using (var transaction = new TransactionScope()) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("BankPayment_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>(); var gset = _gsetService.All().LastOrDefault(); payment.BranchCode = Session["BranchCode"].ToString(); payment.FinYear = Session["FinYear"].ToString(); payment.bankAccode = Session["BankAccode"].ToString(); string branchCode = Session["BranchCode"].ToString(); string finYear = Session["FinYear"].ToString(); string bankAccode = Session["BankAccode"].ToString(); var bankOperation = _bankOperationService.All().ToList().LastOrDefault(x => x.BranchCode == branchCode && x.bankAccode == bankAccode && x.TrDate == payment.PayDate); var Payment = _paymentService.All().ToList().Where(x => x.PayCode == payment.PayCode.Trim()).FirstOrDefault(); if (bankOperation != null && Payment != null) { bankOperation.PayTotal = bankOperation.PayTotal + Payment.Amount - payment.Amount; bankOperation.CloseBal = bankOperation.OpenBal + bankOperation.RecTotal - bankOperation.PayTotal; _bankOperationService.Update(bankOperation); _bankOperationService.Save(); Payment = payment; _paymentService.All().ToList().Where(y => y.PayCode == payment.PayCode).ToList().ForEach(x => _paymentService.Delete(x)); _paymentService.Save(); _paymentService.Add(Payment); _paymentService.Save(); // Delete Provision var entryNo = payment.PayCode; LoadDropDown.journalVoucherRemoval("BP", entryNo, payment.VoucherNo, payment.FinYear); //Insert to provision LoadDropDown.journalVoucherSave("BP", "I", payment.PayCode, payment.VoucherNo, payment.FinYear, "01", payment.BranchCode, payment.PayDate, payment.bankAccode, Session["UserName"].ToString()); TransactionLogService.SaveTransactionLog(_transactionLogService, "Payment", "Update", payment.PayCode, User.Identity.Name); var sysSet = _sysSetService.All().FirstOrDefault(); if (sysSet.CashRule == "O") { LoadDropDown.BankRecalculate(payment.PayDate, Convert.ToDecimal(payment.Amount), Session["ProjCode"].ToString(), payment.BranchCode, payment.FinYear, payment.bankAccode); } CashOPVM = GetAllPayment(payment.PayDate, payment.BranchCode, payment.bankAccode); transaction.Complete(); return(Json(new { CashOPVM, data = 1 }, JsonRequestBehavior.AllowGet)); } else { return(Json("0", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { transaction.Dispose(); return(Json(ex.Message.ToString(), JsonRequestBehavior.AllowGet)); } } }
public ActionResult UpdateCashMR(MoneyReceiptVM MrVM) { using (var transaction = new TransactionScope()) { try { RBACUser rUser = new RBACUser(Session["UserName"].ToString()); if (!rUser.HasPermission("MoneyReceiptCash_Update")) { return(Json("U", JsonRequestBehavior.AllowGet)); } var VchrExist = _pVchrmainService.All().FirstOrDefault(s => s.VchrNo == MrVM.VchrNo); if (VchrExist == null) { return(Json("3", JsonRequestBehavior.AllowGet)); } var MR = _moneyReceiptService.All().Where(x => x.MRSL == MrVM.MRSL && x.MRNo == MrVM.MRNo && MrVM.Posted == false).FirstOrDefault(); var CR = _CashReceiptService.All().Where(s => s.RefNo == MrVM.MRSL).FirstOrDefault(); var CRSD = _CashReceiptSubDetailsAppService.All().Where(s => s.CashReceiptNo == CR.ReceiptNo).FirstOrDefault(); if (MR != null && CR != null && CRSD != null) { //var cabkop = _defACService.All().ToList().FirstOrDefault().CashAc; var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault(); if (GCa == null) { var gset = _gsetService.All().LastOrDefault(); GCa = gset.GCa; } //For MR MR.MRSL = MrVM.MRSL; MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode; MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode; MR.MRNo = MrVM.MRNo; MR.MRDate = MrVM.MRDate; MR.MRAgainst = MrVM.MRAgainst; MR.VchrNo = MrVM.VchrNo; MR.Posted = MrVM.Posted; MR.AdjWithBill = MrVM.AdjWithBill; MR.MRAmount = MrVM.Amount; MR.Accode = MrVM.Accode; MR.CustCode = MrVM.CustCode; MR.FinYear = Session["FinYear"].ToString(); MR.JobNo = MrVM.JobNo; MR.Remarks = MrVM.Remarks; MR.Ca_Bk = GCa; CR.ReceiptDate = (DateTime)MrVM.MRDate; CR.purAccode = MrVM.MRAgainst;// "1.2.004"; CR.RefNo = MrVM.MRSL; CR.Amount = (Double)MrVM.Amount; CR.Remarks = MrVM.Remarks; CR.VoucherNo = MrVM.VchrNo; CRSD.SubCode = MrVM.CustCode; CRSD.Accode = MrVM.MRAgainst; CRSD.Amount = (Double)MrVM.Amount; _moneyReceiptService.Update(MR); _CashReceiptService.Update(CR); _CashReceiptSubDetailsAppService.Update(CRSD); _CashReceiptService.Save(); _CashReceiptSubDetailsAppService.Save(); _moneyReceiptService.Save(); TransactionLogService.SaveTransactionLog(_transactionLogService, "Cash MR", "Update", MR.MRSL, Session["UserName"].ToString()); LoadDropDown.journalVoucherRemoval("CR", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString()); LoadDropDown.journalVoucherSave("CR", "I", MrVM.MRNo, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), GCa, Session["UserName"].ToString()); transaction.Complete(); return(Json("1", JsonRequestBehavior.AllowGet)); } else { transaction.Dispose(); return(Json("3", JsonRequestBehavior.AllowGet)); } } catch (Exception) { transaction.Dispose(); return(Json("0", JsonRequestBehavior.AllowGet)); } } }