public ActionResult AddBank(string id)
{
_log.Info("AddBank() HTTP GET METHOD BEGIN");
BankMasterModel bankMasterModel = new BankMasterModel();
try
{
int bankId = string.IsNullOrEmpty(id.DecryptString()) ? default(int) : Convert.ToInt32(id.DecryptString());
SelectList bankNames = GetDropDownListByMasterCode(Enums.RefMasterCodes.BANK_NAME);
SelectList accountTypes = GetDropDownListByMasterCode(Enums.RefMasterCodes.BANK_ACCOUNT_TYPE);
ViewBag.BankNames = bankNames;
ViewBag.AccountTypes = accountTypes;
BankMasterDto bankMasterDto = new BankMasterDto();
if (bankId > 0)
{
bankMasterDto = _bankService.GetByID(bankId);
bankMasterModel = AutoMapperEntityConfiguration.Cast <BankMasterModel>(bankMasterDto);
}
ViewBag.Result = new ResultDto();
}
catch (Exception ex)
{
_log.Error("Error : Error occured in AddBank() Http Get Method", ex);
}
_log.Info("AddBank() HTTP GET METHOD END");
return(View("AddBank", bankMasterModel));
}
public List <BankMasterDto> OrganizationGetAllBanksDetails()
{
List <BankMasterDto> lstBankList = new List <BankMasterDto>();
List <uspOrganizationGetAllBanksDetails_Result> lstuspOrganizationGetAll_Result = _dbContext.uspOrganizationGetAllBanksDetails().ToList();
foreach (var bank in lstuspOrganizationGetAll_Result)
{
BankMasterDto obj = new BankMasterDto()
{
BankEntryID = bank.BankEntryID,
EntityId = bank.EntityID,
BName = bank.BankName,
BranchName = bank.BranchName,
IFSC = bank.IFSC,
AccountType = bank.AccountType,
AccountTypeText = bank.AccountTypeText,
AccountNumber = bank.AccountNumber,
ObjectID = bank.ObjectID
};
lstBankList.Add(obj);
}
return(lstBankList);
}
public List <BankMasterDto> BanksGetByObjectId(int groupId)
{
List <uspBankMasterGetAll_Result> lstuspBankMasterGetAll_Result = _dbContext.uspBankMasterGetAll().ToList();
List <BankMasterDto> lstBankMasterDto = Mapper.Map <List <uspBankMasterGetAll_Result>, List <BankMasterDto> >(lstuspBankMasterGetAll_Result);
BankMasterDto obj = null;
foreach (var bank in lstuspBankMasterGetAll_Result)
{
obj = new BankMasterDto();
obj.BankEntryID = bank.BankEntryID;
obj.EntityId = bank.EntityID;
obj.BankName = bank.BankName;
obj.BName = bank.BName;
obj.BranchName = bank.BranchName;
obj.IFSC = bank.IFSC;
obj.AccountType = bank.AccountType;
obj.AccountTypeText = bank.AccountTypeText;
obj.AccountNumber = bank.AccountNumber;
obj.ObjectID = bank.ObjectID;
lstBankMasterDto.Add(obj);
}
lstBankMasterDto = lstBankMasterDto.FindAll(g => g.ObjectID == groupId && g.EntityId == 9);
return(lstBankMasterDto);
}
//public List<BankMasterLookupDto> GetLookup()
//{
// var lstBankMasterLookupDtos = new List<BankMasterLookupDto>();
// var uspBankMasterLookupResults = _dbContext.uspBankMasterLookup().ToList();
// foreach (var bank in uspBankMasterLookupResults)
// {
// BankMasterLookupDto lookupDto = Mapper.Map<uspBankMasterLookup_Result, BankMasterLookupDto>(bank);
// lstBankMasterLookupDtos.Add(lookupDto);
// }
// return lstBankMasterLookupDtos;
//}
public BankMasterDto GetByID(int bankEntryId)
{
uspBankMasterGetByBankId_Result objuspBankMasterGetByBankIdResult =
_dbContext.uspBankMasterGetByBankId(bankEntryId).ToList().FirstOrDefault();
BankMasterDto objBankMasterDto = AutoMapperEntityConfiguration.Cast <BankMasterDto>(objuspBankMasterGetByBankIdResult);
return(objBankMasterDto);
}
public BankMasterDto GetBankNameByAHID(int AHID)
{
var objBankName = _dbContext.uspGetBankNameByAccountNumber(AHID).ToList().FirstOrDefault();
//BankMasterDto objBankMasterDto = AutoMapperEntityConfiguration.Cast<BankMasterDto>(objuspuspGetBankNameByAccountNumber);
BankMasterDto objBankMasterDto = new BankMasterDto();
objBankMasterDto.BName = objBankName;
return(objBankMasterDto);
}
public List <BankMasterDto> GetBanksList(FormCollection form)
{
int arrlst = Convert.ToInt32(Request.Form["hdnMaxRateIndex"]);
//int count = Convert.ToInt32(Request.Form["Arrlst"].Length);
long objectid = Convert.ToInt64(Request.Form["hdnObjectID"]);
List <BankMasterDto> lstbank = new List <BankMasterDto>();
for (int i = 1; i <= arrlst; i++)
{
if (form["hdnentryId_" + i] == null)
{
continue;
}
BankMasterDto objbank = new BankMasterDto();
if (form["hdnentryId_" + i] == string.Empty || form["hdnentryId_" + i] == "0")
{
objbank.BankEntryID = 0;
}
else
{
objbank.BankEntryID = Convert.ToInt32(form["hdnentryId_" + i]);
}
var BANKNAME = Convert.ToInt32(form["hdnbankname_" + i]);
objbank.BankName = BANKNAME;
if (form["hdnbname_" + i] != null)
{
objbank.BName = Convert.ToString(form["hdnbname_" + i]);
}
objbank.BranchName = form["hdnbranchcode_" + i];
objbank.IFSC = form["hdnifsc_" + i];
objbank.AccountType = Convert.ToInt32(form["hdnaccounttypeid_" + i]);
if (form["hdnaccounttypeText_" + i] != null)
{
objbank.AccountTypeText = Convert.ToString(form["hdnaccounttypeText_" + i]);
}
objbank.AccountNumber = form["hdnaccountnumber_" + i];
lstbank.Add(objbank);
}
return(lstbank);
}
private ResultDto InsertUpdateBankMaster(BankMasterDto bank)
{
ResultDto resultDto = new ResultDto();
string obectName = "bank master";
try
{
ObjectParameter paramBankEntryId = new ObjectParameter("BankEntryId", bank.BankEntryID);
ObjectParameter paramBankCode = new ObjectParameter("BankCode", string.Empty);
_dbContext.uspBankMasterInsertUpdate(paramBankEntryId, bank.BankName, bank.BranchName, bank.IFSC, bank.AccountNumber, bank.AccountType, bank.ContactNumber, bank.Email, bank.Address, bank.isMasterEntry, bank.UserID, paramBankCode);
if (bank.BankEntryID > 0)
{
resultDto.ObjectCode = bank.BankCode;
}
else
{
resultDto.ObjectCode = (string)paramBankCode.Value;
}
resultDto.ObjectId = (int)paramBankEntryId.Value;
if (resultDto.ObjectId > 0)
{
resultDto.Message = string.Format("{0} details saved successfully with code : {1}", obectName, resultDto.ObjectCode);
}
else if (resultDto.ObjectId == -1)
{
resultDto.Message = string.Format("Error occured while generating {0} code", obectName);
}
else
{
resultDto.Message = string.Format("Error occured while saving {0} details", obectName);
}
}
catch (Exception)
{
resultDto.Message = string.Format("Service layer error occured while saving the {0} details", obectName);
resultDto.ObjectId = -98;
}
return(resultDto);
}
public List <BankMasterDto> GetGroupBanks(int groupID)
{
List <BankMasterDto> lstBanks = new List <BankMasterDto>();
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@GroupID", groupID);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
SqlDataReader Dr = obj.ExecDataReaderProc("uspGetGroupBanks", parms);
while (Dr.Read())
{
BankMasterDto bankMasterDto = new BankMasterDto();
bankMasterDto.AccountNumber = Dr["AccountNumber"].ToString();
bankMasterDto.AHID = Convert.ToInt32(Dr["AHID"].ToString());
bankMasterDto.AHName = Dr["AHName"].ToString();
bankMasterDto.BankEntryID = Convert.ToInt32(Dr["BankEntryID"].ToString());
lstBanks.Add(bankMasterDto);
}
return(lstBanks);
}
//-------------------Common For Both ----------------------------//
#region getBankName
public JsonResult getBankName(int id)
{
BankMasterDto bankMasterDto = _ContraEntryService.GetBankNameByAHID(id);
return(Json(new { bankName = bankMasterDto.BName }));
}
public JsonResult GetFAccountName(int id)
{
BankMasterDto objBank = _bankService.GetByID(id);
return(Json(new { FaccountName = objBank.BName, AHID = objBank.AHID, AccountName = objBank.AHName }));
}
public ResultDto Update(BankMasterDto bank)
{
return(InsertUpdateBankMaster(bank));
}
