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