public JsonResult FindCollectionPoint(int id, string location)
{
//scheduled and received
List <int> idCPs = _collectionPointDAO.FindByClerkId(id);
var departments = from d in _departmentDAO.FindDepartmentsByLocation(location)
select new
{
deptName = d.Name,
deptRep = (_employeeDAO.FindDepartmentRep(d.CodeDepartment) == null)? "": _employeeDAO.FindDepartmentRep(d.CodeDepartment).Name,
contact = _employeeDAO.FindDepartmentRep(d.CodeDepartment) == null? "": _employeeDAO.FindDepartmentRep(d.CodeDepartment).Tel,
disId = (d.Disbursements.Where(x => x.IdStatus == 10 || x.IdStatus == 11).FirstOrDefault() == null)? null: (d.Disbursements.Where(x => x.IdStatus == 10 || x.IdStatus == 11).FirstOrDefault()
.IdDisbursement.ToString()),
items = (d.Disbursements.Where(x => x.IdStatus == 10 || x.IdStatus == 11).FirstOrDefault() == null) ? null: (from i in d.Disbursements.Where(x => (x.IdStatus == 10 || x.IdStatus == 11) && idCPs.Contains(x.IdCollectionPt.GetValueOrDefault(0))).FirstOrDefault().DisbursementItems
select new { description = i.Item.Description, unit = i.UnitIssued })
};
return(Json(new { location, departments }, JsonRequestBehavior.AllowGet));
}
