public ActionResult AddBank(BankMasterModel bankMasterModel)
{
ResultDto resultDto = new ResultDto();
if (ModelState.IsValid)
{
var bankMasterDto = Mapper.Map <BankMasterModel, BankMasterDto>(bankMasterModel);
bankMasterDto.UserID = UserInfo.UserID;
bankMasterDto.isMasterEntry = true;
if (bankMasterModel.BankEntryID == 0)
{
resultDto = _bankService.Insert(bankMasterDto);
}
else
{
resultDto = _bankService.Update(bankMasterDto);
}
if (resultDto.ObjectId > 0)
{
bankMasterDto = _bankService.GetByID(resultDto.ObjectId);
bankMasterModel = AutoMapperEntityConfiguration.Cast <BankMasterModel>(bankMasterDto);
resultDto.ObjectCode = bankMasterDto.BankCode;
}
}
SelectList bankNames = GetDropDownListByMasterCode(Enums.RefMasterCodes.BANK_NAME);
SelectList accountTypes = GetDropDownListByMasterCode(Enums.RefMasterCodes.BANK_ACCOUNT_TYPE);
ViewBag.BankNames = bankNames;
ViewBag.AccountTypes = accountTypes;
ViewBag.Result = resultDto;
return(View("AddBank", bankMasterModel));
}
public BankMasterModel GetBankMasterDetail(int id)
{
try
{
var data = _tRSEntities.BankMasters.Where(x => x.id == id && x.IsActive == true).FirstOrDefault();
BankMasterModel model = new BankMasterModel();
if (data != null)
{
model.id = data.id;
model.Bank_Name = data.Bank_Name;
model.Bank_Branch = data.Bank_Branch;
model.Address = data.Address;
model.state = data.state;
model.IFSC_code = data.IFSC_code;
model.city = data.city;
model.Contact = data.Contact;
model.DOC = data.DOC;
model.DOM = data.DOM;
model.IsActive = data.IsActive;
}
return(model);
}
catch (Exception e)
{
throw e;
}
}
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 bool SaveBankMaster(BankMasterModel model)
{
try
{
if (model != null)
{
BankMaster BM = new BankMaster();
BM.id = 111;
BM.Bank_Name = model.Bank_Name;
BM.IFSC_code = model.IFSC_code;
BM.Bank_Branch = model.Bank_Branch;
BM.Address = model.Address;
BM.state = model.state;
BM.city = model.city;
BM.Contact = model.Contact;
BM.DOC = DateTime.Now;
BM.DOM = DateTime.Now;
BM.IsActive = true;
_tRSEntities.BankMasters.Add(BM);
_tRSEntities.SaveChanges();
return(true);
}
}
catch (Exception e)
{
throw e;
}
return(true);
}
public List <BankMasterModel> GetBankMasterDetails()
{
try
{
List <BankMasterModel> models = new List <BankMasterModel>();
var data = _tRSEntities.BankMasters.Where(x => x.IsActive == true).ToList();
if (data != null)
{
foreach (var item in data)
{
BankMasterModel model = new BankMasterModel();
model.id = item.id;
model.Bank_Name = item.Bank_Name;
model.IFSC_code = item.IFSC_code;
model.Bank_Branch = item.Bank_Branch;
model.Address = item.Address;
model.state = item.state;
model.city = item.city;
model.Contact = item.Contact;
model.DOC = item.DOC;
model.DOM = item.DOM;
model.IsActive = (bool)item.IsActive;
models.Add(model);
}
}
return(models);
}
catch (Exception e)
{
throw e;
}
}
public bool UpdateBankMasterDetails(BankMasterModel model)
{
try
{
if (model != null)
{
var data = _tRSEntities.BankMasters.Where(x => x.id == model.id && x.IsActive == true).FirstOrDefault();
if (data != null)
{
data.Bank_Name = model.Bank_Name;
data.Bank_Branch = model.Bank_Branch;
data.IFSC_code = model.IFSC_code;
data.Address = model.Address;
data.state = model.state;
data.city = model.city;
data.Contact = model.Contact;
data.DOC = model.DOC;
data.DOM = System.DateTime.Now;
data.IsActive = true;
_tRSEntities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
return(true);
}
catch (Exception e)
{
throw e;
}
}
public IList <BankMasterModel> GetBankLists()
{
IList <BankMasterModel> BankDetails = new List <BankMasterModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetBankLists";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
BankMasterModel model = new BankMasterModel();
model.Id = Convert.ToInt32(reader["Id"]);
model.BankName = Convert.ToString(reader["BankName"]);
model.IsActive = Convert.ToBoolean(reader["IsActive"]);
BankDetails.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(BankDetails);
}
public IHttpActionResult UpdateBankMasterDetails(BankMasterModel model)
{
var data = bankMasterRepo.UpdateBankMasterDetails(model);
return(Ok(data));
}
