public int Update(EntityBankMaster bank)
{
int i = 0;
try
{
tblBankMaster objBank = (from tbl in objData.tblBankMasters
where tbl.BankId == bank.BankId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objBank != null)
{
objBank.BankAddress = bank.BankAddress;
objBank.BankName = bank.BankName;
objBank.IFSCCode = bank.IFSCCode;
objBank.MISCCode = bank.MISCCode;
objBank.BranchName = bank.BranchName;
objBank.City = bank.City;
objBank.CustomerId = bank.CustomerId;
objBank.MobileNo = bank.MobileNo;
objBank.PhNo = bank.PhNo;
objBank.Pin = bank.Pin;
}
objData.SubmitChanges();
i++;
}
catch (Exception ex)
{
i = 0;
throw ex;
}
return(i);
}
public int InsertBankMaster(EntityBankMaster bank)
{
int i = 0;
try
{
tblBankMaster objbank = new tblBankMaster()
{
AccountNo = bank.AccountNo,
BankAddress = bank.BankAddress,
BankName = bank.BankName,
IFSCCode = bank.IFSCCode,
MISCCode = bank.MISCCode,
BranchName = bank.BranchName,
City = bank.City,
CustomerId = bank.CustomerId,
MobileNo = bank.MobileNo,
PhNo = bank.PhNo,
Pin = bank.Pin,
IsDelete = false
};
objData.tblBankMasters.InsertOnSubmit(objbank);
objData.SubmitChanges();
i++;
}
catch (Exception ex)
{
i = 0;
throw ex;
}
return(i);
}
public EntityBankMaster GetBank(int BankId)
{
EntityBankMaster bank = null;
try
{
bank = (from tbl in objData.tblBankMasters
where tbl.BankId == BankId &&
tbl.IsDelete == false
select new EntityBankMaster
{
AccountNo = tbl.AccountNo,
BankAddress = tbl.BankAddress,
BankName = tbl.BankName,
IFSCCode = tbl.IFSCCode,
MISCCode = tbl.MISCCode,
BranchName = tbl.BranchName,
City = tbl.City,
CustomerId = tbl.CustomerId,
MobileNo = tbl.MobileNo,
PhNo = tbl.PhNo,
Pin = tbl.Pin,
BankId = tbl.BankId
}).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(bank);
}
public EntityBankMaster GetBankByAccNo(EntityBankMaster entSupplier)
{
EntityBankMaster bank = null;
try
{
bank = (from tbl in objData.tblBankMasters
where tbl.IsDelete == false &&
tbl.AccountNo == entSupplier.AccountNo
select new EntityBankMaster {
}).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(bank);
}
