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