//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)); }