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 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 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)); * } * }*/ }