private void poisk(ProidennieTests us) { Browser.Url = "http://dorus.iro23.ru/admin/user.php"; try { var id_removeall = Browser.FindElement(By.Id("id_removeall")); id_removeall.Click(); } catch (Exception e) { } var button = Browser.FindElement(By.LinkText("Показать больше ...")); button.Click(); var id_email = Browser.FindElement(By.Name("email")); id_email.SendKeys(us.email); var id_addfilter = Browser.FindElement(By.Id("id_addfilter")); id_addfilter.Click(); var user = Browser.FindElement(By.LinkText(us.name)); user.Click(); }
public List <ProidennieTests> Excel() { FileInfo newFile = new FileInfo(path); ExcelPackage pck = new ExcelPackage(newFile); //Add the Content sheet var ws = pck.Workbook.Worksheets.First(); ws.View.ShowGridLines = false; List <ProidennieTests> usr = new List <ProidennieTests>(); var end = ws.Cells.Where(c => c.Start.Column == 1 && !c.Value.ToString().Equals("")).Last().End.Row; for (int i = 2; i <= end; i++) { bool zapis = false; ProidennieTests us = new ProidennieTests(); if (ws.Cells[i, 8].Value.ToString() == "-" || Convert.ToDouble(ws.Cells[i, 8].Value) < 7) { us.inv = 1; zapis = true; } if (ws.Cells[i, 9].Value.ToString() == "-" || Convert.ToDouble(ws.Cells[i, 9].Value) < 1) { us.vh = 1; zapis = true; } if (ws.Cells[i, 10].Value.ToString() == "-" || Convert.ToDouble(ws.Cells[i, 10].Value) < 6) { us.pr1 = 1; zapis = true; } if (ws.Cells[i, 11].Value.ToString() == "-" || Convert.ToDouble(ws.Cells[i, 11].Value) < 6) { us.pr2 = 1; zapis = true; } if (ws.Cells[i, 12].Value.ToString() == "-" || Convert.ToDouble(ws.Cells[i, 12].Value) < 8) { us.itog = 1; zapis = true; } us.name = ws.Cells[i, 1].Value.ToString() + " " + ws.Cells[i, 2].Value.ToString(); us.email = ws.Cells[i, 6].Value.ToString(); if (zapis) { usr.Add(us); } } //Headers return(usr); }
public Prohod(List <ProidennieTests> users) { VHlList = otvets(@"C:\1\fcprya\Входная диагностика.xlsx"); List <VoprosOtvet> PR1lList = otvets(@"C:\1\fcprya\Промежуточный контроль №1.xlsx"); List <VoprosOtvet> PR2lList = otvets(@"C:\1\fcprya\Промежуточный контроль №2.xlsx"); List <VoprosOtvet> INList = otvets(@"C:\1\fcprya\ИНВАРИАНТНЫЙ МОДУЛЬ.xlsx"); List <VoprosOtvet> ITList = otvets(@"C:\1\fcprya\ВЫХОДНАЯ ДИАГНОСТИКА.xlsx"); foreach (var user in users) { this.user = user; Vhod(); try { if (user.vh == 1) { List <int> numberQuesten = new List <int>(); int kol_vern = rand.Next(2, 5); while (numberQuesten.Count < (10 - kol_vern)) { int chislo = rand.Next(1, 10); if (numberQuesten.Count(x => x == chislo) == 0) { numberQuesten.Add(chislo); } } TestZahod("http://dorus.iro23.ru/mod/quiz/view.php?id=1758"); nachalo(); for (int i = 0; i < 10; i++) { if (!numberQuesten.Where((x => x == (i + 1))).Any()) { Zadan(VHlList); } else { ZadanNeVerno(); } var but = Browser.FindElement(By.Name("next")); but.Click(); } ZaconcitPopitku(); } } catch { } try { if (user.pr1 == 1) { List <int> numberQuesten = new List <int>(); int kol_vern = rand.Next(6, 9); while (numberQuesten.Count < (10 - kol_vern)) { int chislo = rand.Next(1, 10); if (numberQuesten.Count(x => x == chislo) == 0) { numberQuesten.Add(chislo); } } TestZahod("http://dorus.iro23.ru/mod/quiz/view.php?id=1760"); nachalo(); for (int i = 0; i < 10; i++) { if (!numberQuesten.Where((x => x == (i + 1))).Any()) { Zadan(PR1lList); } else { ZadanNeVerno(); } var but = Browser.FindElement(By.Name("next")); but.Click(); } ZaconcitPopitku(); } } catch { } try { if (user.pr2 == 1) { List <int> numberQuesten = new List <int>(); int kol_vern = rand.Next(6, 10); while (numberQuesten.Count < (10 - kol_vern)) { int chislo = rand.Next(1, 10); if (numberQuesten.Count(x => x == chislo) == 0) { numberQuesten.Add(chislo); } } TestZahod("http://dorus.iro23.ru/mod/quiz/view.php?id=1761"); nachalo(); for (int i = 0; i < 10; i++) { if (!numberQuesten.Where((x => x == (i + 1))).Any()) { Zadan(PR2lList); } else { ZadanNeVerno(); } var but = Browser.FindElement(By.Name("next")); but.Click(); } ZaconcitPopitku(); } } catch { } try { if (user.inv == 1) { List <int> numberQuesten = new List <int>(); int kol_vern = rand.Next(9, 10); while (numberQuesten.Count < (10 - kol_vern)) { int chislo = rand.Next(1, 10); if (numberQuesten.Count(x => x == chislo) == 0) { numberQuesten.Add(chislo); } } TestZahod("http://dorus.iro23.ru/mod/quiz/view.php?id=1759"); nachalo(); for (int i = 0; i < 10; i++) { if (!numberQuesten.Where((x => x == (i + 1))).Any()) { Zadan(INList); } else { ZadanNeVerno(); } try { var but = Browser.FindElement(By.Name("next")); but.Click(); } catch { Browser.Navigate().Back(); var but = Browser.FindElement(By.Name("next")); but.Click(); } } ZaconcitPopitku(); } } catch { } try { if (user.itog == 1) { List <int> numberQuesten = new List <int>(); int kol_vern = rand.Next(6, 10); while (numberQuesten.Count < (10 - kol_vern)) { int chislo = rand.Next(1, 10); if (numberQuesten.Count(x => x == chislo) == 0) { numberQuesten.Add(chislo); } } TestZahod("http://dorus.iro23.ru/mod/quiz/view.php?id=1709"); nachalo(); for (int i = 0; i < 10; i++) { if (!numberQuesten.Where((x => x == (i + 1))).Any()) { Zadan(ITList); } else { ZadanNeVerno(); } try { var but = Browser.FindElement(By.Name("next")); but.Click(); } catch { Browser.Navigate().Back(); var but = Browser.FindElement(By.Name("next")); but.Click(); } } ZaconcitPopitku(); } } catch { } Logout(); } }