protected void btnContinue3_Click(object sender, EventArgs e)
{
if (Session["licenseeDT"] != null)
{
if (Page.IsValid)
{
licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]);
licenseeDT[0].UserCategory = rblUserCategory.SelectedValue;
//Allow sitelet selection to level "A" 091408
//Remove UserLevel Requestor logic 050508
//if (licenseeDT[0].UserLevel == "A")
//{
// lblStep.Text = "Step 4 of 4:";
// lblDescription.Text = "Choose a MLB Contact";
// tableUserCategory.Visible = false;
// tableRequestor.Visible = true;
//}
//else
//{
lblStep.Text = "Step 4 of 5:";
lblDescription.Text = "Choose a MLB Contact";
tableUserCategory.Visible = false;
tableRequestor.Visible = true;
//}
Session["licenseeDT"] = licenseeDT;
ddlRequestor.DataBind();
}
}
else
{
Response.Redirect("./");
}
}
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 btnBack5_Click(object sender, EventArgs e)
{
if (Session["licenseeDT"] != null)
{
licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]);
//Never reaching code
//if (licenseeDT[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 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 btnYes_Click(object sender, EventArgs e)
{
if (Session["adminID"] != null)
{
lblDescription.Visible = false;
tableProfile.Visible = false;
tableFinished.Visible = true;
//dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter();
dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter();
//dsCompany.legacyusersDataTable legacyusersDT = new dsCompany.legacyusersDataTable();
dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable();
//legacyusersDT = legacyusersTA.GetCompanyByID(Convert.ToInt32(Request.QueryString["id"].ToString()));
licenseeDT = licenseeTA.GetUserByID(Convert.ToInt32(Request.QueryString["id"].ToString()));
AdminActionLogDAL.LogAdminAction(Convert.ToInt32(Session["adminID"].ToString()), 1, licenseeDT.Rows[0]["email"].ToString(), licenseeDT.Rows[0]["firstname"].ToString(), licenseeDT.Rows[0]["lastname"].ToString());
//legacyusersDT.Rows[0].Delete();
licenseeDT.Rows[0].Delete();
//legacyusersTA.Update(legacyusersDT);
licenseeTA.Update(licenseeDT);
}
}
protected void SaveLevelA(bool bLicensee)
{
if (Session["licenseeDT"] != null)
{
licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]);
if (!bLicensee)
{
licenseeDT.Rows[0]["RequestorID"] = DBNull.Value;
}
licenseeDT.Rows[0]["FromDate"] = DBNull.Value;
licenseeDT.Rows[0]["ToDate"] = DBNull.Value;
licenseeDT.Rows[0]["AllowedYear"] = DBNull.Value;
//tablesitlet.Visible = true;
licenseeTA = new dsUserTableAdapters.licenseeTableAdapter();
licenseeTA.Update(licenseeDT);
//Let's update sitelets
dsUserTableAdapters.licensee2siteletsTableAdapter licensee2siteletsTA = new dsUserTableAdapters.licensee2siteletsTableAdapter();
//Delete the existing one first!
licensee2siteletsTA.DeleteByUID(licenseeDT[0].ID);
//Get all availaible sitelets
dsCompanyTableAdapters.siteletsTableAdapter siteletsTA = new dsCompanyTableAdapters.siteletsTableAdapter();
dsCompany.siteletsDataTable siteletsDT = new dsCompany.siteletsDataTable();
siteletsDT = siteletsTA.GetAllSitelets();
dsUser.licensee2siteletsDataTable licensee2siteletsDT = new dsUser.licensee2siteletsDataTable();
licensee2siteletsDT = licensee2siteletsTA.GetAllu2s();
for (int i = 0; i < siteletsDT.Rows.Count; i++)
{
dsUser.licensee2siteletsRow licensee2siteletR = licensee2siteletsDT.Newlicensee2siteletsRow();
licensee2siteletR.uid = licenseeDT[0].ID;
licensee2siteletR.sid = Convert.ToInt32(siteletsDT[i].id);
licensee2siteletsDT.Addlicensee2siteletsRow(licensee2siteletR);
licensee2siteletsTA.Update(licensee2siteletsDT);
}
lblStep.Visible = false;
lblDescription.Visible = false;
tableRequestor.Visible = false;
tableUserCategory.Visible = false;
tableFinished.Visible = true;
}
}
public List <user> DeleteUserAndReturnNewList(string uID, string cID)
{
//TO DO: Use uID to delete the user
dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter();
dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable();
licenseeDT = licenseeTA.GetUserByID(Convert.ToInt32(uID));
licenseeDT.Rows[0].Delete();
licenseeTA.Update(licenseeDT);
//Get the user list after deleteion
List <user> users = GetUsersByCID(cID);
return(users);
}
protected void btnContinue5_Click(object sender, EventArgs e)
{
if (Session["licenseeDT"] != null)
{
if (Page.IsValid)
{
licenseeTA = new dsUserTableAdapters.licenseeTableAdapter();
licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]);
licenseeDT.Rows[0]["cid"] = ddlCompany.SelectedValue;
//Let's update sitelets
dsUserTableAdapters.licensee2siteletsTableAdapter licensee2siteletsTA = new dsUserTableAdapters.licensee2siteletsTableAdapter();
//Delete the existing one first!
licensee2siteletsTA.DeleteByUID(licenseeDT[0].ID);
dsUser.licensee2siteletsDataTable licensee2siteletsDT = new dsUser.licensee2siteletsDataTable();
licensee2siteletsDT = licensee2siteletsTA.GetAllu2s();
foreach (ListItem li in cblSitelet.Items)
{
if (li.Selected)
{
dsUser.licensee2siteletsRow licensee2siteletR = licensee2siteletsDT.Newlicensee2siteletsRow();
licensee2siteletR.uid = licenseeDT[0].ID;
licensee2siteletR.sid = Convert.ToInt32(li.Value);
licensee2siteletsDT.Addlicensee2siteletsRow(licensee2siteletR);
licensee2siteletsTA.Update(licensee2siteletsDT);
}
}
licenseeTA.Update(licenseeDT);
lblStep.Visible = false;
lblDescription.Visible = false;
tablesitlet.Visible = false;
tableFinished.Visible = true;
}
}
else
{
Response.Redirect("./");
}
}
protected void cblSitelet_DataBound(object sender, EventArgs e)
{
if (Session["licenseeDT"] != null)
{
if (licenseeDT.Rows[0]["cid"].ToString() != ddlCompany.SelectedValue)//A different company was selected. Get requestor from the company data
{
dsCompanyTableAdapters.legacyusers2siteletsTableAdapter legacyusers2siteletsTA = new dsCompanyTableAdapters.legacyusers2siteletsTableAdapter();
dsCompany.legacyusers2siteletsDataTable legacyusers2siteletsDT = new dsCompany.legacyusers2siteletsDataTable();
legacyusers2siteletsDT = legacyusers2siteletsTA.Getc2sByCID(int.Parse(ddlCompany.SelectedValue));
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;
}
}
}
}
else
{
licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]);
dsUserTableAdapters.licensee2siteletsTableAdapter licensee2siteletsTA = new dsUserTableAdapters.licensee2siteletsTableAdapter();
dsUser.licensee2siteletsDataTable licensee2siteletsDT = new dsUser.licensee2siteletsDataTable();
licensee2siteletsDT = licensee2siteletsTA.Getu2sByUID(licenseeDT[0].ID);
for (int i = 0; i < licensee2siteletsDT.Rows.Count; i++)
{
foreach (ListItem li in cblSitelet.Items)
{
if (li.Value == licensee2siteletsDT[i].sid.ToString())
{
li.Selected = true;
}
}
}
}
}
}
protected void btnContinue4_Click(object sender, EventArgs e)
{
if (Session["licenseeDT"] != null)
{
if (Page.IsValid)
{
licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]);
licenseeDT[0].RequestorID = Convert.ToInt32(ddlRequestor.SelectedValue.ToString());
//Allow sitelet selection to level "A" 091408
//if (licenseeDT[0].UserLevel == "A")
//{
// Session["licenseeDT"] = licenseeDT;
// SaveLevelA(true);
//}
//else
//{
lblStep.Text = "Step 5 of 5:";
lblDescription.Text = "Give permissions to '" + licenseeDT[0].FirstName + " " + licenseeDT[0].LastName + "' to access the following sitelet(s)";
tableRequestor.Visible = false;
tablesitlet.Visible = true;
Session["licenseeDT"] = licenseeDT;
//}
cblSitelet.DataBind();
}
}
else
{
Response.Redirect("./");
}
}
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 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("./");
}
}
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("./");
}
}
public List <user> GetUsersByCID(string cid)
{
string pID = string.Empty;
string pFirstName = string.Empty;
string pLastName = string.Empty;
dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter();
dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable();
licenseeDT = licenseeTA.GetPrimaryContactByCID(Convert.ToInt32(cid));
if (licenseeDT.Rows.Count > 0)
{
pID = licenseeDT.Rows[0]["ID"].ToString();;
pFirstName = licenseeDT.Rows[0]["FirstName"].ToString();
pLastName = licenseeDT.Rows[0]["LastName"].ToString();
}
dsUserTableAdapters.licensee4MgrTableAdapter licensee4MgrTA = new dsUserTableAdapters.licensee4MgrTableAdapter();
dsUser.licensee4MgrDataTable licensee4MgrDT = new dsUser.licensee4MgrDataTable();
licensee4MgrDT = licensee4MgrTA.GetLicenseesByCID(Convert.ToInt32(cid));
for (int i = 0; i < licensee4MgrDT.Rows.Count; i++)
{
if (!(licensee4MgrDT.Rows[i]["UserLevel"] is DBNull))
{
switch (licensee4MgrDT[i].UserLevel)
{
case "A": licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break;
case "B": licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>"; break;
case "C":
if (!(licensee4MgrDT.Rows[i]["AllowedYear"] is DBNull))
{
if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= licensee4MgrDT[i].AllowedYear)
{
licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>";
}
else
{
licensee4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>";
}
}
else
{
licensee4MgrDT[i].Status = "<b>Unknown</b>";
}
break;
case "D":
if (!(licensee4MgrDT.Rows[i]["FromDate"] is DBNull) && !(licensee4MgrDT.Rows[i]["ToDate"] is DBNull))
{
if ((Convert.ToDateTime(DateTime.Now.ToShortDateString()) >= licensee4MgrDT[i].FromDate) && (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= licensee4MgrDT[i].ToDate))
{
licensee4MgrDT[i].Status = "<b><font color=\"cyan\">Current</font></b>";
}
else
{
licensee4MgrDT[i].Status = "<b><font color=\"red\">Expired</font></b>";
}
}
else
{
licensee4MgrDT[i].Status = "<b>Unknown</b>";
}
break;
case "X":
licensee4MgrDT[i].Status = "<b><font color=\"red\">Suspended</font></b>";
break;
default: break;
}
}
}
List <user> users = new List <user>();
foreach (DataRow dr in licensee4MgrDT.Rows)
{
user u = new user();
u.uid = dr["ID"].ToString();
u.firstName = dr["FirstName"].ToString();
u.lastName = dr["LastName"].ToString();
u.email = dr["Email"].ToString();
u.userCategory = dr["UserCategory"].ToString();
u.requestorName = dr["RequestorName"].ToString();
u.status = dr["Status"].ToString();
u.cid = cid;
u.primaryContact = Convert.ToBoolean(dr["PrimaryContact"].ToString());
//u.primaryContact = true;
//u.requestorName = "Hudson Choi";
//u.status = "Current";
/*
* if (dr["RequestorName"] != null)
* {
* u.requestorName = dr["RequestorName"].ToString();
* }
* if (dr["Status"] != null)
* {
* u.status = dr["Status"].ToString();
* }
*/
u.pid = pID;
u.pFirstName = pFirstName;
u.pLastName = pLastName;
if (dr["RequestorEmail"] != null)
{
u.mlbEmail = dr["RequestorEmail"].ToString();
u.mlbName = dr["RequestorName"].ToString();
}
else
{
u.mlbEmail = "";
u.mlbName = "";
}
users.Add(u);
}
return(users);
//List<CollectData>
//return c;
}
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 btnBack2_Click(object sender, EventArgs e)
{
lblStep.Text = "Step 1 of 5:";
lblDescription.Text = "Edit the user profile information";
tableProfile.Visible = true;
cvMessage.Enabled = true;
tableUserLevel.Visible = false;
ltrBack.Text = "<input type=\"button\" name=\"btnBack\" value=\"<<< Go Back\" onclick=\"window.location.replace('./UserMgr.aspx')\"/>";
if (Session["licenseeDT"] == null)
{
licenseeTA = new dsUserTableAdapters.licenseeTableAdapter();
licenseeDT = new dsUser.licenseeDataTable();
licenseeDT = licenseeTA.GetUserByID(Convert.ToInt32(Request.QueryString["id"].ToString()));
Session["licenseeDT"] = licenseeDT;
}
else
{
licenseeDT = (dsUser.licenseeDataTable)(Session["licenseeDT"]);
}
//Populate the existing data
if (!(licenseeDT.Rows[0]["FirstName"] is DBNull))
{
tbFirstName.Text = licenseeDT[0].FirstName;
}
if (!(licenseeDT.Rows[0]["MI"] is DBNull))
{
tbMI.Text = licenseeDT[0].MI;
}
if (!(licenseeDT.Rows[0]["LastName"] is DBNull))
{
tbLastName.Text = licenseeDT[0].LastName;
}
if (!(licenseeDT.Rows[0]["Email"] is DBNull))
{
tbEmail.Text = licenseeDT[0].Email;
}
if (!(licenseeDT.Rows[0]["Contract"] is DBNull))
{
tbContract.Text = licenseeDT[0].Contract;
}
if (!(licenseeDT.Rows[0]["Address1"] is DBNull))
{
tbAddress1.Text = licenseeDT[0].Address1;
}
if (!(licenseeDT.Rows[0]["Address2"] is DBNull))
{
tbAddress2.Text = licenseeDT[0].Address2;
}
if (!(licenseeDT.Rows[0]["City"] is DBNull))
{
tbCity.Text = licenseeDT[0].City;
}
if (!(licenseeDT.Rows[0]["State"] is DBNull))
{
bool bProvince = true;
foreach (ListItem l in ddlState.Items)
{
if (licenseeDT[0].State == l.Value)
{
l.Selected = true;
bProvince = false;
}
}
if (bProvince)
{
tbProvince.Text = licenseeDT[0].State;
}
}
if (!(licenseeDT.Rows[0]["Zip"] is DBNull))
{
tbZip.Text = licenseeDT[0].Zip;
}
if (!(licenseeDT.Rows[0]["Phone"] is DBNull))
{
tbPhone.Text = licenseeDT[0].Phone;
}
if (!(licenseeDT.Rows[0]["Fax"] is DBNull))
{
tbFax.Text = licenseeDT[0].Fax;
}
if (!(licenseeDT.Rows[0]["Password"] is DBNull))
{
tbPassword.Text = licenseeDT[0].Password;
}
}
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)
{
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))
{
tbFirstName.Text = licenseeDT[0].FirstName;
}
if (!(licenseeDT.Rows[0]["MI"] is DBNull))
{
tbMI.Text = licenseeDT[0].MI;
}
if (!(licenseeDT.Rows[0]["LastName"] is DBNull))
{
tbLastName.Text = licenseeDT[0].LastName;
}
if (!(licenseeDT.Rows[0]["Email"] is DBNull))
{
tbEmail.Text = licenseeDT[0].Email;
}
if (!(licenseeDT.Rows[0]["cid"] is DBNull))
{
dsCompanyTableAdapters.legacyusersTableAdapter legacyusersTA = new dsCompanyTableAdapters.legacyusersTableAdapter();
dsCompany.legacyusersDataTable legacyusersDT = legacyusersTA.GetAllCompanies();
ddlCompany.DataSource = legacyusersDT;
ddlCompany.DataTextField = "Company";
ddlCompany.DataValueField = "ID";
ddlCompany.SelectedValue = licenseeDT.Rows[0]["cid"].ToString();
ddlCompany.DataBind();
}
if (!(licenseeDT.Rows[0]["Contract"] is DBNull))
{
tbContract.Text = licenseeDT[0].Contract;
}
if (!(licenseeDT.Rows[0]["Address1"] is DBNull))
{
tbAddress1.Text = licenseeDT[0].Address1;
}
if (!(licenseeDT.Rows[0]["Address2"] is DBNull))
{
tbAddress2.Text = licenseeDT[0].Address2;
}
if (!(licenseeDT.Rows[0]["City"] is DBNull))
{
tbCity.Text = licenseeDT[0].City;
}
if (!(licenseeDT.Rows[0]["State"] is DBNull))
{
bool bProvince = true;
foreach (ListItem l in ddlState.Items)
{
if (licenseeDT[0].State == l.Value)
{
l.Selected = true;
bProvince = false;
}
}
if (bProvince)
{
tbProvince.Text = licenseeDT[0].State;
}
}
if (!(licenseeDT.Rows[0]["Zip"] is DBNull))
{
tbZip.Text = licenseeDT[0].Zip;
}
if (!(licenseeDT.Rows[0]["Phone"] is DBNull))
{
tbPhone.Text = licenseeDT[0].Phone;
}
if (!(licenseeDT.Rows[0]["Fax"] is DBNull))
{
tbFax.Text = licenseeDT[0].Fax;
}
if (!(licenseeDT.Rows[0]["Password"] is DBNull))
{
tbPassword.Text = licenseeDT[0].Password;
}
}
}
else//Take care of the deviants
{
Response.Redirect("./");
}
}
public string NotifyPrimaryContact(string pID, string cID)
{
//TO DO: Use pID and cID to send email;
//Get the user list after deleteion
//List<user> users = GetUsersByCID(cID);
//return users;
dsUserTableAdapters.licenseeTableAdapter licenseeTA = new dsUserTableAdapters.licenseeTableAdapter();
dsUser.licenseeDataTable licenseeDT = new dsUser.licenseeDataTable();
licenseeDT = licenseeTA.GetUserByID(Convert.ToInt32(pID));
string pEmail = licenseeDT.Rows[0]["email"].ToString();
//string pEmail = "*****@*****.**";
//string mlbEmail = "*****@*****.**";
string pFirstName = licenseeDT.Rows[0]["FirstName"].ToString();
string pLastName = licenseeDT.Rows[0]["LastName"].ToString();
dsRequestorsTableAdapters.requestorsTableAdapter requestorsTA = new dsRequestorsTableAdapters.requestorsTableAdapter();
dsRequestors.requestorsDataTable requestorsDT = new dsRequestors.requestorsDataTable();
requestorsDT = requestorsTA.GetRequestorByID(Convert.ToInt32(licenseeDT.Rows[0]["RequestorID"].ToString()));
string mlbEmail = requestorsDT.Rows[0]["Email"].ToString();
licenseeDT = licenseeTA.GetUsersByCID(Convert.ToInt32(cID));
StringBuilder sbMsg = new StringBuilder();
StringBuilder sbMsgPop = new StringBuilder();
sbMsg.Append("Dear " + pFirstName + " " + pLastName + ",<br><br>");
sbMsg.Append("As part of our ongoing security practices, this message provides a current active list of the MLBstyleguide.com user group that you oversee. Please review and confirm that all of the following users are in good standing. If the status has changed for any of the registered users, it is very important that you let your MLB representative know immediately so that they can be removed from the active user list.<br><br>");
//sbMsg.Append("Please confirm the following users are up-to-dated and let us know if anyone needs to be removed.<br><br>");
sbMsgPop.Append("The following users were emailed to '" + pFirstName + "' successfully!\n\n");
foreach (dsUser.licenseeRow r in licenseeDT.Rows)
{
sbMsg.Append(r["FirstName"].ToString() + " " + r["LastName"].ToString() + "<br>");
sbMsgPop.Append(r["FirstName"].ToString() + " " + r["LastName"].ToString() + "\n");
}
sbMsg.Append("<br>Thank you for your cooperation.<br><br>Major League Baseball Properties");
string _FromName = "Major League Baseball";
string _FromEmail = "*****@*****.**";
string strSubject = "MLB Style Guide: The current user list";
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(pEmail);
message.To.Clear();
message.To.Add(toAddress);
MailAddress ccAddress = new MailAddress(mlbEmail);
message.CC.Clear();
message.CC.Add(ccAddress);
message.Subject = strSubject;
message.IsBodyHtml = true;
message.Body = sbMsg.ToString();
smtpClient.Send(message);
}
catch (Exception ex)
{
//throw ex;
//iBadEmails++;
//sbBadEmailList.Append("<a href=\"EditUser.aspx?id=" + strID + "\" target=\"_blank\">" + strRecepient + "</a><br/>");
}
return(sbMsgPop.ToString());
}
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("./");
}
}
