public async void Added()
{
List <oo> list_oo = new List <oo>();
oo oo;
for (int i = 0; i < kol_vo_ob; i++)
{
oo = new oo();
oo.id_mo = MO;
oo.tip = tip;
list_oo.Add(oo);
}
if (tip == 1)
{
int Length = 8;
user admin = new user();
admin.id_mo = MO;
admin.login = "******" + MO;
admin.role = 3;
const string valid = "1234567890";
StringBuilder res = new StringBuilder();
Random rnd = new Random();
while (0 < Length--)
{
res.Append(valid[rnd.Next(valid.Length)]);
}
admin.pass = res.ToString();
await db.AddAsync(admin);
}
await db.AddRangeAsync(list_oo);
await db.SaveChangesAsync();
Added_Grupp(list_oo);
}
private async void FormirListAndCreatOO(IFormFile uploadedFile)
{
using (var package = new ExcelPackage(uploadedFile.OpenReadStream()))
{
var workSheet = package.Workbook.Worksheets[0];
oo oo;
klass gruppa;
user user;
if (workSheet.Cells[1, 3].Value != null)
{
mo mo;
mo = db.mo.Where(p => p.name == workSheet.Cells[1, 3].Value.ToString()).FirstOrDefault();
if (mo == null)
{
mo = new mo();
mo.name = workSheet.Cells[1, 3].Value.ToString();
await db.AddAsync(mo);
await db.SaveChangesAsync();
int Length = 8;
user admin = new user();
admin.id_mo = mo.id;
admin.login = "******" + mo.id;
admin.role = 3;
const string valid = "1234567890";
StringBuilder res = new StringBuilder();
Random rnd = new Random();
while (0 < Length--)
{
res.Append(valid[rnd.Next(valid.Length)]);
}
admin.pass = res.ToString();
await db.AddAsync(admin);
await db.SaveChangesAsync();
}
for (int i = 4; workSheet.Cells[i, 1].Value != null; i++)
{
if (workSheet.Cells[i, 2].Value != null)
{
oo = db.oo.Where(p => p.kod == workSheet.Cells[i, 2].Value.ToString() && p.id_mo == mo.id && p.tip == Convert.ToInt32(workSheet.Cells[i, 1].Value)).FirstOrDefault();
if (oo == null)
{
oo = new oo();
oo.id_mo = mo.id;
oo.kod = workSheet.Cells[i, 2].Value.ToString();
oo.tip = Convert.ToInt32(workSheet.Cells[i, 1].Value);
await db.AddAsync(oo);
await db.SaveChangesAsync();
int Length = 8;
user admin = new user();
admin.id_oo = oo.id;
admin.login = "******" + oo.id;
admin.role = 2;
const string valid = "1234567890";
StringBuilder res = new StringBuilder();
Random rnd = new Random();
while (0 < Length--)
{
res.Append(valid[rnd.Next(valid.Length)]);
}
admin.pass = res.ToString();
await db.AddAsync(admin);
await db.SaveChangesAsync();
}
//если школа 1 раз
//если школа 2й раз
if (workSheet.Cells[i, 5].Value != null)
{
if (workSheet.Cells[i, 4].Value != null)
{
gruppa = db.klass.Where(p => p.kod == workSheet.Cells[i, 4].Value.ToString() && p.klass_n == Convert.ToInt32(workSheet.Cells[i, 3].Value) && p.id_oo == oo.id).FirstOrDefault();
}
else
{
gruppa = null;
}
int kolvoklass = 0;
if (gruppa == null)
{
gruppa = new klass();
gruppa.id_oo = oo.id;
gruppa.klass_n = Convert.ToInt32(workSheet.Cells[i, 3].Value);
gruppa.kod = (workSheet.Cells[i, 4].Value != null ? workSheet.Cells[i, 4].Value.ToString() : String.Empty);
await db.AddAsync(gruppa);
await db.SaveChangesAsync();
int Length = 8;
user admin = new user();
admin.id_klass = gruppa.id;
admin.login = "******" + gruppa.id;
admin.role = 1;
const string valid = "1234567890";
StringBuilder res = new StringBuilder();
Random rnd = new Random();
while (0 < Length--)
{
res.Append(valid[rnd.Next(valid.Length)]);
}
admin.pass = res.ToString();
await db.AddAsync(admin);
await db.SaveChangesAsync();
}
else
{
kolvoklass = db.User.Where(p => p.id_klass == gruppa.id && p.role != 1).Count();
}
for (int k = kolvoklass; k < kolvoklass + Convert.ToInt32(workSheet.Cells[i, 5].Value); k++)
{
int Length = 8;
user = new user();
user.id_klass = gruppa.id;
user.login = "******" + gruppa.id + "У" + k;
var res = new StringBuilder();
rnd = new Random();
while (0 < Length--)
{
res.Append(valid[rnd.Next(valid.Length)]);
}
user.pass = res.ToString();
await db.AddAsync(user);
await db.SaveChangesAsync();
}
}
}
}
}
}
}