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