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);
}
