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