public ActionResult SaveEmpBnk(EmpBankVM EmpBnk)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
EmpBnk.CmpyCode = list[0].CmpyCode;
EmpBnk.UserName = list[0].user_name;
return(Json(_bkService.SaveEmpBnk(EmpBnk), JsonRequestBehavior.AllowGet));
}
}
public EmpBankVM GetEmpBnkEdit(string CmpyCode, string PRBM003_CODE)
{
ds = _EzBusinessHelper.ExecuteDataSet("Select * from PRBM003 where CmpyCode='" + CmpyCode + "' and PRBM003_CODE='" + PRBM003_CODE + "'and Flag=0 ");
dt = ds.Tables[0];
EmpBankVM EmpBank = new EmpBankVM();
foreach (DataRow dr in dt.Rows)
{
EmpBank.CmpyCode = dr["Cmpycode"].ToString();
EmpBank.EmpCode = dr["EmpCode"].ToString();
EmpBank.Account_no = dr["Account_no"].ToString();
EmpBank.PRBM001_code = dr["PRBM001_code"].ToString();
EmpBank.PRBM002_code = dr["PRBM002_code"].ToString();
EmpBank.Entry_Date = Convert.ToDateTime(dr["Entry_Date"].ToString());
EmpBank.EBAN_no = dr["EBAN_no"].ToString();
EmpBank.Remarks = dr["Remarks"].ToString();
EmpBank.PRBM003_CODE = dr["PRBM003_CODE"].ToString();
}
return(EmpBank);
}
public EmpBankVM SaveEmpBnk(EmpBankVM EmpBnk)
{
return(_bkRepo.SaveEmpBnk(EmpBnk));
}
public EmpBankVM SaveEmpBnk(EmpBankVM EmpBnk)
{
DateTime dt1;
string dtstr = "";
dt1 = Convert.ToDateTime(EmpBnk.Entry_Date);
dtstr = dt1.ToString("yyyy-MM-dd");
try
{
if (!EmpBnk.EditFlag)
{
int Empbn1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from PRBM003 where CmpyCode='" + EmpBnk.CmpyCode + "' and PRBM003_CODE='" + EmpBnk.PRBM003_CODE + "'");
if (Empbn1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + EmpBnk.CmpyCode + "',");
sb.Append("'" + EmpBnk.PRBM003_CODE + "',");
sb.Append("'" + EmpBnk.EmpCode + "',");
sb.Append("'" + EmpBnk.PRBM001_code + "',");
sb.Append("'" + EmpBnk.PRBM002_code + "',");
sb.Append("'" + dtstr + "',");
sb.Append("'" + EmpBnk.Account_no + "',");
sb.Append("'" + EmpBnk.EBAN_no + "',");
sb.Append("'" + EmpBnk.Remarks + "')");
_EzBusinessHelper.ExecuteNonQuery("insert into PRBM003(CmpyCode,PRBM003_CODE,EmpCode,PRBM001_code,PRBM002_code,Entry_Date,Account_no,EBAN_no,Remarks) values(" + sb.ToString() + "");
_EzBusinessHelper.ActivityLog(EmpBnk.CmpyCode, EmpBnk.UserName, "Add Emp Bank Master", EmpBnk.PRBM003_CODE, Environment.MachineName);
EmpBnk.SaveFlag = true;
EmpBnk.ErrorMessage = string.Empty;
}
else
{
EmpBnk.SaveFlag = false;
EmpBnk.ErrorMessage = "Duplicate Record";
}
// n = n - 1;
//}
return(EmpBnk);
}
var EmpbnEdit = _EzBusinessHelper.ExecuteScalar("Select count(*) from PRBM003 where CmpyCode='" + EmpBnk.CmpyCode + "' and PRBM003_CODE='" + EmpBnk.PRBM003_CODE + "'");
if (EmpbnEdit != 0)
{
_EzBusinessHelper.ExecuteNonQuery("update PRBM003 set EmpCode='" + EmpBnk.EmpCode + "',PRBM001_code='" + EmpBnk.PRBM001_code + "',PRBM002_code='" + EmpBnk.PRBM002_code + "',Entry_Date='" + dtstr + "',Account_no='" + EmpBnk.Account_no + "',EBAN_no='" + EmpBnk.EBAN_no + "',Remarks='" + EmpBnk.Remarks + "' where CmpyCode='" + EmpBnk.CmpyCode + "' and PRBM003_CODE='" + EmpBnk.PRBM003_CODE + "'");
_EzBusinessHelper.ActivityLog(EmpBnk.CmpyCode, EmpBnk.UserName, "Update Emp Bank Master", EmpBnk.PRBM003_CODE, Environment.MachineName);
EmpBnk.SaveFlag = true;
EmpBnk.ErrorMessage = string.Empty;
}
else
{
EmpBnk.SaveFlag = false;
EmpBnk.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
EmpBnk.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(EmpBnk);
}
