//for adding into Core_AdminBanks Table
public ActionResponse Create(AdminBankAccountModel model, out ActionResponse _ores)
{
if (IsExists(model.AdminBankId, model.BankId, model.BankBranchId, model.AccountNumber) == false)
{
Core_AdminBanks datamodel = new Core_AdminBanks
{
BankId = model.BankId,
BankBranchId = model.BankBranchId,
BankAccountTypeId = model.BankAccountTypeId,
AccountName = model.AccountName,
AccountNumber = model.AccountNumber
};
_ent.AddToCore_AdminBanks(datamodel);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullySaved, "Bank detail");
_res.ErrNumber = 0;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bank detail");
_res.ErrNumber = 1001;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
_ores = _res;
return(_res);
}
public ActionResult Create(AdminBankAccountModel model)
{
try
{
model = _pro.FillDdl(model);
_pro.Create(model, out _res);
TempData["SuccessMessage"] = "Successfully created the bank.";
//Session["ActionResponse"] = _res;
return(RedirectToAction("Index"));
}
catch (SqlException ex)
{
model = _pro.FillDdl(model);
_res.ActionMessage = ATLTravelPortal.Repository.SqlErrorHandle.Message(ex);
_res.ErrNumber = ex.Number;
_res.ErrType = "App";
_res.ResponseStatus = true;
// Session["ActionResponse"] = _res;
TempData["ActionResponse"] = "Unable to create a bank.";
return(View(model));
}
catch
{
model = _pro.FillDdl(model);
_res.ActionMessage = String.Format(Resources.SQLErrorMessage.Error);
_res.ErrNumber = 2000;
_res.ErrType = "App";
_res.ResponseStatus = true;
// Session["ActionResponse"] = _res;
TempData["ActionResponse"] = "Unable to create a bank.";
return(View(model));
}
}
public ActionResult Detail(int?id)
{
try
{
_model = _pro.Detail(id, out _res);
Session["ActionResponse"] = _res;
if (_res.ErrNumber > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(_model));
}
}
catch (SqlException ex)
{
_res.ActionMessage = ATLTravelPortal.Repository.SqlErrorHandle.Message(ex);
_res.ErrNumber = ex.Number;
_res.ErrType = "App";
_res.ResponseStatus = true;
Session["ActionResponse"] = _res;
return(RedirectToAction("Index"));
}
catch
{
_res.ActionMessage = String.Format(Resources.SQLErrorMessage.Error);
_res.ErrNumber = 2000;
_res.ErrType = "App";
_res.ResponseStatus = true;
Session["ActionResponse"] = _res;
return(RedirectToAction("Index"));
}
}
//for listing
public IEnumerable <AdminBankAccountModel> List()
{
List <AdminBankAccountModel> model = new List <AdminBankAccountModel>();
var result = _ent.Core_AdminBanks;
foreach (var item in result)
{
AdminBankAccountModel obj = new AdminBankAccountModel();
obj.AdminBankId = item.AdminBankId;
obj.BankId = item.BankId;
obj.BankName = item.Banks.BankName;
obj.BankBranchId = item.BankBranchId;
obj.BankBranchName = item.BankBranches.BranchName;
obj.BankAccountTypeId = item.BankAccountTypeId;
obj.BankAccountTypeName = item.BankAccountTypes.AccountTypeName;
obj.AccountName = item.AccountName;
if (obj.AccountNumber == "")
{
obj.AccountNumber = "";
}
else
{
obj.AccountNumber = item.AccountNumber;
}
model.Add(obj);
}
return(model.AsEnumerable());
}
public AdminBankAccountModel FillDdl(AdminBankAccountModel model)
{
model.ddlBankList = new SelectList(GetBankList(), "BankId", "BankName");
model.ddlBankBranchList = new SelectList(GetBankBranchList(model.BankId), "BankBranchId", "BranchName");
model.ddlAccountTypeList = new SelectList(GetBankAccountTypesList(), "BankAccountTypeId", "AccountTypeName");
return(model);
}
//for edit
public ActionResponse Edit(AdminBankAccountModel model)
{
if (IsExists(model.AdminBankId, model.BankId, model.BankBranchId, model.AccountNumber) == false)
{
Core_AdminBanks result = _ent.Core_AdminBanks.Where(x => x.AdminBankId == model.AdminBankId).FirstOrDefault();
result.AdminBankId = model.AdminBankId;
result.BankId = model.BankId;
result.BankBranchId = model.BankBranchId;
result.BankAccountTypeId = model.BankAccountTypeId;
result.AccountName = model.AccountName;
result.AccountNumber = model.AccountNumber;
_ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
_ent.SaveChanges();
_res.ActionMessage = String.Format(Resources.Message.SuccessfullyUpdated, "Bank detail");
_res.ErrNumber = 0;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bank detail");
_res.ErrNumber = 1001;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
return(_res);
}
public ActionResult Edit(int?id)
{
_model = _pro.Detail(id, out _res);
_model = _pro.FillDdl(_model);
Session["ActionResponse"] = _res;
if (_res.ErrNumber > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(_model));
}
}
public ActionResult Create()
{
try
{
_model = _pro.FillDdl(_model);
}
catch
{
_res.ActionMessage = String.Format(Resources.SQLErrorMessage.Error);
_res.ErrNumber = 2000;
_res.ErrType = "App";
_res.ResponseStatus = true;
Session["ActionResponse"] = _res;
}
return(View(_model));
}
public AdminBankAccountModel Detail(int?id, out ActionResponse _ores)
{
AdminBankAccountModel model = new AdminBankAccountModel();
if (id != null)
{
Core_AdminBanks result = _ent.Core_AdminBanks.Where(x => x.AdminBankId == id).FirstOrDefault();
if (result != null)
{
model.AdminBankId = result.AdminBankId;
model.BankId = result.BankId;
model.BankName = result.Banks.BankName;
model.BankBranchId = result.BankBranchId;
model.BankBranchName = result.BankBranches.BranchName;
model.BankAccountTypeId = result.BankAccountTypeId;
model.BankAccountTypeName = result.BankAccountTypes.AccountTypeName;
model.AccountName = result.AccountName;
model.AccountNumber = result.AccountNumber;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "My banks");
_res.ErrNumber = 1005;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
}
else
{
_res.ActionMessage = String.Format(Resources.Message.InvalidOperation, "My banks");
_res.ErrNumber = 1005;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
_ores = _res;
return(model);
}
public ActionResult Edit(AdminBankAccountModel model)
{
try
{
_res = _pro.Edit(model);
Session["ActionResponse"] = _res;
if (_res.ErrNumber == 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(_model));
}
}
catch (SqlException ex)
{
model = _pro.FillDdl(model);
_res.ActionMessage = ATLTravelPortal.Repository.SqlErrorHandle.Message(ex);
_res.ErrNumber = ex.Number;
_res.ErrType = "App";
_res.ResponseStatus = true;
Session["ActionResponse"] = _res;
return(View(model));
}
catch
{
model = _pro.FillDdl(model);
_res.ActionMessage = String.Format(Resources.SQLErrorMessage.Error);
_res.ErrNumber = 2000;
_res.ErrType = "App";
_res.ResponseStatus = true;
Session["ActionResponse"] = _res;
return(View(model));
}
}
