private void LoadPeriodicReportsList() { if ((Username == null) || (Username == "")) { UserType userType = UserContext.UserData.UserType; if (userType == UserType.SaltAdmin) { PeriodicReportsGrid.DataSourceID = "ReportDataSource"; } else if (userType == UserType.UnitAdmin || userType == UserType.OrgAdmin) { DataTable dtUser = new User().GetUser(UserContext.UserID); Username = dtUser.Rows[0]["Username"].ToString(); } } if ((Username != null) && (Username.Length > 0)) { PeriodicReportsGrid.DataSourceID = "ReportUserDataSource"; ReportUserDataSource.SelectParameters["Username"].DefaultValue = Username; } PeriodicReportsGrid.DataBind(); if (PeriodicReportsGrid.Rows.Count == 0) { lblNoneFound.Visible = true; ExportTypes.Visible = false; btnExport.Visible = false; SelectAll.Visible = false; ClearAll.Visible = false; DeleteSelected.Visible = false; ReassignSelected.Visible = false; ExportType2.Visible = false; btnExport2.Visible = false; } else { lblNoneFound.Visible = false; ExportTypes.Visible = true; btnExport.Visible = true; SelectAll.Visible = true; ClearAll.Visible = true; DeleteSelected.Visible = true; ReassignSelected.Visible = true; ExportType2.Visible = true; btnExport2.Visible = true; } if (UserContext.UserData.UserType == UserType.UnitAdmin) { // hide admin type column PeriodicReportsGrid.Columns[12].Visible = false; } }
private void LoadPeriodicReportsList() { List <string> inactivatedEmails = (List <string>)Session["InactivatedEmails"]; if ((Username != null) && (Username.Length > 0)) { PeriodicReportsGrid.DataSourceID = "ReportUserDataSource"; ReportUserDataSource.SelectParameters["Username"].DefaultValue = Username; } else if ((inactivatedEmails != null) && (inactivatedEmails.Count > 0)) { PeriodicReportsGrid.DataSourceID = "ReportEmailsDataSource"; } else { PeriodicReportsGrid.DataSourceID = "ReportDataSource"; } PeriodicReportsGrid.DataBind(); if (PeriodicReportsGrid.Rows.Count == 0) { lblNoneFound.Visible = true; SelectAll.Visible = false; ClearAll.Visible = false; DeleteSelected.Visible = false; ReassignSelected.Visible = false; } else { lblNoneFound.Visible = false; SelectAll.Visible = true; ClearAll.Visible = true; DeleteSelected.Visible = true; ReassignSelected.Visible = true; } }
private void ReloadPeriodicReportList() { // remove from grid only (not from DB) as Save is not yet clicked DataTable dtReports = new DataTable(); DataColumn dc1 = new DataColumn("ScheduleID"); DataColumn dc2 = new DataColumn("UserID"); DataColumn dc3 = new DataColumn("ReportID"); DataColumn dc4 = new DataColumn("ReportTitle"); DataColumn dc5 = new DataColumn("Username"); DataColumn dc6 = new DataColumn("ReportName"); DataColumn dc7 = new DataColumn("ReportFrequency"); dtReports.Columns.Add(dc1); dtReports.Columns.Add(dc2); dtReports.Columns.Add(dc3); dtReports.Columns.Add(dc4); dtReports.Columns.Add(dc5); dtReports.Columns.Add(dc6); dtReports.Columns.Add(dc7); foreach (GridViewRow row in PeriodicReportsGrid.Rows) { int schId = 0; Int32.TryParse(PeriodicReportsGrid.DataKeys[row.RowIndex].Values["ScheduleID"].ToString(), out schId); if (!SelectedForDelete.Keys.Contains(schId)) { DataRow dr = dtReports.NewRow(); int scheduleId = 0; Int32.TryParse(PeriodicReportsGrid.DataKeys[row.RowIndex].Values["ScheduleID"].ToString(), out scheduleId); dr["ScheduleID"] = scheduleId; int ReportID = 0; Int32.TryParse(PeriodicReportsGrid.DataKeys[row.RowIndex].Values["ReportID"].ToString(), out ReportID); dr["ReportID"] = ReportID; dr["ReportTitle"] = ((HyperLink)(PeriodicReportsGrid.Rows[row.RowIndex].Cells[4].Controls[0])).Text; int UserID = 0; Int32.TryParse(PeriodicReportsGrid.DataKeys[row.RowIndex].Values["UserID"].ToString(), out UserID); string username = PeriodicReportsGrid.Rows[row.RowIndex].Cells[5].Text; if (SelectedForReassign.Keys.Contains(scheduleId)) { int userId = 0; SelectedForReassign.TryGetValue(scheduleId, out userId); UserID = userId; BusinessServices.User user = new BusinessServices.User(); DataTable dtUser = user.GetUser(userId); username = dtUser.Rows[0]["Username"].ToString(); } dr["UserID"] = UserID; dr["Username"] = username; dr["ReportName"] = PeriodicReportsGrid.Rows[row.RowIndex].Cells[6].Text; dr["ReportFrequency"] = PeriodicReportsGrid.Rows[row.RowIndex].Cells[7].Text; dtReports.Rows.Add(dr); } } DataView dvReports = dtReports.DefaultView; PeriodicReportsGrid.DataSourceID = null; PeriodicReportsGrid.DataSource = dvReports; PeriodicReportsGrid.DataBind(); if (PeriodicReportsGrid.Rows.Count == 0) { lblNoneFound.Visible = true; SelectAll.Visible = false; ClearAll.Visible = false; DeleteSelected.Visible = false; ReassignSelected.Visible = false; } else { lblNoneFound.Visible = false; SelectAll.Visible = true; ClearAll.Visible = true; DeleteSelected.Visible = true; ReassignSelected.Visible = true; } }