public ActionResult LoadDept()
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var search = Request.Form.GetValues("search[value]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
// dc.Configuration.LazyLoadingEnabled = false; // if your table is relational, contain foreign key
var v = (from a in _departmentservice.GetAllDepartment() select a);
if (!string.IsNullOrEmpty(search))
{
v = v.Where(a => a.Name.ToLower().StartsWith(search.ToLower()) || a.Name.ToLower().StartsWith(search.ToLower()));
}
// SORT
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
recordsTotal = v.Count();
var data = v.Skip(skip).Take(pageSize).ToList();
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddDepttoHospital(string id)
{
var dept = _departmentService.GetAllDepartment().Select(DE => new
{
DepName = DE.Name,
DepId = DE.Id.ToString()
// Selected = true
}).ToList();
ViewBag.DeptList = new MultiSelectList(dept, "DepId", "DepName");
return(PartialView("_AddDept"));
}
public IResponseDTO GetAllDepartment()
{
var depart = _departmentServices.GetAllDepartment();
return(depart);
}
