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 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["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("./");
        }
    }
Beispiel #6
0
    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();
             */
        }
    }
Beispiel #7
0
    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));
         *  }
         * }*/
    }