public TB_PLAN getPlanById(int id) { object[] sqlParams = { new SqlParameter("@N_ID", id) }; TB_PLAN result = context.Database.SqlQuery <TB_PLAN>("Usp_GetPlanById @N_ID", sqlParams).SingleOrDefault(); return(result); }
public object createPlan(TB_PLAN model) { object[] sqlParams = { new SqlParameter("@S_NAME", model.S_NAME), new SqlParameter("@S_TYPE", model.S_TYPE), new SqlParameter("@S_DETAIL", model.S_DETAIL), new SqlParameter("@S_DESCRIPTION", model.S_DESCRIPTION) }; var result = context.Database.SqlQuery <object>("Usp_InsertPlan @S_NAME,@S_TYPE,@S_DETAIL,@S_DESCRIPTION", sqlParams).SingleOrDefault(); return(result); }
public ActionResult Create(PlanModel model) { try { var modelDB = new PlanDBModel(); TB_PLAN plan = new TB_PLAN(); plan.S_NAME = model.name; plan.S_TYPE = model.type; plan.S_DETAIL = model.detail; plan.S_DESCRIPTION = model.description; modelDB.createPlan(plan); return(RedirectToAction("List")); } catch { return(View()); } }