private bool findCluster(Report report)
{
if (exist(report))
{
return(true);
}
using (var context = new DB14())
{
var studentAndCourseList = context.C.ToList();
if (studentAndCourseList.Count == 0)
{
return(false);
}
foreach (Cluster c in studentAndCourseList)
{
c.list = context.R.Where(l => l.ClusterId == c.Id).ToList();
if (c.Belong(report))
{
c.push(report);
CalcAvgLoc(c); /// get real location by algo
context.SaveChanges();
return(true);
}
}
}
return(false);
}
public async Task labelDataAsync(string s, string token)
{
using (var context = new DB14())
{
var a = context.A.ToList();
List = context.C.ToList();
LogEvent task = log.LogMessege("labeld data", true);
foreach (Cluster c in List)
{
var d = context.R.ToList();
c.list = context.R.Where(l => l.ClusterId == c.Id).ToList();
foreach (Report r in c)
{
if (r.needAttr())
{
await FindLocAsync(r, s, token, task);
}
}
context.SaveChanges();
}
}
}
public void refreshLocalFromDB()
{
using (var context = new DB14())
{
list = context.C.ToList();
var temp2 = context.A.ToList();
foreach (Cluster c in list)
{
c.list = context.R.Where(l => l.ClusterId == c.Id).ToList();
}
}
}
public Cluster GetListReports()
{
using (var context = new DB14())
{
var addres = context.A.ToList();
var reports = context.R.ToList();
return(new Cluster()
{
list = reports
});
}
}
public void viewData()
{
using (var context = new DB14())
{
log.LogMessege("hi");
var studentAndCourseList = context.R.ToList();
log.LogMessege(studentAndCourseList.Count.ToString());
foreach (var item in studentAndCourseList)
{
log.LogMessege("Report Id: " + item.Id);
}
}
}
private void createNewCluster(Report report)
{
using (var context = new DB14())
{
log.LogMessege("create new");
var nr = new Cluster(report);
//context.R.Add(report);
context.C.Add(nr);
log.LogMessege("try save the new one");
context.SaveChanges();
//list.Add();
log.LogMessege("create new Clusters at " + report.GetDateTime().ToString(), false);
}
}
private bool exist(Report report)
{
using (var context = new DB14())
{
var studentAndCourseList = context.R.ToList();
var loc = context.A.ToList();
foreach (var item in studentAndCourseList)
{
if (item.Id == report.Id)
{
log.LogMessege("Report Id exist: " + item.Id);
return(true);
}
}
log.LogMessege("Report dont find at data base" + report.Id);
return(false);
}
}
public void Save()
{
using (var ctx = new DB14())
{
var t1 = ctx.R.ToList();
var t2 = ctx.C.ToList();
var t3 = ctx.A.ToList();
foreach (var l in List)
{
var resToUpdate = ctx.C.AsNoTracking().Select(x => x.Id == l.Id);
if (resToUpdate != null)
{
ctx.C.Attach(l);
ctx.Entry(l).State = System.Data.Entity.EntityState.Modified;
}
else
{
ctx.C.Add(l);
}
}
log.LogMessege("saveing");
ctx.SaveChanges();
}
}
private void Raspisanie_Load(object sender, EventArgs e)
{
DB14 db = new DB14(kursach.Program.Pole.pole);
DB11 db2 = new DB11(kursach.Program.Pole.pole);
DB15 db3 = new DB15(kursach.Program.Pole.pole);
var ec = from n in db.Vrach
select n;
var ec2 = from n2 in db2.Raspisanie
select n2;
var ec3 = from n3 in db3.Vrem
select n3;
label1.Text += "\n";
label2.Text += "\n";
label3.Text += "\n";
label4.Text += "\n";
label5.Text += "\n";
label6.Text += "\n";
label7.Text += "\n";
label8.Text += "\n";
foreach (var i in ec)
{
label1.Text += i.FIO + "\n";
foreach (var i2 in ec2)
{
if (i.ID == i2.IDVrach)
{
foreach (var i3 in ec3)
{
if (i2.IDVrem == i3.ID)
{
if (i3.Den == "Понедельник")
{
label2.Text += i3.VremN + "-" + i3.VremK;
}
if (i3.Den == "Вторник")
{
label3.Text += i3.VremN + "-" + i3.VremK;
}
if (i3.Den == "Среда")
{
label4.Text += i3.VremN + "-" + i3.VremK;
}
if (i3.Den == "Четверг")
{
label5.Text += i3.VremN + "-" + i3.VremK;
}
if (i3.Den == "Пятница")
{
label6.Text += i3.VremN + "-" + i3.VremK;
}
if (i3.Den == "Суббота")
{
label7.Text += i3.VremN + "-" + i3.VremK;
}
if (i3.Den == "Воскресенье")
{
label8.Text += i3.VremN + "-" + i3.VremK;
}
}
}
}
}
label2.Text += "\n";
label3.Text += "\n";
label4.Text += "\n";
label5.Text += "\n";
label6.Text += "\n";
label7.Text += "\n";
label8.Text += "\n";
}
}
