public TB_DEPARTMENT getDepartmentById(int id) { object[] sqlParams = { new SqlParameter("@N_ID", id) }; TB_DEPARTMENT result = context.Database.SqlQuery <TB_DEPARTMENT>("Usp_GetDepartmentById @N_ID", sqlParams).SingleOrDefault(); return(result); }
public object createDepartment(TB_DEPARTMENT model) { object[] sqlParams = { new SqlParameter("@S_NAME", model.S_NAME), new SqlParameter("@S_CONTACT", model.S_CONTACT) }; var result = context.Database.SqlQuery <object>("Usp_InsertDepartment @S_NAME,@S_CONTACT", sqlParams).SingleOrDefault(); return(result); }
public ActionResult Create(DepartmentModel departmentModel) { try { var model = new DepartmentDBModel(); TB_DEPARTMENT department = new TB_DEPARTMENT(); department.S_NAME = departmentModel.departmentName; department.S_CONTACT = departmentModel.contact; model.createDepartment(department); return(RedirectToAction("List")); } catch { return(View()); } }