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