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