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