public BankMasterVM SaveBnk(BankMasterVM Bnk) { if (!Bnk.EditFlag) { Bnk.prbm001_code = _codeRep.GetCode(Bnk.CmpyCode, "BankMaster"); } return(_BnkPayrollRepo.SaveBnk(Bnk)); }
public ActionResult SaveBnk(BankMasterVM Bnk) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Bnk.UserName = list[0].user_name; Bnk.CmpyCode = list[0].CmpyCode; return(Json(_BnkService.SaveBnk(Bnk), JsonRequestBehavior.AllowGet)); } }
public BankMasterVM GetBnkEdit(string CmpyCode, string PRBM001_code) { ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRBM001 where CmpyCode='" + CmpyCode + "' and PRBM001_code='" + PRBM001_code + "' "); dt = ds.Tables[0]; BankMasterVM pr = new BankMasterVM(); foreach (DataRow dr in dt.Rows) { pr.CmpyCode = dr["CmpyCode"].ToString(); pr.prbm001_code = dr["prbm001_code"].ToString(); pr.country = dr["country"].ToString(); pr.Bank_name = dr["Bank_name"].ToString(); pr.Reference = dr["Reference"].ToString(); } return(pr); }
public BankMasterVM SaveBnk(BankMasterVM Bnk) { int n; if (!Bnk.EditFlag) { BankMaster pt = new BankMaster(); int pno = _EzBusinessHelper.ExecuteScalar("Select Nos from PARTTBL001 where CmpyCode='" + Bnk.CmpyCode + "' and Code='PRBM' "); //pt.PRBM001_code = string.Concat("PRBM", "-", (pno + 1).ToString().PadLeft(4, '0')).ToString(); List <BankBr> ObjList = new List <BankBr>(); ObjList.AddRange(Bnk.Branch.Select(m => new BankBr { PRBM002_code = m.PRBM002_code, Bank_branch_name = m.Bank_branch_name }).ToList()); Bnk.SaveFlag = _EzBusinessHelper.ExecuteNonQuery1("insert into PRBM001(PRBM001_code,CmpyCode,country,Bank_name,Reference) values('" + Bnk.prbm001_code + "','" + Bnk.CmpyCode + "','" + Bnk.country + "','" + Bnk.Bank_name + "','" + Bnk.Reference + "')"); n = ObjList.Count; while (n > 0 && Bnk.SaveFlag == true) { _EzBusinessHelper.ExecuteNonQuery("insert into PRBM002(PRBM001_code,PRBM002_code,Bank_branch_name,CmpyCode) values('" + Bnk.prbm001_code + "','" + ObjList[n - 1].PRBM002_code + "','" + ObjList[n - 1].Bank_branch_name + "','" + Bnk.CmpyCode + "')"); n = n - 1; } _EzBusinessHelper.ActivityLog(Bnk.CmpyCode, Bnk.UserName, "Add Bank Master", Bnk.prbm001_code, Environment.MachineName); _EzBusinessHelper.ExecuteNonQuery("UPDATE PARTTBL001 SET Nos = " + (pno + 1) + " where CmpyCode='" + Bnk.CmpyCode + "' and Code='PRBM'"); Bnk.SaveFlag = true; Bnk.ErrorMessage = string.Empty; } else { int k = 0; k = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRBM003 where CmpyCode='" + Bnk.CmpyCode + "' and prbm001_code='" + Bnk.prbm001_code + "'"); n = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRBM001 where CmpyCode='" + Bnk.CmpyCode + "' and prbm001_code='" + Bnk.prbm001_code + "' "); if (n != 0 && k == 0) { _EzBusinessHelper.ExecuteNonQuery("delete from PRBM001 where CmpyCode='" + Bnk.CmpyCode + "' and PRBM001_code='" + Bnk.prbm001_code + "'"); _EzBusinessHelper.ExecuteNonQuery("delete from PRBM002 where CmpyCode='" + Bnk.CmpyCode + "' and PRBM001_code='" + Bnk.prbm001_code + "'"); BankMaster pt = new BankMaster(); List <BankBr> ObjList = new List <BankBr>(); ObjList.AddRange(Bnk.Branch.Select(m => new BankBr { PRBM001_code = m.PRBM001_code, PRBM002_code = m.PRBM002_code, Bank_branch_name = m.Bank_branch_name }).ToList()); _EzBusinessHelper.ExecuteNonQuery("insert into PRBM001(PRBM001_code,CmpyCode,country,Bank_name,Reference) values('" + Bnk.prbm001_code + "','" + Bnk.CmpyCode + "','" + Bnk.country + "','" + Bnk.Bank_name + "','" + Bnk.Reference + "')"); n = ObjList.Count; while (n > 0) { _EzBusinessHelper.ExecuteNonQuery("insert into PRBM002(PRBM001_code,PRBM002_code,Bank_branch_name,CmpyCode) values('" + Bnk.prbm001_code + "','" + ObjList[n - 1].PRBM002_code + "','" + ObjList[n - 1].Bank_branch_name + "','" + Bnk.CmpyCode + "')"); n = n - 1; } _EzBusinessHelper.ActivityLog(Bnk.CmpyCode, Bnk.UserName, "Update Bank Master", Bnk.prbm001_code, Environment.MachineName); Bnk.SaveFlag = true; Bnk.ErrorMessage = string.Empty; } else { Bnk.SaveFlag = true; Bnk.ErrorMessage = "Error occur"; } } return(Bnk); }