public DataTable GetByRoleID(string strRoleID)
{
try
{
string strCommand = "GetByRoleID";
HybridDictionary hTable = new HybridDictionary();
hTable.Add("ROLE_ID", strRoleID);
ISingleView pl = UserManager.GetEntityView(strEntityName);
return(pl.ExecuteDataTable2(CommandType.Text, strCommand, hTable));
}
catch (Exception e)
{
throw e;
}
}
public DataTable ListUserByPMS(string strPms)
{
try
{
string strCommand = "GetUserByPMS";
HybridDictionary hTable = new HybridDictionary();
hTable.Add("PMS_ID", strPms);
ISingleView pl = UserManager.GetEntityView(strEntityName);
return(pl.ExecuteDataTable2(CommandType.Text, strCommand, hTable));
}
catch (Exception e)
{
throw e;
}
}
public DataTable ListUserPMSByCategory(string strUser, string strCategory)
{
try
{
string strCommand = "GetPMSByCategory";
HybridDictionary hTable = new HybridDictionary();
hTable.Add("USER_ID", strUser);
hTable.Add("PMS_CTG_NAME", strCategory);
ISingleView pl = UserManager.GetEntityView(strEntityName);
return(pl.ExecuteDataTable2(CommandType.Text, strCommand, hTable));
}
catch (Exception e)
{
throw e;
}
}