public static ValueHelpViewModel GetValueHelpTextDis(string valueType, string valueText, string status = "")
{
ValueHelpViewModel valueHelp = new ValueHelpViewModel();
try
{
valueHelp = ValueHelpService.GetValueHelp(valueType, status).Single(m => m.ValueText == valueText);
}
catch (Exception ex)
{
}
return(valueHelp);
}
public static List <ValueHelpViewModel> GetValueHelp(string valueType, string status = "")
{
List <ValueHelpViewModel> valueHelpList = new List <ValueHelpViewModel>();
try
{
if (string.IsNullOrEmpty(status))
{
status = ConstantVariableService.ConfigStatusActive;;
}
using (var context = new PYMFEEEntities())
{
IOrderedQueryable <ValueHelp> valueHelps;
if (string.Equals(valueType, "ALL", StringComparison.OrdinalIgnoreCase))
{
valueHelps = (from m in context.ValueHelps
where m.Status == status
select m).OrderBy(m => m.Sequence);
}
else
{
valueHelps = (from m in context.ValueHelps
where m.ValueType == valueType &&
m.Status == status
select m).OrderBy(m => m.Sequence);
}
foreach (var value in valueHelps)
{
ValueHelpViewModel valueHelp = new ValueHelpViewModel();
valueHelp.ID = value.ID;
valueHelp.ValueKey = value.ValueKey;
valueHelp.ValueText = value.ValueText;
valueHelp.ValueType = value.ValueType;
valueHelp.Status = value.Status;
valueHelpList.Add(valueHelp);
}
}
}
catch (Exception ex)
{
}
return(valueHelpList);
}
public List <AssignUserRoleViewModel> GetAssignUserRoleList(string _userRoleCode = "")//(string userRole, string userRoleCode = "")
{
List <AssignUserRoleViewModel> assignUserRoleList = new List <AssignUserRoleViewModel>();
ValueHelpViewModel valueHelp = new ValueHelpViewModel();
try
{
using (var context = new PYMFEEEntities())
{
var userRol = string.IsNullOrEmpty(_userRoleCode)?
(from user in context.UserRoles select user).ToList() : (from user in context.UserRoles where user.USERID == _userRoleCode select user).ToList();;
var assignUserRoleEmp = string.IsNullOrEmpty(_userRoleCode) ?
(from emp in context.USERS select emp).ToList() : (from emp in context.USERS where emp.USERID == _userRoleCode select emp).ToList();
foreach (var item in assignUserRoleEmp)
{
string _getIcon = Convert.ToString(userRol.Where(m => m.USERID == item.USERID).FirstOrDefault());
var assign = new AssignUserRoleViewModel();
string icon = "";
if (!string.IsNullOrEmpty(item.USERID) && !string.IsNullOrEmpty(_getIcon))
{
icon = "<i class=\"fa fa-check-circle\" style=\"color: #4277f4; font-size: 20px\"></i>";
}
assign.AssignUserCode = item.USERID;
assign.AssignUserName = item.USERNAME;
assign.UserName = item.USERNAME;
assign.AssignUserRoleIcon = icon;
assign.AssignAvailableReason = ValidatorMessage.cannot_assignuserrole_action;
assignUserRoleList.Add(assign);
}
}
}
catch (Exception ex)
{
}
return(assignUserRoleList);
}
