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