protected void btnContinue2_Click(object sender, EventArgs e) { if (Page.IsValid) { licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); //licenseeDT = new dsUser.licenseeDataTable(); //licenseeDT = licenseeTA.GetAllUsers(); licenseeTA.ResetBlast(); if (ddlSitelet.SelectedValue != "0") { uspSiteletDT = (dsUser.uspLicenseesBySiteletIDDataTable)Session["uspSiteletDT"]; for (int j = 0; j < uspSiteletDT.Rows.Count; j++) { licenseeTA.UpdateBlast(Convert.ToInt32(uspSiteletDT.Rows[j]["id"].ToString())); //licenseeDT.FindByID(Convert.ToInt32(uspSiteletDT.Rows[j]["id"].ToString()))["blast"] = Convert.ToBoolean(1); } //licenseeTA.Update(licenseeDT); } else if (ddlRequesters.SelectedValue != "0") { uspRequesterDT = (dsUser.uspLicenseesByRequesterIDDataTable)Session["uspRequesterDT"]; for (int j = 0; j < uspRequesterDT.Rows.Count; j++) { licenseeTA.UpdateBlast(Convert.ToInt32(uspRequesterDT.Rows[j]["id"].ToString())); } licenseeTA.Dispose(); //tableRequestor.Visible = true; //UpdatePanel1.UpdateMode } else if (ddlUserLevel.SelectedValue != "0") { uspUserLevelDT = (dsUser.uspLicenseesByUserLevelDataTable)Session["uspUserLevelDT"]; for (int j = 0; j < uspUserLevelDT.Rows.Count; j++) { licenseeTA.UpdateBlast(Convert.ToInt32(uspUserLevelDT.Rows[j]["id"].ToString())); } } else if (ddlCategory.SelectedValue != "0") { uspUserCategoryDT = (dsUser.uspLicenseesByUserCategoryDataTable)Session["uspUserCategoryDT"]; for (int j = 0; j < uspUserCategoryDT.Rows.Count; j++) { licenseeTA.UpdateBlast(Convert.ToInt32(uspUserCategoryDT.Rows[j]["id"].ToString())); } } Response.Redirect("emailblaster2.aspx"); //lblStep.Text = "Step 3 of 4:"; //bodyID.Attributes.Add("onload", ""); //lblDescription.Text = "Provide the email subject and message"; //tableUserLevel.Visible = false; //tableUserCategory.Visible = true; //btnContinue3.Attributes.Add("onclick", "return submitForm();"); } }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetExpires(DateTime.Now.AddSeconds(0)); Response.Cache.SetCacheability(HttpCacheability.Public); if (Session["message"] != null) { sContent = Session["message"].ToString(); } ddlSitelet.Attributes.Add("onchange", "MutuallyExclusive('sitelet')"); ddlRequesters.Attributes.Add("onchange", "MutuallyExclusive('requester')"); ddlUserLevel.Attributes.Add("onchange", "MutuallyExclusive('level')"); ddlCategory.Attributes.Add("onchange", "MutuallyExclusive('category')"); if (Page.IsPostBack) { if (ddlSitelet.SelectedValue != "0") { //if ((Session["by"] == null)||(Session["by"].ToString() != "sitelet" + ddlSitelet.SelectedValue)) //{ uspSiteletTA = new dsUserTableAdapters.uspLicenseesBySiteletIDTableAdapter(); uspSiteletDT = new dsUser.uspLicenseesBySiteletIDDataTable(); uspSiteletDT = uspSiteletTA.GetLicenseesBySiteletID(Convert.ToInt32(ddlSitelet.SelectedValue)); for (int j = 0; j < uspSiteletDT.Rows.Count; j++) { if (uspSiteletDT.Rows[j]["UserLevel"].ToString() == "C") { if (!(uspSiteletDT.Rows[j]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) > uspSiteletDT[j].AllowedYear) { uspSiteletDT.Rows[j].Delete(); } } else { uspSiteletDT.Rows[j].Delete(); } } else if (uspSiteletDT.Rows[j]["UserLevel"].ToString() == "D") { if (!(uspSiteletDT.Rows[j]["FromDate"] is DBNull) && !(uspSiteletDT.Rows[j]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) < uspSiteletDT[j].FromDate) || (Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= uspSiteletDT[j].ToDate)) { uspSiteletDT.Rows[j].Delete(); } } else { uspSiteletDT.Rows[j].Delete(); } } } uspSiteletDT.AcceptChanges(); gvRecipients.DataSource = uspSiteletDT; gvRecipients.DataBind(); //lblStep.Text = "==>" + uspSiteletDT.Rows.Count; lblRecipientNumber.Text = "There are " + uspSiteletDT.Rows.Count + " recipients."; //Session["by"] = "sitelet" + ddlSitelet.SelectedValue; Session["uspSiteLetDT"] = uspSiteletDT; //} } else if (ddlRequesters.SelectedValue != "0") { //if ((Session["by"] == null) || (Session["by"].ToString() != "requester" + ddlRequesters.SelectedValue)) //{ uspRequesterTA = new dsUserTableAdapters.uspLicenseesByRequesterIDTableAdapter(); uspRequesterDT = new dsUser.uspLicenseesByRequesterIDDataTable(); uspRequesterDT = uspRequesterTA.GetLicenseesByRequesterID(Convert.ToInt32(ddlRequesters.SelectedValue)); for (int j = 0; j < uspRequesterDT.Rows.Count; j++) { if (uspRequesterDT.Rows[j]["UserLevel"].ToString() == "C") { if (!(uspRequesterDT.Rows[j]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) > uspRequesterDT[j].AllowedYear) { uspRequesterDT.Rows[j].Delete(); } } else { uspRequesterDT.Rows[j].Delete(); } } else if (uspRequesterDT.Rows[j]["UserLevel"].ToString() == "D") { if (!(uspRequesterDT.Rows[j]["FromDate"] is DBNull) && !(uspRequesterDT.Rows[j]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) < uspRequesterDT[j].FromDate) || (Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= uspRequesterDT[j].ToDate)) { uspRequesterDT.Rows[j].Delete(); } } else { uspRequesterDT.Rows[j].Delete(); } } } uspRequesterDT.AcceptChanges(); gvRecipients.DataSource = uspRequesterDT; gvRecipients.DataBind(); //lblStep.Text = "==>" + uspSiteletDT.Rows.Count; lblRecipientNumber.Text = "There are " + uspRequesterDT.Rows.Count + " recipients."; //Session["by"] = "requester" + ddlRequesters.SelectedValue; Session["uspRequesterDT"] = uspRequesterDT; // } } else if (ddlUserLevel.SelectedValue != "0") { // if ((Session["by"] == null) || (Session["by"].ToString() != "userlevel" + ddlRequesters.SelectedValue)) // { uspUserLevelTA = new dsUserTableAdapters.uspLicenseesByUserLevelTableAdapter(); uspUserLevelDT = new dsUser.uspLicenseesByUserLevelDataTable(); uspUserLevelDT = uspUserLevelTA.GetLicenseesByUserLevel(ddlUserLevel.SelectedValue); for (int j = 0; j < uspUserLevelDT.Rows.Count; j++) { if (uspUserLevelDT.Rows[j]["UserLevel"].ToString() == "C") { if (!(uspUserLevelDT.Rows[j]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) > uspUserLevelDT[j].AllowedYear) { uspUserLevelDT.Rows[j].Delete(); } } else { uspUserLevelDT.Rows[j].Delete(); } } else if (uspUserLevelDT.Rows[j]["UserLevel"].ToString() == "D") { if (!(uspUserLevelDT.Rows[j]["FromDate"] is DBNull) && !(uspUserLevelDT.Rows[j]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) < uspUserLevelDT[j].FromDate) || (Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= uspUserLevelDT[j].ToDate)) { uspUserLevelDT.Rows[j].Delete(); } } else { uspUserLevelDT.Rows[j].Delete(); } } } uspUserLevelDT.AcceptChanges(); gvRecipients.DataSource = uspUserLevelDT; gvRecipients.DataBind(); //lblStep.Text = "==>" + uspSiteletDT.Rows.Count; lblRecipientNumber.Text = "There are " + uspUserLevelDT.Rows.Count + " recipients."; //Session["by"] = "userlevel" + ddlUserLevel.SelectedValue; Session["uspUserLevelDT"] = uspUserLevelDT; //} } else if (ddlCategory.SelectedValue != "0") { //if ((Session["by"] == null) || (Session["by"].ToString() != "usercategory" + ddlRequesters.SelectedValue)) //{ uspUserCategoryTA = new dsUserTableAdapters.uspLicenseesByUserCategoryTableAdapter(); uspUserCategoryDT = new dsUser.uspLicenseesByUserCategoryDataTable(); uspUserCategoryDT = uspUserCategoryTA.GetLicenseesByUserCategory(ddlCategory.SelectedValue); for (int j = 0; j < uspUserCategoryDT.Rows.Count; j++) { if (uspUserCategoryDT.Rows[j]["UserLevel"].ToString() == "C") { if (!(uspUserCategoryDT.Rows[j]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) > uspUserCategoryDT[j].AllowedYear) { uspUserCategoryDT.Rows[j].Delete(); } } else { uspUserCategoryDT.Rows[j].Delete(); } } else if (uspUserCategoryDT.Rows[j]["UserLevel"].ToString() == "D") { if (!(uspUserCategoryDT.Rows[j]["FromDate"] is DBNull) && !(uspUserCategoryDT.Rows[j]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) < uspUserCategoryDT[j].FromDate) || (Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= uspUserCategoryDT[j].ToDate)) { uspUserCategoryDT.Rows[j].Delete(); } } else { uspUserCategoryDT.Rows[j].Delete(); } } } uspUserCategoryDT.AcceptChanges(); gvRecipients.DataSource = uspUserCategoryDT; gvRecipients.DataBind(); //lblStep.Text = "==>" + uspSiteletDT.Rows.Count; lblRecipientNumber.Text = "There are " + uspUserCategoryDT.Rows.Count + " recipients."; //Session["by"] = "usercategory" + ddlCategory.SelectedValue; Session["uspUserCategoryDT"] = uspUserCategoryDT; // } } } /* * if (Request.QueryString["step"] != null) * { * if (Request.QueryString["step"].ToString() == "2")//Back button pressed from step 3 * { * lblStep.Text = "Step 2 of 4:"; * lblDescription.Text = "Verify the recipients"; * tableProfile.Visible = false; * tableUserLevel.Visible = true; * * if ((Session["uspSiteLetDT"] != null)&&(Session["SelectedValue"] != null)) * { * ddlSitelet.SelectedValue = Session["SelectedValue"].ToString(); * uspSiteletDT = (dsUser.uspLicenseesBySiteletIDDataTable)Session["uspSiteLetDT"]; * gvRecipients.DataSource = uspSiteletDT; * gvRecipients.DataBind(); * lblRecipientNumber.Text = "There are " + uspSiteletDT.Rows.Count + " recipients."; * } * else if ((Session["uspRequesterDT"] != null) &&(Session["SelectedValue"] != null)) * { * ddlRequesters.SelectedValue = Session["SelectedValue"].ToString(); * uspRequesterDT = (dsUser.uspLicenseesByRequesterIDDataTable)Session["uspRequesterDT"]; * gvRecipients.DataSource = uspRequesterDT; * gvRecipients.DataBind(); * lblRecipientNumber.Text = "There are " + uspRequesterDT.Rows.Count + " recipients."; * } * else if ((Session["uspUserLevelDT"] != null)&&(Session["SelectedValue"] != null)) * { * ddlUserLevel.SelectedValue = Session["SelectedValue"].ToString(); * uspUserLevelDT = (dsUser.uspLicenseesByUserLevelDataTable)Session["uspUserLevelDT"]; * gvRecipients.DataSource = uspUserLevelDT; * gvRecipients.DataBind(); * lblRecipientNumber.Text = "There are " + uspUserLevelDT.Rows.Count + " recipients."; * } * else if ((Session["uspUserCategoryDT"] != null)&&(Session["SelectedValue"] != null)) * { * ddlCategory.SelectedValue = Session["SelectedValue"].ToString(); * uspUserCategoryDT = (dsUser.uspLicenseesByUserCategoryDataTable)Session["uspUserCategoryDT"]; * gvRecipients.DataSource = uspUserCategoryDT; * gvRecipients.DataBind(); * lblRecipientNumber.Text = "There are " + uspUserCategoryDT.Rows.Count + " recipients."; * } * } * }*/ }