public BanksModel GetBanks()
{
BanksModel bank = new BanksModel();
ENDPOINT = body.getQueryGetBanks(_PUBLIC_KEY);
string content = _restRequest.Execute(
ENDPOINT,
"GET",
_auxiliars.ConvertToBase64(_PUBLIC_KEY),
PARAMETER);
BankResponse response = JsonConvert.DeserializeObject <BankResponse>(content);
if (response.success)
{
bank = JsonConvert.DeserializeObject <BanksModel>(content);
}
else
{
bank.success = response.success;
bank.text_response = response.text_response;
bank.title_response = response.title_response;
bank.last_action = response.last_action;
}
return(bank);
}
public ActionResult GetBankDTable()
{
BanksModel model = new BanksModel();
List <BankList> getBankList = new List <BankList>();
var SQLQuery = "SELECT * FROM [Tbl_FMBank_Banks]";
//BankID, BankTitle, BankCode, BankAddress
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_Banks]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
getBankList.Add(new BankList()
{
BankID = GlobalFunction.ReturnEmptyInt(dr[0]),
BankTitle = GlobalFunction.ReturnEmptyString(dr[1]),
BankCode = GlobalFunction.ReturnEmptyString(dr[2]),
BankAddress = GlobalFunction.ReturnEmptyString(dr[3])
});
}
}
Connection.Close();
}
model.getBankList = getBankList.ToList();
return(PartialView("BankTab/_TableBank", getBankList));
}
public IActionResult GetBanks()
{
BanksModel banks = epayco.GetBanks();
return(Ok(banks));
}
public ActionResult GetBankForm(int ActionID, int PrimaryID)
{
BanksModel model = new BanksModel();
if (ActionID == 2)
{
var bank = (from a in BOSSDB.Tbl_FMBank_Banks where a.BankID == PrimaryID select a).FirstOrDefault();
model.BankList.BankID = bank.BankID;
model.BankList.BankCode = bank.BankCode;
model.BankList.BankAddress = bank.BankAddress;
model.BankList.BankTitle = bank.BankTitle;
}
model.ActionID = ActionID;
return(PartialView("BankTab/_BankForm", model));
}
public ActionResult SaveBank(BanksModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var bankTitle = model.BankList.BankTitle;
var bankCode = model.BankList.BankCode;
var bankAdd = model.BankList.BankAddress;
Tbl_FMBank_Banks checkBanks = (from a in BOSSDB.Tbl_FMBank_Banks where (a.BankTitle == bankTitle && a.BankAddress == bankAdd) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkBanks == null)
{
Tbl_FMBank_Banks bank = new Tbl_FMBank_Banks();
bank.BankTitle = bankTitle;
bank.BankCode = bankCode;
bank.BankAddress = bankAdd;
BOSSDB.Tbl_FMBank_Banks.Add(bank);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkBanks != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMBank_Banks bankii = (from a in BOSSDB.Tbl_FMBank_Banks where a.BankID == model.BankList.BankID select a).FirstOrDefault();
List <Tbl_FMBank_Banks> banktitleCount = (from e in BOSSDB.Tbl_FMBank_Banks where e.BankTitle == bankTitle select e).ToList();
List <Tbl_FMBank_Banks> bankaddCount = (from e in BOSSDB.Tbl_FMBank_Banks where e.BankAddress == bankAdd select e).ToList();
if (checkBanks != null)
{
if (bankii.BankTitle == bankTitle && bankii.BankCode == bankCode && bankii.BankAddress == bankAdd)
{
isExist = "justUpdate";
}
else
{
if (bankii.BankTitle != bankTitle && banktitleCount.Count >= 1 || bankii.BankAddress != bankAdd && bankaddCount.Count >= 1)
{
isExist = "true";
}
else
{
isExist = "justUpdate";
}
}
}
else if (checkBanks == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
bankii.BankTitle = bankTitle;
bankii.BankCode = bankCode;
bankii.BankAddress = bankAdd;
BOSSDB.Entry(bankii);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
//---------------------------------------------------------------------------------------------------------------------
//Bank Accounts Tab
//---------------------------------------------------------------------------------------------------------------------
public ActionResult GetBankAccntTab()
{
BanksModel model = new BanksModel();
return(PartialView("BankAccountsTab/IndexBankAccount", model));
}
// GET: FileMaintenanceBank
public ActionResult FileMaintenanceBank()
{
BanksModel model = new BanksModel();
return(View(model));
}
//---------------------------------------------------------------------------------------------------------------------
//Account Type Tab
//---------------------------------------------------------------------------------------------------------------------
public ActionResult GetAccntTypeTab()
{
BanksModel model = new BanksModel();
return(PartialView("AccountTypeTab/IndexAccountType", model));
}
