private void ExcelScanIntenal(Workbook workBookIn) { int numSheets = workBookIn.Sheets.Count; Worksheet sheet = (Worksheet)workBookIn.Sheets[1]; Range excelRange = sheet.UsedRange; int rowCount = excelRange.Rows.Count; int colCount = excelRange.Columns.Count; for (int i = 2; i <= rowCount; i++) { string type = ((Microsoft.Office.Interop.Excel.Range)excelRange.Cells[i, 1]).Value2.ToString(); string loginname = ((Microsoft.Office.Interop.Excel.Range)excelRange.Cells[i, 2]).Value2.ToString(); string member = ((Microsoft.Office.Interop.Excel.Range)excelRange.Cells[i, 3]).Value2.ToString(); string password = ((Microsoft.Office.Interop.Excel.Range)excelRange.Cells[i, 4]).Value2.ToString(); string credit = ((Microsoft.Office.Interop.Excel.Range)excelRange.Cells[i, 5]).Value2.ToString(); string group = ((Microsoft.Office.Interop.Excel.Range)excelRange.Cells[i, 6]).Value2.ToString(); string status = ""; try { status = ((Microsoft.Office.Interop.Excel.Range)excelRange.Cells[i, 7]).Value2.ToString(); } catch (Exception) { status = ""; } if (status.Trim() == "") { objRow r = new objRow(); r.type = type; r.loginname = loginname; r.member = member; r.password = password; r.credit = credit; r.group = group; sheet.Cells[i, 7] = createSbobetMember(r); workBookIn.Save(); } } helper.Close(); }
private string createSbobetMember(objRow r) { Account o = db.getAccountByLoginName(r.loginname, r.type, frmLogin.user.username); if (o != null) { if (currentLoginName != r.loginname) { currentLoginName = r.loginname; if (File.Exists(@"config.ini")) { parser = new IniParser(@"config.ini"); } url = parser.GetSetting("sbobet", "link"); if (url[url.Length - 1].ToString() != "/") { url += "/"; } helper.GotoURL(url); helper.FindElement(By.XPath("//input[@id='username']")).SendKeys(o.Loginname); helper.FindElement(By.XPath("//input[@id='password']")).SendKeys(mylib.md5_Decrypt(o.Password)); helper.FindElement(By.XPath("//input[@id='btnSubmit']")).Click(); IWebElement firstposition = helper.FindElement(By.XPath("//span[@id='firstposition']"), 10); if (firstposition != null) { IWebElement secondposition = helper.FindElement(By.XPath("//span[@id='secondposition']"), 5); int index1 = Int16.Parse(firstposition.Text[0].ToString()) - 1; int index2 = Int16.Parse(secondposition.Text[0].ToString()) - 1; helper.FindElement(By.XPath("//input[@id='FirstChar']")).SendKeys(o.Code[index1].ToString()); helper.FindElement(By.XPath("//input[@id='SecondChar']")).SendKeys(o.Code[index2].ToString()); helper.FindElement(By.XPath("//input[@id='btnSubmit']")).Click(); } helper.GoToFrame("//frame[@id='MenuFrame']"); helper.FindElement(By.XPath("//div[@class='Plus' and contains(text(),'3. Member Mgmt')]")).Click(); helper.FindElement(By.XPath("//td[@id='MemberMgmt_NewMember']")).Click(); } helper.GoToFrame(SbobetPage.frame); IWebElement form = helper.FindElement(By.XPath("//form[@id='SecurityCodeForm']"), 10); if (form != null) { IWebElement first = helper.FindElement(By.XPath("//form[@id='SecurityCodeForm']//span[@style='padding-left:5px']"), 5); IWebElement second = helper.FindElement(By.XPath("//form[@id='SecurityCodeForm']//span[@style='padding-left:5px;padding-right:5px']"), 5); int index1 = Int16.Parse(first.Text[0].ToString()) - 1; int index2 = Int16.Parse(second.Text[0].ToString()) - 1; helper.FindElement(By.XPath("//input[@id='digit1']")).SendKeys(o.Code[index1].ToString()); helper.FindElement(By.XPath("//input[@id='digit2']")).SendKeys(o.Code[index2].ToString()); helper.FindElement(By.XPath("//input[@type='submit']")).Click(); } SelectElement selector0 = new SelectElement(helper.FindElement(By.XPath("//select[@id='account0']"))); SelectElement selector1 = new SelectElement(helper.FindElement(By.XPath("//select[@id='account1']"))); SelectElement selector2 = new SelectElement(helper.FindElement(By.XPath("//select[@id='account2']"))); selector0.SelectByText(Util.Right(r.member, 3)[0].ToString()); selector1.SelectByText(Util.Right(r.member, 2)[0].ToString()); selector2.SelectByText(Util.Right(r.member, 1)[0].ToString()); helper.FindElement(By.XPath("//input[@value='Check Availability']")).Click(); Thread.Sleep(1000); string text = helper.driver.SwitchTo().Alert().Text; helper.driver.SwitchTo().Alert().Accept(); if (text.Contains("The username selected is available")) { helper.SendKeys(helper.FindElement(By.XPath("//input[@id='TextPassword']")), r.password); helper.SendKeys(helper.FindElement(By.XPath("//input[@id='TextCredit']")), r.credit); SelectElement selectGroup = new SelectElement(helper.FindElement(By.XPath("//select[@id='UGroup']"))); selectGroup.SelectByText(r.group); string imgUrl = helper.FindElement(By.XPath("//img[@id='imgText']")).GetAttribute("src"); frmCaptcha frm = new frmCaptcha(imgUrl); frm.ShowDialog(); helper.SendKeys(helper.FindElement(By.XPath("//input[@id='vcode']")), frm.captcha); helper.FindElement(By.XPath("//input[@value='Create']")).Click(); Thread.Sleep(1000); helper.driver.SwitchTo().Alert().Accept(); return("Passed"); } } return("Failed"); }