//Get Bank Update
public ActionResult Get_UpdateBanks(FM_GeneralReference_Bank model, int BankID)
{
BankTable tblBank = (from e in TOSSDB.BankTables where e.BankID == BankID select e).FirstOrDefault();
model.getBankColumns.BankName = tblBank.BankName;
return(PartialView("Banks/_UpdateBankTable", model));
}
//Bank Table Partial View
public ActionResult Get_BankTables()
{
FM_GeneralReference_Bank model = new FM_GeneralReference_Bank();
List <BankList> tbl_Bank = new List <BankList>();
var SQLQuery = "SELECT * FROM DB_TOSS.dbo.BankTable";
//SQLQuery += " WHERE (IsActive != 0)";
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_BankTable]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
tbl_Bank.Add(new BankList()
{
BankID = GlobalFunction.ReturnEmptyInt(dr[0]),
BankName = GlobalFunction.ReturnEmptyString(dr[1]),
});
}
}
Connection.Close();
}
model.getBankList = tbl_Bank.ToList();
return(PartialView("Banks/_BankTable", model.getBankList));
}
//Delete Bank
public ActionResult DeleteBank(FM_GeneralReference_Bank model, int BankID)
{
BankTable tblBank = (from e in TOSSDB.BankTables where e.BankID == BankID select e).FirstOrDefault();
TOSSDB.BankTables.Remove(tblBank);
TOSSDB.SaveChanges();
return(RedirectToAction("Index"));
}
//Update Bank
public ActionResult UpdateBanks(FM_GeneralReference_Bank model)
{
BankTable tblBank = (from e in TOSSDB.BankTables where e.BankID == model.BankID select e).FirstOrDefault();
tblBank.BankName = model.getBankColumns.BankName;
TOSSDB.Entry(tblBank);
TOSSDB.SaveChanges();
return(PartialView("Banks/_UpdateBankTable", model));
}
//Add Bank Type
public JsonResult AddBank(FM_GeneralReference_Bank model)
{
BankTable tblBank = new BankTable();
tblBank.BankName = GlobalFunction.ReturnEmptyString(model.getBankColumns.BankName);
TOSSDB.BankTables.Add(tblBank);
TOSSDB.SaveChanges();
return(Json(tblBank));
}
//Get Add Bank Partial View
public ActionResult Get_AddBanks(FM_GeneralReference_Bank model)
{
return(PartialView("Banks/_AddBankTable", model));
}
