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