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