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