public void Delete(St_BranchAccountH ObjDelete) { var ObjToDelete = _context.St_BranchAccountHs.SingleOrDefault(m => m.CompanyID == ObjDelete.CompanyID && m.BranchCode == ObjDelete.BranchCode); if (ObjToDelete != null) { _context.St_BranchAccountHs.Remove(ObjToDelete); } }
public JsonResult Delete(St_BranchHVM ObjDelete) { MsgUnit Msg = new MsgUnit(); try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); ObjDelete.CompanyID = UserInfo.fCompanyId; var ObjDeleteSt_Branch = new St_BranchH(); ObjDeleteSt_Branch.CompanyID = UserInfo.fCompanyId; ObjDeleteSt_Branch.BranchCode = ObjDelete.BranchCode; var ObjDeleteSt_BranchAccount = new St_BranchAccountH(); ObjDeleteSt_BranchAccount.CompanyID = UserInfo.fCompanyId; ObjDeleteSt_BranchAccount.BranchCode = ObjDelete.BranchCode; if (!ModelState.IsValid) { string Err = " "; var errors = ModelState.Values.SelectMany(v => v.Errors); foreach (ModelError error in errors) { Err = Err + error.ErrorMessage + " * "; } Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err; Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } _unitOfWork.NativeSql.DeleteSt_BranchExpenseAccountH(ObjDeleteSt_Branch.CompanyID, ObjDeleteSt_Branch.BranchCode); _unitOfWork.NativeSql.DeleteSt_BranchOtherExpenseAccountH(ObjDeleteSt_Branch.CompanyID, ObjDeleteSt_Branch.BranchCode); _unitOfWork.St_BranchAccountH.Delete(ObjDeleteSt_BranchAccount); _unitOfWork.St_BranchH.Delete(ObjDeleteSt_Branch); _unitOfWork.Complete(); Msg.Code = 1; Msg.Msg = Resources.Resource.DeletedSuccessfully; return(Json(Msg, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString(); Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } }
public void Add(St_BranchAccountH ObjSave) { _context.St_BranchAccountHs.Add(ObjSave); }
public JsonResult SaveSt_BranchAccountH(St_BranchAccountHVM ObjToSave) { MsgUnit Msg = new MsgUnit(); try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); ObjToSave.InsDateTime = DateTime.Now; ObjToSave.InsUserID = userId; ObjToSave.CompanyID = UserInfo.fCompanyId; if (!ModelState.IsValid) { string Err = " "; var errors = ModelState.Values.SelectMany(v => v.Errors); foreach (ModelError error in errors) { Err = Err + error.ErrorMessage + " * "; } Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err; Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } var St_BranchAccountHObj = new St_BranchAccountH(); St_BranchAccountHObj.CompanyID = UserInfo.fCompanyId; St_BranchAccountHObj.BranchCode = ObjToSave.BranchCode; St_BranchAccountHObj.FundAccountNumber = ObjToSave.FundAccountNumber; St_BranchAccountHObj.SalesAccountNumber = ObjToSave.SalesAccountNumber; St_BranchAccountHObj.MaintenanceCardAccountNumber = ObjToSave.MaintenanceCardAccountNumber; St_BranchAccountHObj.ReturnCardAccountNumber = ObjToSave.ReturnCardAccountNumber; St_BranchAccountHObj.TransferFeesAndInstallationAccountNumber = ObjToSave.TransferFeesAndInstallationAccountNumber; St_BranchAccountHObj.ChequeFundAccountNumber = ObjToSave.ChequeFundAccountNumber; St_BranchAccountHObj.RelocationAccountNumber = ObjToSave.RelocationAccountNumber; St_BranchAccountHObj.VisaAccountNumber = ObjToSave.VisaAccountNumber; St_BranchAccountHObj.MasterAccountNumber = ObjToSave.MasterAccountNumber; St_BranchAccountHObj.AmericanAccountNumber = ObjToSave.AmericanAccountNumber; St_BranchAccountHObj.ArabiCashAccountNumber = ObjToSave.ArabiCashAccountNumber; St_BranchAccountHObj.ReceiptVoucherNo = ObjToSave.ReceiptVoucherNo; St_BranchAccountHObj.PaymentVoucherNo = ObjToSave.PaymentVoucherNo; St_BranchAccountHObj.ReceiptChequeVoucherNo = ObjToSave.ReceiptChequeVoucherNo; St_BranchAccountHObj.TransferFeesAndInstallationVoucherNo = ObjToSave.TransferFeesAndInstallationVoucherNo; St_BranchAccountHObj.InstallmentSchedulingVoucherNo = ObjToSave.InstallmentSchedulingVoucherNo; St_BranchAccountHObj.MaintenanceCardVoucherNo = ObjToSave.MaintenanceCardVoucherNo; St_BranchAccountHObj.TransferVoucherNo = ObjToSave.TransferVoucherNo; St_BranchAccountHObj.ReturningSoldItemVoucherNo = ObjToSave.ReturningSoldItemVoucherNo; St_BranchAccountHObj.ClosingAFundVoucherNo = ObjToSave.ClosingAFundVoucherNo; St_BranchAccountHObj.ChequeFundClosingVoucherNo = ObjToSave.ChequeFundClosingVoucherNo; St_BranchAccountHObj.ClosingAFinancingFundVoucherNo = ObjToSave.ClosingAFinancingFundVoucherNo; St_BranchAccountHObj.FinancingVoucherNo = ObjToSave.FinancingVoucherNo; St_BranchAccountHObj.InstallationVoucherNo = ObjToSave.InstallationVoucherNo; St_BranchAccountHObj.InsDateTime = DateTime.Now; St_BranchAccountHObj.InsUserID = userId; _unitOfWork.NativeSql.DeleteSt_BranchExpenseAccountH(UserInfo.fCompanyId, ObjToSave.BranchCode); _unitOfWork.NativeSql.DeleteSt_BranchOtherExpenseAccountH(UserInfo.fCompanyId, ObjToSave.BranchCode); _unitOfWork.St_BranchAccountH.Delete(St_BranchAccountHObj); _unitOfWork.Complete(); if (ObjToSave.St_BranchExpenseAccountH != null) { foreach (var SaveSt_BranchExpenseAccountH in ObjToSave.St_BranchExpenseAccountH) { SaveSt_BranchExpenseAccountH.CompanyID = UserInfo.fCompanyId; SaveSt_BranchExpenseAccountH.BranchCode = ObjToSave.BranchCode; SaveSt_BranchExpenseAccountH.ExpenseAccountNumber = SaveSt_BranchExpenseAccountH.ExpenseAccountNumber; SaveSt_BranchExpenseAccountH.RowNumber = SaveSt_BranchExpenseAccountH.RowNumber; _unitOfWork.St_BranchAccountH.AddBranchExpenseAccountH(SaveSt_BranchExpenseAccountH); } } if (ObjToSave.St_BranchOtherExpenseAccountH != null) { foreach (var SaveSt_BranchOtherExpenseAccountH in ObjToSave.St_BranchOtherExpenseAccountH) { SaveSt_BranchOtherExpenseAccountH.CompanyID = UserInfo.fCompanyId; SaveSt_BranchOtherExpenseAccountH.BranchCode = ObjToSave.BranchCode; SaveSt_BranchOtherExpenseAccountH.OtherExpenseAccountNumber = SaveSt_BranchOtherExpenseAccountH.OtherExpenseAccountNumber; SaveSt_BranchOtherExpenseAccountH.RowNumber = SaveSt_BranchOtherExpenseAccountH.RowNumber; _unitOfWork.St_BranchAccountH.AddBranchOtherExpenseAccountH(SaveSt_BranchOtherExpenseAccountH); } } _unitOfWork.St_BranchAccountH.Add(St_BranchAccountHObj); _unitOfWork.Complete(); Msg.Code = 1; Msg.Msg = Resources.Resource.AddedSuccessfully; return(Json(Msg, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString(); Msg.Code = 0; return(Json(Msg, JsonRequestBehavior.AllowGet)); } }