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"; } }