internal void DeleteEmployeeBankInfo(string employee)
{
using (var context = new ERPSSLHBEntities())
{
HRM_BankInfo ObjDel = (from b in context.HRM_BankInfo
where b.EID == employee
select b).FirstOrDefault();
context.HRM_BankInfo.DeleteObject(ObjDel);
context.SaveChanges();
}
}
protected void btnBanck_Update(object sender, EventArgs e)
{
try
{
string eid = "";
string employeeid = Convert.ToString(Session["EID"]);
string Ocode = ((SessionUser)Session["SessionUser"]).OCode;
List <HRM_BankInfo> bankInfo = bankDALObj.GetBankInfo(employeeid, Ocode);
foreach (HRM_BankInfo abank in bankInfo)
{
eid = abank.EID;
}
HRM_BankInfo bankInfoObj = new HRM_BankInfo();
bankInfoObj.EID = employeeid;
bankInfoObj.BankName = txtbxBankName.Text;
bankInfoObj.AccountNo = txtbxAc.Text;
bankInfoObj.Branch = txtbxBranch.Text;
bankInfoObj.Address = txtbxAddress.Text;
bankInfoObj.MobileNo = txtbxMobileNO.Text;
bankInfoObj.MobileBankName = txbxMobileBankName.Text;
bankInfoObj.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
bankInfoObj.EDIT_DATE = DateTime.Now;
bankInfoObj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
if (eid != "")
{
int result = bankDALObj.UpdateBankInfo(employeeid, bankInfoObj);
if (result == 1)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "text", "func('Data Update successfully!')", true);
GetBankInfo(employeeid);
}
}
else
{
int result = bankDALObj.BankInfoSave(bankInfoObj);
if (result == 1)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "text", "func('Data Save successfully!')", true);
GetBankInfo(employeeid);
}
}
}
catch (Exception)
{
throw;
}
}
internal int UpdateBankInfo(string employeeid, HRM_BankInfo bankInfoObj)
{
HRM_BankInfo obj = _context.HRM_BankInfo.First(x => x.EID == employeeid);
obj.BankName = bankInfoObj.BankName;
obj.AccountNo = bankInfoObj.AccountNo;
obj.MobileNo = bankInfoObj.MobileNo;
obj.MobileBankName = bankInfoObj.MobileBankName;
obj.Branch = bankInfoObj.Branch;
obj.Address = bankInfoObj.Address;
obj.EDIT_USER = bankInfoObj.EDIT_USER;
obj.EDIT_DATE = bankInfoObj.EDIT_DATE;
_context.SaveChanges();
return(1);
}
internal int BankInfoSave(HRM_BankInfo bankObj)
{
return(bankDal.BankInfoSave(bankObj));
}
internal int BankInfoSave(HRM_BankInfo bankObj)
{
_context.HRM_BankInfo.AddObject(bankObj);
_context.SaveChanges();
return(1);
}
