//Table Accountable Form public ActionResult Get_AccountableFormTable() { FM_AccountableForm model = new FM_AccountableForm(); List <AccountableFormList> tbl_AccountableForm = new List <AccountableFormList>(); var SQLQuery = "SELECT * FROM DB_TOSS.dbo.AccountableFormTable"; //SQLQuery += " WHERE (IsActive != 0)"; using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString())) { Connection.Open(); using (SqlCommand command = new SqlCommand("[dbo].[SP_AccountableFormList]", Connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery)); SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { tbl_AccountableForm.Add(new AccountableFormList() { AccountFormID = GlobalFunction.ReturnEmptyInt(dr[0]), AccountFormName = GlobalFunction.ReturnEmptyString(dr[1]), isCTC = GlobalFunction.ReturnEmptyBool(dr[3]), Description = GlobalFunction.ReturnEmptyString(dr[2]), }); } } Connection.Close(); } model.getAccountableFormList = tbl_AccountableForm.ToList(); return(PartialView("AccountableForm/_AccountableFormTable", model.getAccountableFormList)); }
//Delete Accountable Form public ActionResult DeleteAccountableForm(FM_AccountableForm model, int AccountFormID) { AccountableFormTable tblAccountableForm = (from e in TOSSDB.AccountableFormTables where e.AccountFormID == AccountFormID select e).FirstOrDefault(); TOSSDB.AccountableFormTables.Remove(tblAccountableForm); TOSSDB.SaveChanges(); return(RedirectToAction("Index")); }
//Get Update Accountable Form public ActionResult Get_UpdateAccountableForm(FM_AccountableForm model, int AccountFormID) { AccountableFormTable tblAccountableForm = (from e in TOSSDB.AccountableFormTables where e.AccountFormID == AccountFormID select e).FirstOrDefault(); model.getAccountableFormcolumns.AccountFormID = tblAccountableForm.AccountFormID; model.getAccountableFormcolumns.AccountFormName = tblAccountableForm.AccountFormName; model.getAccountableFormcolumns.isCTC = tblAccountableForm.isCTC; model.getAccountableFormcolumns.Description = tblAccountableForm.Description; return(PartialView("AccountableForm/_UpdateAccountableForm", model)); }
//Update Accountable Form public ActionResult UpdateAccountableForm(FM_AccountableForm model) { AccountableFormTable tblAccountableForm = (from e in TOSSDB.AccountableFormTables where e.AccountFormID == model.getAccountableFormcolumns.AccountFormID select e).FirstOrDefault(); tblAccountableForm.AccountFormName = model.getAccountableFormcolumns.AccountFormName; tblAccountableForm.isCTC = model.getAccountableFormcolumns.isCTC; tblAccountableForm.Description = model.getAccountableFormcolumns.Description; TOSSDB.Entry(tblAccountableForm); TOSSDB.SaveChanges(); return(PartialView("AccountableForm/_UpdateAccountableForm", model)); }
//Add Accountable Form public JsonResult AddAccountableForm(FM_AccountableForm model) { AccountableFormTable tblAccountableForm = new AccountableFormTable(); tblAccountableForm.AccountFormName = model.getAccountableFormcolumns.AccountFormName; tblAccountableForm.isCTC = model.getAccountableFormcolumns.isCTC; tblAccountableForm.Description = model.getAccountableFormcolumns.Description; TOSSDB.AccountableFormTables.Add(tblAccountableForm); TOSSDB.SaveChanges(); return(Json(tblAccountableForm)); }
//Get Add Accountable Form Partial View public ActionResult Get_AddAccountableForm() { FM_AccountableForm model = new FM_AccountableForm(); return(PartialView("AccountableForm/_AddAccountableForm", model)); }