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