public static List <UserDashboard> GetUserDashboardWhenKpiIdIsNotIn(int kpiId, int userId) { if (kpiId <= 0) { throw new ArgumentException("kpiId cannot be equals or less than zero"); } if (userId <= 0) { throw new ArgumentException("userId cannot be equals or less than zero"); } DashboardDSTableAdapters.UserDashboardsTableAdapter adapter = new DashboardDSTableAdapters.UserDashboardsTableAdapter(); DashboardDS.UserDashboardsDataTable table = adapter.GetUserDashboardWhenKpiIdIsNotIn(kpiId, userId); List <UserDashboard> list = new List <UserDashboard>(); foreach (var row in table) { list.Add(new UserDashboard() { DashboardId = row.dashboardId, Name = row.name, OwnerUserId = row.ownerUserId }); } return(list); }
public static UserDashboard GetUserDashboardById(int dashboardId) { if (dashboardId <= 0) { throw new ArgumentException("dashboardId cannot be equals or less than zero"); } DashboardDSTableAdapters.UserDashboardsTableAdapter adapter = new DashboardDSTableAdapters.UserDashboardsTableAdapter(); DashboardDS.UserDashboardsDataTable table = adapter.GetUserDashboardById(dashboardId); DashboardDS.UserDashboardsRow row = table[0]; UserDashboard obj = new UserDashboard() { DashboardId = row.dashboardId, Name = row.name, OwnerUserId = row.ownerUserId }; return(obj); }