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