public Department getDepartment(string departmentId)
{
Department part = new Department();
var depart = ctx.departments.FirstOrDefault(x => x.departmentId == departmentId);
string pointName = depart.collectionPoint.address;
part.CollectionPointId = depart.collectionPointId;
part.CollectionPointName = pointName;
part.DepartmentId = depart.departmentId;
part.DepartmentName = depart.name;
part.ContactNo = depart.contactName;
part.PhoneNo = (long)depart.phoneNo;
part.FaxNo = (long)depart.faxNo;
return part;
}
//department-------------------------------------------
public void updateDepartmentCollectionPoint(Department department)
{
departmentgf.updateDepartmentCollectionGF(department);
}
public void updateDepartmentCollectionGF(Department dept)
{
department d = ctx.departments.FirstOrDefault( o => o.departmentId == dept.DepartmentId);
d.collectionPointId = dept.CollectionPointId;
ctx.SaveChanges();
}
public List<Department> getDepartments()
{
List<Department> departmentCollection = new List<Department>();
try
{
var depC = from u in ctx.users
where
u.role.name == "departmentRepresentative" &&
u.departmentId!="IVS" &&
u.status == "Active"
select new
{
depId = u.department.departmentId,
collPointId = u.department.collectionPoint.collectionPointId,
collPoint = u.department.collectionPoint.address,
repName = u.name,
depName = u.department.name
};
foreach(var d in depC)
{
Department department = new Department();
department.DepartmentId = d.depId;
department.CollectionPointId = d.collPointId;
department.CollectionPointName = d.collPoint;
department.RepresentativeName = d.repName;
department.DepartmentName = d.depName;
departmentCollection.Add(department);
}
}
catch (Exception exception)
{
errorobj.WriteErrorLog("DepartmentFacade-getDepartments():::" + exception.ToString());
departmentCollection = new List<Department>();
}
return departmentCollection;
}