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