public static List <int> getDepartmentIds(string userId, dx_docboxEntities database)
{
List <int> departmentIdsUser = new List <int>();
if (database != null)
{
var departmentsIds = from userDepts in database.DX_USERDEPT where userDepts.userid == userId.Trim() select userDepts.deptid;
if (departmentsIds.ToList().Count > 0)
{
departmentIdsUser = (List <int>)(departmentsIds.ToList());
}
}
return(departmentIdsUser);
}
public static int getDepartmentId(string deptname, dx_docboxEntities database)
{
if (database != null && deptname != null)
{
try
{
var deptid = database.DX_DEPARTMENT.SingleOrDefault(department => department.name == deptname).deptid;
if (deptid > 0)
{
return(Convert.ToInt32(deptid));
}
}
catch (Exception)
{
}
}
return(0);
}
public static List <string> getDepartmentName(string userId, dx_docboxEntities database)
{
List <string> departmentNames = new List <string>();
if (database != null)
{
var departmentsIds = from userDepts in database.DX_USERDEPT where userDepts.userid == userId.Trim() select userDepts.deptid;
if (departmentsIds.ToList().Count > 0)
{
var depts = from departments in database.DX_DEPARTMENT where departmentsIds.Contains(departments.deptid) select departments.name;
if (depts.ToList().Count > 0)
{
departmentNames = (List <string>)(depts.ToList());
}
}
}
return(departmentNames);
}
