protected void ddlRequestor_DataBound(object sender, EventArgs e) { if (Session["licenseeDT"] != null) { licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]); if (licenseeDT.Rows[0]["cid"].ToString() != ddlCompany.SelectedValue)//A different company was selected. Get requestor from the company data { dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(int.Parse(ddlCompany.SelectedValue)); if (!(legacyusersDT.Rows[0]["RequestorID"] is DBNull)) { ddlRequestor.Items.FindByValue(legacyusersDT[0].RequestorID.ToString()).Selected = true; } } else { //Populate the requstor with the session if (!(licenseeDT.Rows[0]["RequestorID"] is DBNull)) { ddlRequestor.Items.FindByValue(licenseeDT[0].RequestorID.ToString()).Selected = true; } } } ddlRequestor.Items.FindByValue("0").Text = "Select One"; }
protected void btnBack4_Click(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); //if (legacyusersDT[0].UserLevel == "A") //{ // bodyID.Attributes.Add("onload", "ShowHideModifyAll2();ChangeStep();"); // rblUserCategory.Attributes.Add("onclick", "ShowHideModifyAll2();ChangeStep()"); // lblStep.Text = "Step 3 of 4:"; //rblModifyAll2.Visible = false; //} //else //{ bodyID.Attributes.Add("onload", ""); rblUserCategory.Attributes.Add("onclick", ""); lblStep.Text = "Step 3 of 5:"; //} } else { Response.Redirect("./"); } lblDescription.Text = "Choose a user category"; tableUserCategory.Visible = true; tableRequestor.Visible = false; }
protected void btnYes_Click(object sender, EventArgs e) { dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(Convert.ToInt32(Request.QueryString["id"].ToString())); legacyusersDT.Rows[0].Delete(); legacyusersTA.Update(legacyusersDT); //Changed to delete all users by default 041909 //if (rblModifyAll.SelectedIndex == 1)//Delete all users belong to this company //{ dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable(); licenseeDT = licenseeTA.GetUsersByCID(Convert.ToInt32(Request.QueryString["id"].ToString())); for (int i = 0; i < licenseeDT.Rows.Count; i++) { licenseeDT.Rows[i].Delete(); try { AdminActionLogDAL.LogAdminAction(Convert.ToInt32(Session["adminID"].ToString()), 1, licenseeDT.Rows[i]["email"].ToString(), licenseeDT.Rows[i]["firstname"].ToString(), licenseeDT.Rows[i]["lastname"].ToString()); } catch (Exception exc) { } } licenseeTA.Update(licenseeDT); //} lblDescription.Visible = false; tableProfile.Visible = false; tableFinished.Visible = true; }
protected void cvUserName_ServerValidate(object source, ServerValidateEventArgs args) { if (Session["legacyusersDT"] != null) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); if (legacyusersDT[0].UserName != args.Value) { dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDTCheck = new dsCompany.legacyusersDataTable(); legacyusersDTCheck = legacyusersTA.GetCompanyByUserName(args.Value); if (legacyusersDTCheck.Rows.Count > 0) { args.IsValid = false; } else { args.IsValid = true; } } else { args.IsValid = true; } } }
protected void Button1_Click(object sender, EventArgs e) { if (Session["legacyusersR"] != null) { legacyusersTA = (dsCompanyTableAdapters.legacyusersTableAdapter)(Session["legacyusersTA"]); legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); legacyusersR = (dsCompany.legacyusersRow)(Session["legacyusersR"]); //dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); //int iPkey = Convert.ToInt32(legacyusersTA.InsertQuery(legacyusersR.UserName, legacyusersR.Password, legacyusersR.Company, true, true, true, true, true, true, legacyusersR.Email, false, legacyusersR.Contract, legacyusersR.Address1, legacyusersR.Address2, legacyusersR.City, legacyusersR.State, legacyusersR.Zip, legacyusersR.Phone, legacyusersR.Country, true, true, true, true, true, true, true, legacyusersR.UserLevel, legacyusersR.UserCategory, legacyusersR.RequestorID, legacyusersR.FromDate, legacyusersR.ToDate, legacyusersR.AllowedYear)); string strBefore = legacyusersDT.Rows.Count.ToString(); legacyusersDT.AddlegacyusersRow(legacyusersR); legacyusersDT.RowChanged += new DataRowChangeEventHandler(Row_Changed); string strAfter = legacyusersDT.Rows.Count.ToString(); legacyusersTA.Update(legacyusersDT); //int iID = legacyusersDT[0].ID; //string strTest = myTable.Rows.Count.ToString(); lblDescription.Text = "PRIMIRY KEY CREATED ==> " + iPkey; } //legacyusersDT.AddlegacyusersRow(legacyusersR); }
protected void btnContinue3_Click(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { if (Page.IsValid) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); legacyusersDT[0].UserCategory = rblUserCategory.SelectedValue; //if (legacyusersDT[0].UserLevel == "A") //{ // Session["legacyusersDT"] = legacyusersDT; // lblStep.Text = "Step 4 of 4:"; // lblDescription.Text = "Choose a MLB Contact"; // tableUserCategory.Visible = false; // tableRequestor.Visible = true; // rblModifyAll3.Visible = true; //} //else //{ lblStep.Text = "Step 4 of 5:"; lblDescription.Text = "Choose a MLB Contact"; tableUserCategory.Visible = false; tableRequestor.Visible = true; Session["legacyusersDT"] = legacyusersDT; //} } } else { Response.Redirect("./"); } }
protected void btnContinue4_Click(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { if (Page.IsValid) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); legacyusersDT[0].RequestorID = Convert.ToInt32(ddlRequestor.SelectedValue.ToString()); //if (legacyusersDT[0].UserLevel == "A") //{ // Session["legacyusersDT"] = legacyusersDT; // SaveLevelA(true); //} //else //{ lblStep.Text = "Step 5 of 5:"; lblDescription.Text = "Give permissions to '" + legacyusersDT[0].Company + "' to access the following sitelet(s)"; tableRequestor.Visible = false; tablesitlet.Visible = true; Session["legacyusersDT"] = legacyusersDT; //} } } else { Response.Redirect("./"); } }
protected void btnBack5_Click(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); //Never reaching code //if (legacyusersDT[0].UserLevel == "A") //{ // lblStep.Text = "Step 3 of 4:"; // lblDescription.Text = "Choose a user category"; // tableUserCategory.Visible = true; // tablesitlet.Visible = false; //} //else //{ lblStep.Text = "Step 4 of 5:"; lblDescription.Text = "Choose a MLB Contact"; tableRequestor.Visible = true; tablesitlet.Visible = false; //} } else { Response.Redirect("./"); } }
protected void cvUserName_ServerValidate(object source, ServerValidateEventArgs args) { dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByUserName(args.Value); if (legacyusersDT.Rows.Count > 0) { args.IsValid = false; } else { args.IsValid = true; } }
protected void ddlRequestor_DataBound(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); //Populate the requstor with the session try { if (!(legacyusersDT[0].RequestorID is DBNull)) { ddlRequestor.Items.FindByValue(legacyusersDT[0].RequestorID.ToString()).Selected = true; } } catch (Exception ex) { } } ddlRequestor.Items.FindByValue("0").Text = "Select One"; }
protected void cblSitelet_DataBound(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter(); dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable(); legacyusers2siteletsDT = legacyusers2siteletsTA.Getc2sByCID(legacyusersDT[0].ID); for (int i = 0; i < legacyusers2siteletsDT.Rows.Count; i++) { foreach (ListItem li in cblSitelet.Items) { if (li.Value == legacyusers2siteletsDT[i].sid.ToString()) { li.Selected = true; } } } } }
protected void btnBack2_Click(object sender, EventArgs e) { lblStep.Text = "Step 1 of 5:"; lblDescription.Text = "Enter The Company Information"; tableProfile.Visible = true; cvMessage.Enabled = true; tableUserLevel.Visible = false; ltrBack.Text = "<input type=\"button\" name=\"btnBack\" value=\"<<< Go Back\" onclick=\"window.location.replace('./CompanyMgr.aspx')\"/>"; if (Session["legacyusersDT"] == null)//At first arrival, create the session as needed. { legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(Convert.ToInt32(Request.QueryString["id"].ToString())); Session["legacyusersDT"] = legacyusersDT; } else { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); } //Populate the existing data if (!(legacyusersDT.Rows[0]["Company"] is DBNull)) { tbCompany.Text = legacyusersDT[0].Company; } if (!(legacyusersDT.Rows[0]["Address1"] is DBNull)) { tbAddress1.Text = legacyusersDT[0].Address1; } if (!(legacyusersDT.Rows[0]["Address2"] is DBNull)) { tbAddress2.Text = legacyusersDT[0].Address2; } if (!(legacyusersDT.Rows[0]["City"] is DBNull)) { tbCity.Text = legacyusersDT[0].City; } if (!(legacyusersDT.Rows[0]["State"] is DBNull)) { bool bProvince = true; foreach (ListItem l in ddlState.Items) { if (legacyusersDT[0].State == l.Value) { l.Selected = true; bProvince = false; } } if (bProvince) { tbProvince.Text = legacyusersDT[0].State; } } if (!(legacyusersDT.Rows[0]["Zip"] is DBNull)) { tbZip.Text = legacyusersDT[0].Zip; } if (!(legacyusersDT.Rows[0]["Phone"] is DBNull)) { tbPhone.Text = legacyusersDT[0].Phone; } if (!(legacyusersDT.Rows[0]["Contract"] is DBNull)) { tbContract.Text = legacyusersDT[0].Contract; } if (!(legacyusersDT.Rows[0]["UserName"] is DBNull)) { tbUserName.Text = legacyusersDT[0].UserName; } if (!(legacyusersDT.Rows[0]["Password"] is DBNull)) { tbPassword.Text = legacyusersDT[0].Password; } }
protected void btnContinue5_Click(object sender, EventArgs e) { if (Page.IsValid) { if ((Session["legacyusersTA"] != null) && (Session["legacyusersDT"] != null) && (Session["legacyusersR"] != null)) { legacyusersTA = (dsCompanyTableAdapters.legacyusersTableAdapter)(Session["legacyusersTA"]); legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); legacyusersR = (dsCompany.legacyusersRow)(Session["legacyusersR"]); //dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); //int iPkey = Convert.ToInt32(legacyusersTA.InsertQuery(legacyusersR.UserName, legacyusersR.Password, legacyusersR.Company, true, true, true, true, true, true, legacyusersR.Email, false, legacyusersR.Contract, legacyusersR.Address1, legacyusersR.Address2, legacyusersR.City, legacyusersR.State, legacyusersR.Zip, legacyusersR.Phone, legacyusersR.Country, true, true, true, true, true, true, true, legacyusersR.UserLevel, legacyusersR.UserCategory, legacyusersR.RequestorID, legacyusersR.FromDate, legacyusersR.ToDate, legacyusersR.AllowedYear)); //string strBefore = legacyusersDT.Rows.Count.ToString(); legacyusersR.RegistrationDate = DateTime.Now; legacyusersDT.AddlegacyusersRow(legacyusersR); legacyusersDT.RowChanged += new DataRowChangeEventHandler(Row_Changed); //string strAfter = legacyusersDT.Rows.Count.ToString(); legacyusersTA.Update(legacyusersDT); //Let's add sitelets dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter(); dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable(); legacyusers2siteletsDT = legacyusers2siteletsTA.GetAllc2s(); foreach (ListItem li in cblSitelet.Items) { if (li.Selected) { dsCompany.legacyusers2siteletsRow legacyusers2siteletsR = legacyusers2siteletsDT.Newlegacyusers2siteletsRow(); legacyusers2siteletsR.cid = iPkey; legacyusers2siteletsR.sid = Convert.ToInt32(li.Value); legacyusers2siteletsDT.Addlegacyusers2siteletsRow(legacyusers2siteletsR); legacyusers2siteletsTA.Update(legacyusers2siteletsDT); } } //Send a confirmation email /* * Axis360Mail myMail = new Axis360Mail(); * myMail.FromEmail = "*****@*****.**"; * myMail.FromName = "Major League Baseball Properties"; * myMail.IsBodyHtml = true; * myMail.Subject = "Welcome to the MLB Styleguide!"; * myMail.ToEmail1 = legacyusersR.Email; * myMail.ToName1 = legacyusersR.Company; * * myMail.Message = "Hello " + legacyusersR.Company + " user<br><br>" + * "Thank you for registering at www.mlbstyleguide.com.<br><br>" + * "Your temporary login information is shown below:<br><br>" + * "User name: " + legacyusersR.UserName + "<br>" + * "Password: "******"<br><br>" + * "You can login with this information at <a href=\"http://" + Request.ServerVariables["SERVER_NAME"].ToString() + "\">" + * "http://" + Request.ServerVariables["SERVER_NAME"].ToString() + "</a>.<br>" + * "Once you log in you will be asked to complete a short form and create your own unique password.<br>" + * "Future access to the site will then be done by simply entering your e-mail address and desired password.<br><br>" + * "If you have any questions or need any other assistance, please contact us at <a href=\"mailto:[email protected]\">[email protected]</a>.<br><br>" + * "Thank you,<br><br>" + * "Major League Baseball Properties"; * myMail.Send(); * / * * /* * if ((legacyusersR["FromDate"] is DBNull) || (legacyusersR["ToDate"] is DBNull)) * { * //Response.Redirect("http://google.com"); * //legacyusersR.FromDate = null; * //legacyusersR.ToDate = null; * * } * * if (legacyusersR["AllowedYear"] is DBNull) * { * //legacyusersR.AllowedYear = null; * } * * dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); * int iPkey = Convert.ToInt32(legacyusersTA.InsertQuery(legacyusersR.UserName, legacyusersR.Password, legacyusersR.Company, true, true, true, true, true, true, legacyusersR.Email, false, legacyusersR.Contract, legacyusersR.Address1, legacyusersR.Address2, legacyusersR.City, legacyusersR.State, legacyusersR.Zip, legacyusersR.Phone, legacyusersR.Country, true, true, true, true, true, true, true, legacyusersR.UserLevel, legacyusersR.UserCategory, legacyusersR.RequestorID, legacyusersR.FromDate, legacyusersR.ToDate, legacyusersR.AllowedYear)); */ //lblDescription.Text = "PRIMIRY KEY CREATED ==> " + iPkey; ltrAddUsers.Text = "Now you can <a href=\"CompanyMgr.aspx?prefix=" + legacyusersR.Company.Substring(0, 1) + "\">add a user</a>.<br />"; } else { Response.Redirect("./"); } lblStep.Visible = false; lblDescription.Visible = false; tablesitlet.Visible = false; tableFinished.Visible = true; } /* * foreach (ListItem li in cblS7.Items) * { * if (li.Selected) * { * PRegSurveyTA.InsertQuery(iPkey, 7, Convert.ToInt32(li.Value)); * } * }*/ }
protected void btnContinue1_Click(object sender, EventArgs e) { if (Page.IsValid) { legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); legacyusersDT = legacyusersTA.GetAllCompanies(); legacyusersR = legacyusersDT.NewlegacyusersRow(); legacyusersR.Company = tbCompany.Text; legacyusersR.Address1 = tbAddress1.Text; legacyusersR.Address2 = tbAddress2.Text; legacyusersR.City = tbCity.Text; if (ddlState.SelectedIndex > 0) { legacyusersR.State = ddlState.SelectedValue; } else { legacyusersR.State = tbProvince.Text; } legacyusersR.Zip = tbZip.Text; legacyusersR.Country = ddlCountry.SelectedValue; legacyusersR.Phone = tbPhone.Text; //legacyusersR.Email = tbEmail.Text; legacyusersR.Contract = tbContract.Text; string companyNoSpace = tbCompany.Text.ToLower().Replace(" ", ""); if (companyNoSpace.Length >= 5) { legacyusersR.UserName = companyNoSpace.Substring(0, 5) + "_register"; } else { legacyusersR.UserName = companyNoSpace + "_register"; } legacyusersR.Password = RandomPassword.Generate(7); //legacyusersR.UserName = tbUserName.Text; //legacyusersR.Password = tbPassword.Text; legacyusersR.Mlb = false; legacyusersR.Minor = false; legacyusersR.Coop = false; legacyusersR.Alls = false; legacyusersR.World = false; legacyusersR.Mascot = false; legacyusersR.Spring = false; legacyusersR.Trend = false; legacyusersR.Minorleaguestyleguide = false; legacyusersR.Super = false; legacyusersR.Mlb2003 = false; legacyusersR.Creative = false; legacyusersR.Alls2007 = false; legacyusersR.BulkReg = false; Session["legacyusersTA"] = legacyusersTA; Session["legacyusersDT"] = legacyusersDT; Session["legacyusersR"] = legacyusersR; lblStep.Text = "Step 2 of 5:"; lblDescription.Text = "Choose a user level"; tableProfile.Visible = false; cvMessage.Enabled = false; tableUserLevel.Visible = true; } }
protected void btnContinue5_Click(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { if (Page.IsValid) { legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); //legacyusersDT[0].RegistrationDate = DateTime.Now; //Let's update sitelets dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter(); //Delete the existing one first! legacyusers2siteletsTA.DeleteQuery(legacyusersDT[0].ID); dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable(); legacyusers2siteletsDT = legacyusers2siteletsTA.GetAllc2s(); foreach (ListItem li in cblSitelet.Items) { if (li.Selected) { dsCompany.legacyusers2siteletsRow legacyusers2siteletsR = legacyusers2siteletsDT.Newlegacyusers2siteletsRow(); legacyusers2siteletsR.cid = legacyusersDT[0].ID; legacyusers2siteletsR.sid = Convert.ToInt32(li.Value); legacyusers2siteletsDT.Addlegacyusers2siteletsRow(legacyusers2siteletsR); legacyusers2siteletsTA.Update(legacyusers2siteletsDT); } } legacyusersTA.Update(legacyusersDT); //Default to always modify all users 041909 //if (rblModifyAll.SelectedIndex == 1)//Modify all users belong to this company //{ //Response.Redirect("http://google.com"); dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable(); dsUserTableAdapters.licensee2siteletsTableAdapter licensee2siteletsTA = new dsUserTableAdapters.licensee2siteletsTableAdapter(); dsUser.licensee2siteletsDataTable licensee2sitletsDT = new dsUser.licensee2siteletsDataTable(); licenseeDT = licenseeTA.GetUsersByCID(legacyusersDT[0].ID); for (int i = 0; i < licenseeDT.Rows.Count; i++) { licenseeDT[i].UserLevel = legacyusersDT[0].UserLevel; if (legacyusersDT[0].UserLevel == "D") { licenseeDT[i].FromDate = legacyusersDT[0].FromDate; licenseeDT[i].ToDate = legacyusersDT[0].ToDate; } else { licenseeDT.Rows[i]["FromDate"] = DBNull.Value; licenseeDT.Rows[i]["ToDate"] = DBNull.Value; } if (legacyusersDT[0].UserLevel == "C") { licenseeDT[i].AllowedYear = legacyusersDT[0].AllowedYear; } else { licenseeDT.Rows[i]["AllowedYear"] = DBNull.Value; } licenseeDT[i].UserCategory = legacyusersDT[0].UserCategory; licenseeDT[i].RequestorID = legacyusersDT[0].RequestorID; licensee2siteletsTA.DeleteByUID(licenseeDT[i].ID); licensee2sitletsDT = licensee2siteletsTA.GetAllu2s(); foreach (ListItem li in cblSitelet.Items) { if (li.Selected) { dsUser.licensee2siteletsRow licensee2siteletsR = licensee2sitletsDT.Newlicensee2siteletsRow(); licensee2siteletsR.uid = licenseeDT[i].ID; licensee2siteletsR.sid = Convert.ToInt32(li.Value); licensee2sitletsDT.Addlicensee2siteletsRow(licensee2siteletsR); licensee2siteletsTA.Update(licensee2sitletsDT); } } licenseeTA.Update(licenseeDT); } //} lblStep.Visible = false; lblDescription.Visible = false; tablesitlet.Visible = false; tableFinished.Visible = true; } } else { Response.Redirect("./"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null)//Protection required ALL edits! { if (!Page.IsPostBack) { try{ legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(Convert.ToInt32(Request.QueryString["id"].ToString())); Session["legacyusersDT"] = legacyusersDT; //Populate the existing data if (!(legacyusersDT.Rows[0]["Company"] is DBNull)) { lblCompany.Text = legacyusersDT[0].Company; } if (!(legacyusersDT.Rows[0]["Address1"] is DBNull)) { lblAddress1.Text = legacyusersDT[0].Address1; } if (!(legacyusersDT.Rows[0]["Address2"] is DBNull)) { lblAddress2.Text = legacyusersDT[0].Address2; } if (!(legacyusersDT.Rows[0]["City"] is DBNull)) { lblCity.Text = legacyusersDT[0].City; } if (!(legacyusersDT.Rows[0]["State"] is DBNull)) { lblState.Text = legacyusersDT[0].State; } if (!(legacyusersDT.Rows[0]["Zip"] is DBNull)) { lblZip.Text = legacyusersDT[0].Zip; } if (!(legacyusersDT.Rows[0]["Country"] is DBNull)) { lblCountry.Text = legacyusersDT[0].Country; } if (!(legacyusersDT.Rows[0]["Phone"] is DBNull)) { lblPhone.Text = legacyusersDT[0].Phone; } if (!(legacyusersDT.Rows[0]["Email"] is DBNull)) { lblEmail.Text = legacyusersDT[0].Email; } if (!(legacyusersDT.Rows[0]["Contract"] is DBNull)) { lblContract.Text = legacyusersDT[0].Contract; } if (!(legacyusersDT.Rows[0]["UserName"] is DBNull)) { lblUserName.Text = legacyusersDT[0].UserName; } if (!(legacyusersDT.Rows[0]["Password"] is DBNull)) { lblPassword.Text = legacyusersDT[0].Password; } if (!(legacyusersDT.Rows[0]["UserLevel"] is DBNull)) { lblUserLevel.Text = legacyusersDT[0].UserLevel; if (legacyusersDT[0].UserLevel == "D" && (!(legacyusersDT.Rows[0]["FromDate"] is DBNull)) && (!(legacyusersDT.Rows[0]["ToDate"] is DBNull)))//When Level D enforce the required field validator to the date range { lblDateRange.Text = "(" + legacyusersDT[0].FromDate.ToShortDateString() + " ~ " + legacyusersDT[0].ToDate.ToShortDateString() + ")"; } } if (!(legacyusersDT.Rows[0]["UserCategory"] is DBNull)) { lblUserCategory.Text = legacyusersDT[0].UserCategory; } if (!(legacyusersDT.Rows[0]["RequestorID"] is DBNull)) { dsCompanyTableAdapters.requestorsTableAdapter requestorsTA = new dsCompanyTableAdapters.requestorsTableAdapter(); dsCompany.requestorsDataTable requestorsDT = new dsCompany.requestorsDataTable(); requestorsDT = requestorsTA.GetRequestorByID(legacyusersDT[0].RequestorID); if (requestorsDT.Rows.Count > 0) { lblRequestor.Text = requestorsDT[0].name; } } dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter(); dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable(); legacyusers2siteletsDT = legacyusers2siteletsTA.Getc2sByCID(legacyusersDT[0].ID); dsCompanyTableAdapters.siteletsTableAdapter siteletsTA = new dsCompanyTableAdapters.siteletsTableAdapter(); dsCompany.siteletsDataTable siteletsDT = new dsCompany.siteletsDataTable(); siteletsDT = siteletsTA.GetAllSitelets(); string strSitelets = string.Empty; for (int i = 0; i < legacyusers2siteletsDT.Rows.Count; i++) { for (int j = 0; j < siteletsDT.Rows.Count; j++) { if (siteletsDT[j].id == legacyusers2siteletsDT[i].sid) { strSitelets += siteletsDT[j].description + "<br>"; } } } lblSitelets.Text = strSitelets; } catch (Exception ex) { HttpBrowserCapabilities br = Request.Browser; string strHandledMessage = "ex.StackTrace: " + ex.StackTrace.ToString() + Environment.NewLine + Environment.NewLine + "The client ip: " + Request.ServerVariables["REMOTE_ADDR"] + Environment.NewLine + Environment.NewLine + "GetLastError.Message: " + ex.Message.ToString() + Environment.NewLine + Environment.NewLine + "Page: " + Request.ServerVariables["SCRIPT_NAME"] + Environment.NewLine + Environment.NewLine + "Server: " + Request.ServerVariables["SERVER_NAME"] + Environment.NewLine + Environment.NewLine + "Local Address: " + Request.ServerVariables["LOCAL_ADDR"] + Environment.NewLine + Environment.NewLine + "Browser: " + br.Browser.ToString() + " : " + br.Version.ToString(); if (Request.UrlReferrer != null) { strHandledMessage += Environment.NewLine + Environment.NewLine + "Referrer: " + Request.UrlReferrer.ToString(); } if (Request.QueryString != null) { strHandledMessage += Environment.NewLine + Environment.NewLine + "Query String: " + Request.QueryString.ToString(); } strHandledMessage += Environment.NewLine + Environment.NewLine; System.Net.Mail.SmtpClient smtpClient = new System.Net.Mail.SmtpClient(); System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage(); try { System.Net.Mail.MailAddress fromAddress = new System.Net.Mail.MailAddress("*****@*****.**", "Debugger"); smtpClient.Host = System.Configuration.ConfigurationManager.AppSettings["SMTPServer"].ToString(); smtpClient.Port = 25; message.From = fromAddress; message.To.Add("*****@*****.**"); message.Subject = "MLBStyleGuide : Error on " + Request.ServerVariables["SCRIPT_NAME"] + ".. but handled"; //message.Body = Server.GetLastError().InnerException.Message.ToString(); message.Body = strHandledMessage; smtpClient.Send(message); } catch (Exception e2) { //lblStatus.Text = "Send Email Failed." + ex.Message; } } } } else//Take care of the deviants { Response.Redirect("./"); } }
public string ContactTheUser(string email, string cID) { //return email + ":::::::" + cID; dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable(); dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(Convert.ToInt32(cID)); StringBuilder sbMsg = new StringBuilder(); //StringBuilder sbMsgPop = new StringBuilder(); string msgPop = string.Empty; sbMsg.Append("<img src=\"cid:Pic1\"><br>"); sbMsg.Append("Welcome " + legacyusersDT.Rows[0]["Company"].ToString() + ",<br><br>"); sbMsg.Append("Thank you for registering at www.mlbstyleguide.com.<br><br>"); sbMsg.Append("Your temporary login information is shown below:<br><br>"); sbMsg.Append("User name: " + legacyusersDT.Rows[0]["UserName"].ToString() + "<br>"); sbMsg.Append("Password: "******"Password"].ToString() + "<br><br>"); msgPop = "User name: " + legacyusersDT.Rows[0]["UserName"].ToString() + "<br>" + "Password: "******"Password"].ToString() + "<br><br>" + "https://www.mlbstyleguide.com/go.asp?ce=" + EncodeTo64(email); sbMsg.Append("You can login with this information by clicking <a href=\"" + "https://www.mlbstyleguide.com/go.asp?ce=" + EncodeTo64(email) + "\" style=\"color:#FF0000\"><b>here</b></a>. Once you log in you will be asked to complete a short form and create your own unique password. Future access to the site will then be done by simply entering your e-mail address and desired password.<br><br>"); sbMsg.Append("If you have any questions or need any other assistance, please contact us at [email protected].<br><br>"); sbMsg.Append("<br>Thank you,<br><br>Major League Baseball Properties"); AlternateView avHthml = AlternateView.CreateAlternateViewFromString(sbMsg.ToString(), null, MediaTypeNames.Text.Html); LinkedResource pic1 = new LinkedResource(Server.MapPath("emailbanner.jpg"), MediaTypeNames.Image.Jpeg); pic1.ContentId = "Pic1"; avHthml.LinkedResources.Add(pic1); string _FromName = "Major League Baseball"; string _FromEmail = "*****@*****.**"; string strSubject = "MLB Style Guide Registration"; SmtpClient smtpClient; MailMessage message; try { smtpClient = new SmtpClient(); smtpClient.Host = ConfigurationManager.AppSettings["SMTPServer"].ToString(); smtpClient.Port = 25; message = new MailMessage(); MailAddress fromAddress = new MailAddress(_FromEmail, _FromName); message.From = fromAddress; MailAddress toAddress = new MailAddress(email); message.To.Clear(); message.To.Add(toAddress); message.Subject = strSubject; message.IsBodyHtml = true; //message.Body = sbMsg.ToString(); message.AlternateViews.Add(avHthml); smtpClient.Send(message); } catch (Exception ex) { //throw ex; //iBadEmails++; //sbBadEmailList.Append("<a href=\"EditUser.aspx?id=" + strID + "\" target=\"_blank\">" + strRecepient + "</a><br/>"); } return(msgPop); }
protected void btnContinue2_Click(object sender, EventArgs e) { if (Session["legacyusersDT"] != null) { if (Page.IsValid) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); legacyusersDT[0].UserLevel = rblUserLevel.SelectedValue; //Once "No access this time" is selected, finish it 041909 if (rblUserLevel.SelectedValue == "X") { //Block all users 041909 dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable(); licenseeDT = licenseeTA.GetUsersByCID(legacyusersDT[0].ID); for (int i = 0; i < licenseeDT.Rows.Count; i++) { licenseeDT[i].UserLevel = legacyusersDT[0].UserLevel; licenseeTA.Update(licenseeDT); } legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); legacyusersTA.Update(legacyusersDT); //Terminate update tableUserLevel.Visible = false; tableFinished.Visible = true; lblStep.Visible = false; lblDescription.Visible = false; } else { if (rblUserLevel.SelectedValue == "D") { legacyusersDT[0].FromDate = Convert.ToDateTime(calendarPopupFrom.SelectedDate.ToString()); legacyusersDT[0].ToDate = Convert.ToDateTime(calendarPopupTo.SelectedDate.ToString()); } else if (rblUserLevel.SelectedValue == "C") { legacyusersDT[0].AllowedYear = Convert.ToDateTime("12/31/" + DateTime.Now.Year); legacyusersDT.Rows[0]["FromDate"] = DBNull.Value; legacyusersDT.Rows[0]["ToDate"] = DBNull.Value; } else { legacyusersDT.Rows[0]["FromDate"] = DBNull.Value; legacyusersDT.Rows[0]["ToDate"] = DBNull.Value; legacyusersDT.Rows[0]["AllowedYear"] = DBNull.Value; } //Populate the user category with the session if (!(legacyusersDT.Rows[0]["UserCategory"] is DBNull)) { rblUserCategory.Items.FindByValue(legacyusersDT[0].UserCategory).Selected = true; } //if (legacyusersDT[0].UserLevel == "A") //{ // lblStep.Text = "Step 3 of 4:"; // rblModifyAll2.Visible = false; // rblModifyAll3.Visible = false; // bodyID.Attributes.Add("onload", "ShowHideModifyAll2();ChangeStep();"); // rblUserCategory.Attributes.Add("onclick", "ShowHideModifyAll2();ChangeStep()"); //} //else //{ //rblModifyAll2.Visible = false; //rblModifyAll3.Visible = false; bodyID.Attributes.Add("onload", ""); rblUserCategory.Attributes.Add("onclick", ""); lblStep.Text = "Step 3 of 5:"; //} Session["legacyusersDT"] = legacyusersDT; lblDescription.Text = "Choose a user category"; tableUserLevel.Visible = false; tableUserCategory.Visible = true; //Let's populate the existing data //Button1.Text = "Ready to SAVE!!!!"; //Response.Redirect("http://google.com"); } } } else { Response.Redirect("./"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null)//Protection required ALL edits! { if (!Page.IsPostBack) { licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); licenseeDT = new dsUser.licenseeDataTable(); licenseeDT = licenseeTA.GetUserByID(Convert.ToInt32(Request.QueryString["id"].ToString())); Session["licenseeDT"] = licenseeDT; //Populate the existing data if (!(licenseeDT.Rows[0]["FirstName"] is DBNull)) { lblFirstName.Text = licenseeDT[0].FirstName; } if (!(licenseeDT.Rows[0]["MI"] is DBNull)) { lblMI.Text = licenseeDT[0].MI; } if (!(licenseeDT.Rows[0]["LastName"] is DBNull)) { lblLastName.Text = licenseeDT[0].LastName; } if (!(licenseeDT.Rows[0]["Email"] is DBNull)) { lblEmail.Text = licenseeDT[0].Email; } if (!(licenseeDT.Rows[0]["cid"] is DBNull)) { dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(licenseeDT[0].cid); lblCompany.Text = legacyusersDT[0].Company; } if (!(licenseeDT.Rows[0]["Contract"] is DBNull)) { lblContract.Text = licenseeDT[0].Contract; } if (!(licenseeDT.Rows[0]["Address1"] is DBNull)) { lblAddress1.Text = licenseeDT[0].Address1; } if (!(licenseeDT.Rows[0]["Address2"] is DBNull)) { lblAddress2.Text = licenseeDT[0].Address2; } if (!(licenseeDT.Rows[0]["City"] is DBNull)) { lblCity.Text = licenseeDT[0].City; } if (!(licenseeDT.Rows[0]["State"] is DBNull)) { lblState.Text = licenseeDT[0].State; } if (!(licenseeDT.Rows[0]["Zip"] is DBNull)) { lblZip.Text = licenseeDT[0].Zip; } if (!(licenseeDT.Rows[0]["Phone"] is DBNull)) { lblPhone.Text = licenseeDT[0].Phone; } if (!(licenseeDT.Rows[0]["Fax"] is DBNull)) { lblFax.Text = licenseeDT[0].Fax; } if (!(licenseeDT.Rows[0]["Password"] is DBNull)) { lblPassword.Text = licenseeDT[0].Password; } if (!(licenseeDT.Rows[0]["UserLevel"] is DBNull)) { lblUserLevel.Text = licenseeDT[0].UserLevel; if (licenseeDT[0].UserLevel == "D" && (!(licenseeDT.Rows[0]["FromDate"] is DBNull)) && (!(licenseeDT.Rows[0]["ToDate"] is DBNull)))//When Level D enforce the required field validator to the date range { lblDateRange.Text = "(" + licenseeDT[0].FromDate.ToShortDateString() + " ~ " + licenseeDT[0].ToDate.ToShortDateString() + ")"; } } if (!(licenseeDT.Rows[0]["UserCategory"] is DBNull)) { lblUserCategory.Text = licenseeDT[0].UserCategory; } if (!(licenseeDT.Rows[0]["RequestorID"] is DBNull)) { dsCompanyTableAdapters.requestorsTableAdapter requestorsTA = new dsCompanyTableAdapters.requestorsTableAdapter(); dsCompany.requestorsDataTable requestorsDT = new dsCompany.requestorsDataTable(); requestorsDT = requestorsTA.GetRequestorByID(licenseeDT[0].RequestorID); lblRequestor.Text = requestorsDT[0].name; } //dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter(); dsUserTableAdapters.licensee2siteletsTableAdapter licensee2siteletsTA = new dsUserTableAdapters.licensee2siteletsTableAdapter(); //dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable(); dsUser.licensee2siteletsDataTable licensee2siteletsDT = new dsUser.licensee2siteletsDataTable(); //legacyusers2siteletsDT = legacyusers2siteletsTA.Getc2sByCID(legacyusersDT[0].ID); licensee2siteletsDT = licensee2siteletsTA.Getu2sByUID(licenseeDT[0].ID); dsCompanyTableAdapters.siteletsTableAdapter siteletsTA = new dsCompanyTableAdapters.siteletsTableAdapter(); dsCompany.siteletsDataTable siteletsDT = new dsCompany.siteletsDataTable(); siteletsDT = siteletsTA.GetAllSitelets(); string strSitelets = string.Empty; for (int i = 0; i < licensee2siteletsDT.Rows.Count; i++) { for (int j = 0; j < siteletsDT.Rows.Count; j++) { if (siteletsDT[j].id == licensee2siteletsDT[i].sid) { strSitelets += siteletsDT[j].description + "<br>"; } } } lblSitelets.Text = strSitelets; } } else//Take care of the deviants { Response.Redirect("./"); } }
protected void btnContinue1_Click(object sender, EventArgs e) { if (Session["licenseeDT"] != null)//At first arrival, create the session as needed. { if (Page.IsValid) { licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]); licenseeDT[0].FirstName = tbFirstName.Text; licenseeDT[0].MI = tbMI.Text; licenseeDT[0].LastName = tbLastName.Text; licenseeDT[0].Email = tbEmail.Text; licenseeDT[0].Contract = tbContract.Text; licenseeDT[0].Address1 = tbAddress1.Text; licenseeDT[0].Address2 = tbAddress2.Text; licenseeDT[0].City = tbCity.Text; if (ddlState.SelectedIndex > 0) { licenseeDT[0].State = ddlState.SelectedValue; } else { licenseeDT[0].State = tbProvince.Text; } licenseeDT[0].Zip = tbZip.Text; licenseeDT[0].Country = ddlCountry.SelectedValue; licenseeDT[0].Phone = tbPhone.Text; licenseeDT[0].Fax = tbFax.Text; licenseeDT[0].Password = tbPassword.Text; //Populate the user level using the session if (!(licenseeDT.Rows[0]["UserLevel"] is DBNull)) { var userLevel = ""; dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); try { if (licenseeDT.Rows[0]["cid"].ToString() != ddlCompany.SelectedValue)//A different company was selected. Get requestor from the company data { legacyusersDT = legacyusersTA.GetCompanyByID(int.Parse(ddlCompany.SelectedValue)); if (!(legacyusersDT.Rows[0]["UserLevel"] is DBNull)) { userLevel = legacyusersDT[0].UserLevel; } } else { userLevel = licenseeDT[0].UserLevel; } } catch (Exception ex) {} rblUserLevel.ClearSelection();//Without this can't change it for company dropdown feature coming back from step 2 rblUserLevel.Items.FindByValue(userLevel).Selected = true; if (userLevel == "D")//When Level D enforce the required field validator to the date range { bodyID.Attributes.Add("onload", "document.getElementById(\"dateLayer\").style.visibility=\"visible\";"); if (licenseeDT.Rows[0]["cid"].ToString() != ddlCompany.SelectedValue)//A different company was selected. Get requestor from the company data { if (!(legacyusersDT.Rows[0]["FromDate"] is DBNull) && !(legacyusersDT.Rows[0]["ToDate"] is DBNull)) { calendarPopupFrom.SelectedDate = legacyusersDT[0].FromDate; calendarPopupTo.SelectedDate = legacyusersDT[0].ToDate; } } else { if (!(licenseeDT.Rows[0]["FromDate"] is DBNull) && !(licenseeDT.Rows[0]["ToDate"] is DBNull)) { calendarPopupFrom.SelectedDate = licenseeDT[0].FromDate; calendarPopupTo.SelectedDate = licenseeDT[0].ToDate; } } rfvFrom.Enabled = true; rfvTo.Enabled = true; cvFrom.Enabled = true; cvTo.Enabled = true; cpvDateRange.Enabled = true; Session["DateWasDisplayed"] = "yes"; } else { bodyID.Attributes.Add("onload", "document.getElementById(\"dateLayer\").style.visibility=\"hidden\";"); Session["DateWasDisplayed"] = null; } } Session["licenseeDT"] = licenseeDT; lblStep.Text = "Step 2 of 5:"; lblDescription.Text = "Choose a user level"; tableProfile.Visible = false; cvMessage.Enabled = false; tableUserLevel.Visible = true; } } else { Response.Redirect("./"); } }
protected void SaveLevelA() { if ((Session["legacyusersTA"] != null) && (Session["legacyusersDT"] != null)) { legacyusersTA = (dsCompanyTableAdapters.legacyusersTableAdapter)(Session["legacyusersTA"]); legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); legacyusersR = (dsCompany.legacyusersRow)(Session["legacyusersR"]); //dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); //int iPkey = Convert.ToInt32(legacyusersTA.InsertQuery(legacyusersR.UserName, legacyusersR.Password, legacyusersR.Company, true, true, true, true, true, true, legacyusersR.Email, false, legacyusersR.Contract, legacyusersR.Address1, legacyusersR.Address2, legacyusersR.City, legacyusersR.State, legacyusersR.Zip, legacyusersR.Phone, legacyusersR.Country, true, true, true, true, true, true, true, legacyusersR.UserLevel, legacyusersR.UserCategory, legacyusersR.RequestorID, legacyusersR.FromDate, legacyusersR.ToDate, legacyusersR.AllowedYear)); //string strBefore = legacyusersDT.Rows.Count.ToString(); legacyusersR.RegistrationDate = DateTime.Now; legacyusersDT.AddlegacyusersRow(legacyusersR); legacyusersDT.RowChanged += new DataRowChangeEventHandler(Row_Changed); //string strAfter = legacyusersDT.Rows.Count.ToString(); legacyusersTA.Update(legacyusersDT); //Let's add sitelets //Get all availaible sitelets dsCompanyTableAdapters.siteletsTableAdapter siteletsTA = new dsCompanyTableAdapters.siteletsTableAdapter(); dsCompany.siteletsDataTable siteletsDT = new dsCompany.siteletsDataTable(); siteletsDT = siteletsTA.GetAllSitelets(); dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter(); dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable(); legacyusers2siteletsDT = legacyusers2siteletsTA.GetAllc2s(); for (int i = 0; i < siteletsDT.Rows.Count; i++) { dsCompany.legacyusers2siteletsRow legacyusers2siteletsR = legacyusers2siteletsDT.Newlegacyusers2siteletsRow(); legacyusers2siteletsR.cid = iPkey; legacyusers2siteletsR.sid = Convert.ToInt32(siteletsDT[i].id); legacyusers2siteletsDT.Addlegacyusers2siteletsRow(legacyusers2siteletsR); legacyusers2siteletsTA.Update(legacyusers2siteletsDT); } tableRequestor.Visible = false; tableFinished.Visible = true; lblStep.Visible = false; lblDescription.Visible = false; //Send a confirmation email /* * Axis360Mail myMail = new Axis360Mail(); * myMail.FromEmail = "*****@*****.**"; * myMail.FromName = "Major League Baseball Properties"; * myMail.IsBodyHtml = true; * myMail.Subject = "Welcome to the MLB Styleguide!"; * myMail.ToEmail1 = legacyusersR.Email; * myMail.ToName1 = legacyusersR.Company; * * myMail.Message = "Hello " + legacyusersR.Company + " user<br><br>" + * "Thank you for registering at www.mlbstyleguide.com.<br><br>" + * "Your temporary login information is shown below:<br><br>" + * "User name: " + legacyusersR.UserName + "<br>" + * "Password: "******"<br><br>" + * "You can login with this information at <a href=\"http://" + Request.ServerVariables["SERVER_NAME"].ToString() + "\">" + * "http://" + Request.ServerVariables["SERVER_NAME"].ToString() + "</a>.<br>" + * "Once you log in you will be asked to complete a short form and create your own unique password.<br>" + * "Future access to the site will then be done by simply entering your e-mail address and desired password.<br><br>" + * "If you have any questions or need any other assistance, please contact us at <a href=\"mailto:[email protected]\">[email protected]</a>.<br><br>" + * "Thank you,<br><br>" + * "Major League Baseball Properties"; * myMail.Send(); */ } }
protected void btnContinue2_Click(object sender, EventArgs e) { if (Session["licenseeDT"] != null) { if (Page.IsValid) { licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]); licenseeDT[0].UserLevel = rblUserLevel.SelectedValue; if (rblUserLevel.SelectedValue == "D") { licenseeDT[0].FromDate = Convert.ToDateTime(calendarPopupFrom.SelectedDate.ToString()); licenseeDT[0].ToDate = Convert.ToDateTime(calendarPopupTo.SelectedDate.ToString()); } else if (rblUserLevel.SelectedValue == "C") { licenseeDT[0].AllowedYear = Convert.ToDateTime("12/31/" + DateTime.Now.Year); licenseeDT.Rows[0]["FromDate"] = DBNull.Value; licenseeDT.Rows[0]["ToDate"] = DBNull.Value; } else { licenseeDT.Rows[0]["FromDate"] = DBNull.Value; licenseeDT.Rows[0]["ToDate"] = DBNull.Value; licenseeDT.Rows[0]["AllowedYear"] = DBNull.Value; } if (licenseeDT.Rows[0]["cid"].ToString() != ddlCompany.SelectedValue)//A different company was selected. Get requestor from the company data { dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(int.Parse(ddlCompany.SelectedValue)); if (!(legacyusersDT.Rows[0]["UserCategory"] is DBNull)) { rblUserCategory.ClearSelection(); rblUserCategory.Items.FindByValue(legacyusersDT[0].UserCategory).Selected = true; bodyID.Attributes.Add("onload", ""); rblUserCategory.Attributes.Add("onclick", ""); lblStep.Text = "Step 3 of 5:"; } else { lblStep.Text = "Step 3 of 5:"; } } else { //Populate the user category with the session if (!(licenseeDT.Rows[0]["UserCategory"] is DBNull)) { rblUserCategory.ClearSelection(); rblUserCategory.Items.FindByValue(licenseeDT[0].UserCategory).Selected = true; //Allow sitelet selection to level "A" 091408 //Remove UserLevel Requestor logic 050508 //if (licenseeDT[0].UserLevel == "A") //{ // lblStep.Text = "Step 3 of 4:"; // bodyID.Attributes.Add("onload", "ChangeStep()"); // rblUserCategory.Attributes.Add("onclick", "ChangeStep()"); //} //else //{ bodyID.Attributes.Add("onload", ""); rblUserCategory.Attributes.Add("onclick", ""); lblStep.Text = "Step 3 of 5:"; //} } else { lblStep.Text = "Step 3 of 5:"; } } Session["licenseeDT"] = licenseeDT; lblDescription.Text = "Choose a user category"; tableUserLevel.Visible = false; tableUserCategory.Visible = true; //Let's populate the existing data //Button1.Text = "Ready to SAVE!!!!"; //Response.Redirect("http://google.com"); } } else { Response.Redirect("./"); } }
protected void btnContinue1_Click(object sender, EventArgs e) { if (Session["legacyusersDT"] != null)//At first arrival, create the session as needed. { if (Page.IsValid) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); legacyusersDT[0].Company = tbCompany.Text; legacyusersDT[0].Address1 = tbAddress1.Text; legacyusersDT[0].Address2 = tbAddress2.Text; legacyusersDT[0].City = tbCity.Text; if (ddlState.SelectedIndex > 0) { legacyusersDT[0].State = ddlState.SelectedValue; } else { legacyusersDT[0].State = tbProvince.Text; } legacyusersDT[0].Zip = tbZip.Text; legacyusersDT[0].Country = ddlCountry.SelectedValue; legacyusersDT[0].Phone = tbPhone.Text; legacyusersDT[0].Contract = tbContract.Text; legacyusersDT[0].UserName = tbUserName.Text; legacyusersDT[0].Password = tbPassword.Text; //Populate the user level using the session if (!(legacyusersDT.Rows[0]["UserLevel"] is DBNull)) { rblUserLevel.Items.FindByValue(legacyusersDT[0].UserLevel).Selected = true; if (legacyusersDT[0].UserLevel == "D")//When Level D enforce the required field validator to the date range { bodyID.Attributes.Add("onload", "document.getElementById(\"dateLayer\").style.visibility=\"visible\";"); if (!(legacyusersDT.Rows[0]["FromDate"] is DBNull) && !(legacyusersDT.Rows[0]["ToDate"] is DBNull)) { calendarPopupFrom.SelectedDate = legacyusersDT[0].FromDate; calendarPopupTo.SelectedDate = legacyusersDT[0].ToDate; } rfvFrom.Enabled = true; rfvTo.Enabled = true; cvFrom.Enabled = true; cvTo.Enabled = true; cpvDateRange.Enabled = true; Session["DateWasDisplayed"] = "yes"; } if (legacyusersDT[0].UserLevel == "X") { lblStep.Text = "Step 2 of 2:"; } else { lblStep.Text = "Step 2 of 5:"; } } Session["legacyusersDT"] = legacyusersDT; lblDescription.Text = "Choose a user level"; tableProfile.Visible = false; cvMessage.Enabled = false; tableUserLevel.Visible = true; } } else { Response.Redirect("./"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null)//Protection required ALL edits! { rblUserLevel.Attributes.Add("onclick", "CheckUserLevel()"); if (rblUserLevel.SelectedValue == "D")//When Level D enforce the required field validator to the date range { bodyID.Attributes.Add("onload", "document.getElementById(\"dateLayer\").style.visibility=\"visible\";"); rfvFrom.Enabled = true; rfvTo.Enabled = true; cvFrom.Enabled = true; cvTo.Enabled = true; cpvDateRange.Enabled = true; Session["DateWasDisplayed"] = "yes"; } else if (Session["DateWasDisplayed"] != null)//Choose "D" --> Change it to others --> w/o this code the date range fields are displayed { bodyID.Attributes.Add("onload", "document.getElementById(\"dateLayer\").style.visibility=\"hidden\";"); rfvFrom.Enabled = false; rfvTo.Enabled = false; cvFrom.Enabled = false; cvTo.Enabled = false; cpvDateRange.Enabled = false; Session["DateWasDisplayed"] = null; } if (!Page.IsPostBack) { legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); legacyusersDT = new dsCompany.legacyusersDataTable(); legacyusersDT = legacyusersTA.GetCompanyByID(Convert.ToInt32(Request.QueryString["id"].ToString())); Session["legacyusersDT"] = legacyusersDT; //Populate the existing data if (!(legacyusersDT.Rows[0]["Company"] is DBNull)) { tbCompany.Text = legacyusersDT[0].Company; } if (!(legacyusersDT.Rows[0]["Address1"] is DBNull)) { tbAddress1.Text = legacyusersDT[0].Address1; } if (!(legacyusersDT.Rows[0]["Address2"] is DBNull)) { tbAddress2.Text = legacyusersDT[0].Address2; } if (!(legacyusersDT.Rows[0]["City"] is DBNull)) { tbCity.Text = legacyusersDT[0].City; } if (!(legacyusersDT.Rows[0]["State"] is DBNull)) { bool bProvince = true; foreach (ListItem l in ddlState.Items) { if (legacyusersDT[0].State == l.Value) { l.Selected = true; bProvince = false; } } if (bProvince) { tbProvince.Text = legacyusersDT[0].State; } } if (!(legacyusersDT.Rows[0]["Zip"] is DBNull)) { tbZip.Text = legacyusersDT[0].Zip; } if (!(legacyusersDT.Rows[0]["Phone"] is DBNull)) { tbPhone.Text = legacyusersDT[0].Phone; } if (!(legacyusersDT.Rows[0]["Contract"] is DBNull)) { tbContract.Text = legacyusersDT[0].Contract; } if (!(legacyusersDT.Rows[0]["UserName"] is DBNull)) { tbUserName.Text = legacyusersDT[0].UserName; } if (!(legacyusersDT.Rows[0]["Password"] is DBNull)) { tbPassword.Text = legacyusersDT[0].Password; } } } else//Take care of the deviants { Response.Redirect("./"); } }
protected void SaveLevelA(bool bLicensee) { if (Session["legacyusersDT"] != null) { legacyusersDT = (dsCompany.legacyusersDataTable)(Session["legacyusersDT"]); if (!bLicensee) { legacyusersDT.Rows[0]["RequestorID"] = DBNull.Value; } // legacyusersDT.Rows[0]["FromDate"] = DBNull.Value; legacyusersDT.Rows[0]["ToDate"] = DBNull.Value; legacyusersDT.Rows[0]["AllowedYear"] = DBNull.Value; //lblStep.Text = "Step 4 of 4:"; //lblDescription.Text = "Give permissions to '" + legacyusersDT[0].Company + "' to access the following sitelet(s)"; tableUserCategory.Visible = false; //tablesitlet.Visible = true; //START!!!!!!!!!!! legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); legacyusersTA.Update(legacyusersDT); dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter(); //Delete the existing one first! legacyusers2siteletsTA.DeleteQuery(legacyusersDT[0].ID); dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable(); legacyusers2siteletsDT = legacyusers2siteletsTA.GetAllc2s(); //Get all availaible sitelets dsCompanyTableAdapters.siteletsTableAdapter siteletsTA = new dsCompanyTableAdapters.siteletsTableAdapter(); dsCompany.siteletsDataTable siteletsDT = new dsCompany.siteletsDataTable(); siteletsDT = siteletsTA.GetAllSitelets(); for (int i = 0; i < siteletsDT.Rows.Count; i++) { dsCompany.legacyusers2siteletsRow legacyusers2siteletsR = legacyusers2siteletsDT.Newlegacyusers2siteletsRow(); legacyusers2siteletsR.cid = legacyusersDT[0].ID; legacyusers2siteletsR.sid = Convert.ToInt32(siteletsDT[i].id); legacyusers2siteletsDT.Addlegacyusers2siteletsRow(legacyusers2siteletsR); legacyusers2siteletsTA.Update(legacyusers2siteletsDT); } //Always modify all 041909 //if ((rblModifyAll2.SelectedIndex == 1) || (rblModifyAll3.SelectedIndex == 1))//Modify all users belong to this company //{ //Response.Redirect("http://google.com"); dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter(); dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable(); dsUserTableAdapters.licensee2siteletsTableAdapter licensee2siteletsTA = new dsUserTableAdapters.licensee2siteletsTableAdapter(); dsUser.licensee2siteletsDataTable licensee2sitletsDT = new dsUser.licensee2siteletsDataTable(); licenseeDT = licenseeTA.GetUsersByCID(legacyusersDT[0].ID); for (int i = 0; i < licenseeDT.Rows.Count; i++) { if (legacyusersDT.Rows[0]["RequestorID"] is DBNull) { licenseeDT.Rows[i]["RequestorID"] = DBNull.Value; } else { licenseeDT[i].RequestorID = legacyusersDT[0].RequestorID; } licenseeDT.Rows[i]["FromDate"] = DBNull.Value; licenseeDT.Rows[i]["ToDate"] = DBNull.Value; licenseeDT.Rows[i]["AllowedYear"] = DBNull.Value; licenseeDT[i].UserLevel = legacyusersDT[0].UserLevel; licenseeDT[i].UserCategory = legacyusersDT[0].UserCategory; //Delete user's sitelets first licensee2siteletsTA.DeleteByUID(licenseeDT[i].ID); //Retrive the fresh entire sitlets to add new ones licensee2sitletsDT = licensee2siteletsTA.GetAllu2s(); for (int j = 0; j < siteletsDT.Rows.Count; j++) { dsUser.licensee2siteletsRow licensee2siteletsR = licensee2sitletsDT.Newlicensee2siteletsRow(); licensee2siteletsR.uid = licenseeDT[i].ID; licensee2siteletsR.sid = Convert.ToInt32(siteletsDT[j].id); licensee2sitletsDT.Addlicensee2siteletsRow(licensee2siteletsR); licensee2siteletsTA.Update(licensee2sitletsDT); } licenseeTA.Update(licenseeDT); } //} lblStep.Visible = false; lblDescription.Visible = false; tableRequestor.Visible = false; tableFinished.Visible = true; } else { Response.Redirect("./"); } }
protected void Page_Load(object sender, EventArgs e) { //Literal1.Text = "test"; BuildTheAlphabetNav(); tbSearch.Attributes.Add("onClick", "MakeItBlank()"); //Reset the session variables to make it sense Session["legacyusersDT"] = null; dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter(); dsCompanyTableAdapters.legacyusers4MgrTableAdapter legacyusers4MgrTA = new dsCompanyTableAdapters.legacyusers4MgrTableAdapter(); dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable(); dsCompany.legacyusers4MgrDataTable legacyusers4MgrDT = new dsCompany.legacyusers4MgrDataTable(); if ((!Page.IsPostBack) || (tbSearch.Text == "Company or Username")) { if (Request.QueryString["prefix"] != null) { if (Request.QueryString["prefix"].ToString() == "0") { legacyusers4MgrDT = legacyusers4MgrTA.GetCompaniesStartWithNumber(); } else { legacyusers4MgrDT = legacyusers4MgrTA.GetCompaniesStartWith(Server.UrlDecode(Request.QueryString["prefix"].ToString())); } } else if (Request.QueryString["key"] != null) { legacyusers4MgrDT = legacyusers4MgrTA.GetCompaniesByKeyword(Server.UrlDecode(Request.QueryString["key"].ToString())); } else { legacyusers4MgrDT = legacyusers4MgrTA.GetCompaniesStartWith("A"); } } else { legacyusers4MgrDT = legacyusers4MgrTA.GetCompaniesByKeyword(tbSearch.Text); } for (int i = 0; i < legacyusers4MgrDT.Rows.Count; i++) { if (!(legacyusers4MgrDT.Rows[i]["UserLevel"] is DBNull)) { switch (legacyusers4MgrDT[i].UserLevel) { case "A": legacyusers4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "B": legacyusers4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break; case "C": if (!(legacyusers4MgrDT.Rows[i]["AllowedYear"] is DBNull)) { if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= legacyusers4MgrDT[i].AllowedYear) { legacyusers4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { legacyusers4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { legacyusers4MgrDT[i].Status = "<b>Unknown</b>"; } break; if (!(legacyusers4MgrDT.Rows[i]["FromDate"] is DBNull) && !(legacyusers4MgrDT.Rows[i]["ToDate"] is DBNull)) { if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= legacyusers4MgrDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= legacyusers4MgrDT[i].ToDate)) { legacyusers4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; } else { legacyusers4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>"; } } else { legacyusers4MgrDT[i].Status = "<b>Unknown</b>"; } break; case "X": legacyusers4MgrDT[i].Status = "<b><font color=\"red\">Suspended</font></b>"; break; default: break; } } } gvCompany.DataSource = legacyusers4MgrDT; gvCompany.DataBind(); legacyusers4MgrDT = legacyusers4MgrTA.GetAllCompanies(); lblNum.Text = "Total number of companies: " + legacyusers4MgrDT.Rows.Count; }