private List <BankDetailModel> ReadBanks(DbDataReader reader)
{
List <BankDetailModel> banks = new List <BankDetailModel>();
while (reader.Read())
{
var bank = new BankDetailModel
{
bankId = new Guid(reader["BANKID"].ToString()),
RefKey = new Guid(reader["REFKEY"].ToString()),
BankName = reader["BankName"].ToString(),
BankNameId = Convert.ToInt32(reader["BankNameId"].ToString()),
BankIFSCCode = reader["BankIFSCCode"].ToString(),
BankAccountNumber = reader["BankAccountNumber"].ToString(),
BankCancelledChequeFileName = reader["CancelledChequeFileName"].ToString(),
BankCompanyName = reader["BankCompanyname"].ToString(),
BankBranchName = reader["bankBranchName"].ToString(),
IsActive = bool.Parse(reader["isActive"].ToString())
};
bank.BankCancelledChequeFileUrl = "/UploadedImages/Providers/Banks/" + bank.BankCancelledChequeFileName;
banks.Add(bank);
}
return(banks);
}
public CompanyModel()
{
Organization = new OrganizationModel();
Contacts = new List <OtherContactPersonModel>();
BankDetails = new List <BankDetailModel>();
Services = new List <ServiceModel>();
Contact = new OtherContactPersonModel();
BankDetail = new BankDetailModel();
Agreement = new AgreementModel();
}
public IActionResult BankDetail(int?id)
{
var model = new BankDetailModel();
model.Bank = new Bank();
if (id.HasValue && id.Value > 0)
{
model.Bank = DefaultStorage.BankGet(id.Value);
}
return(View(model));
}
public async Task <ActionResult> AddOrEditBank(BankDetailModel bank)
{
if (bank.BankCancelledChequeFilePath != null && bank.BankCancelledChequeFileName != null)
{
if (System.IO.File.Exists(Server.MapPath(_path + "Banks/" + bank.BankCancelledChequeFileName)))
{
System.IO.File.Delete(Server.MapPath(_path + "Banks/" + bank.BankCancelledChequeFileName));
}
}
if (bank.BankCancelledChequeFilePath != null)
{
bank.BankCancelledChequeFileName = SaveImageFile(bank.BankCancelledChequeFilePath, "Banks");
}
if (bank.bankId != null)
{
bank.EventAction = 'U';
}
else
{
bank.EventAction = 'I';
}
bank.UserId = CurrentUser.UserId;
if (TempData["client"] != null)
{
var Client = TempData["client"] as ClientModel;
bank.RefKey = Client.ClientId;
}
var response = await _bank.AddUpdateBankDetails(bank);
TempData["response"] = response;
if (TempData["client"] != null)
{
var Client = TempData["client"] as ClientModel;
bank.bankId = new Guid(response.result);
var name = Client.Bank.BankList.Where(x => x.Value == bank.BankNameId.ToString()).FirstOrDefault();
bank.BankName = name.Text;
Client.BankDetails.Add(bank);
Client.action = 'I';
Client.Activetab = "tab-5";
TempData["client"] = Client;
return(View("Create", Client));
}
else
{
var Client = await GetClient(bank.RefKey);
Client.action = 'U';
Client.Activetab = "tab-4";
return(View("Edit", Client));
}
}
public async Task <ResponseModel> AddUpdateBankDetails(BankDetailModel bank)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@BANKID", ToDBNull(bank.bankId));
sp.Add(param);
param = new SqlParameter("@BANKNAMEID", ToDBNull(bank.BankNameId));
sp.Add(param);
param = new SqlParameter("@BANKACCNUMBER", ToDBNull(bank.BankAccountNumber));
sp.Add(param);
param = new SqlParameter("@BANKCOMPATACC", ToDBNull(bank.BankCompanyName));
sp.Add(param);
param = new SqlParameter("@BANKBRANCH", ToDBNull(bank.BankBranchName));
sp.Add(param);
param = new SqlParameter("@BANKIFSC", ToDBNull(bank.BankIFSCCode));
sp.Add(param);
param = new SqlParameter("@BankCancelledChequeFileName", ToDBNull(bank.BankCancelledChequeFileName));
sp.Add(param);
param = new SqlParameter("@USER", (object)bank.UserId);
sp.Add(param);
param = new SqlParameter("@REFKEY", ToDBNull(bank.RefKey));
sp.Add(param);
param = new SqlParameter("@ACTION", (object)bank.EventAction);
sp.Add(param);
param = new SqlParameter("@IsDefault", (object)bank.IsDefault);
sp.Add(param);
var sql = "USPADDOREDITBANKDETAILS @BANKID,@BANKNAMEID,@BANKACCNUMBER,@BANKCOMPATACC,@BANKBRANCH,@BANKIFSC,@BankCancelledChequeFileName,@USER,@REFKEY ,@ACTION,@IsDefault";
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
else
{
res.IsSuccess = false;
}
return(res);
}
public async Task <ActionResult> AddOrEditBank(BankDetailModel bank)
{
if (bank.BankCancelledChequeFileName != null && bank.BankCancelledChequeFilePath != null)
{
if (System.IO.File.Exists(Server.MapPath(_path + "Cheques/" + bank.BankCancelledChequeFileName)))
{
System.IO.File.Delete(Server.MapPath(_path + "Cheques/" + bank.BankCancelledChequeFileName));
}
}
if (bank.BankCancelledChequeFilePath != null)
{
bank.BankCancelledChequeFileName = SaveImageFile(bank.BankCancelledChequeFilePath, "Cheques/");
}
if (bank.bankId == null)
{
bank.EventAction = 'I';
}
else
{
bank.EventAction = 'U';
}
CompanyModel comp = new CompanyModel();
if (TempData["Comp"] != null)
{
comp = TempData["Comp"] as CompanyModel;
comp.ActiveTab = "tab-5";
comp.Action = 'I';
comp.BankDetails.Add(bank);
comp.Agreement = new AgreementModel
{
ServiceList = await CommonModel.GetServiceType(new FilterModel()),
DeliveryServiceList = await CommonModel.GetDeliveryServiceType(new FilterModel())
};
comp.BankDetail = new BankDetailModel {
RefKey = comp.CompanyId,
BankList = new SelectList(await CommonModel.GetLookup("Bank"), "Value", "Text")
};
TempData["Comp"] = comp;
}
else
{
comp.Action = 'U';
}
bank.UserId = CurrentUser.UserId;
var response = await _BankRepo.AddUpdateBankDetails(bank);
TempData["response"] = response;
if (comp.Action == 'I')
{
return(View("Create", comp));
}
else
{
comp = await GetCompany(bank.RefKey);
comp.ActiveTab = "tab-4";
return(View("Edit", comp));
}
}
