public static void SaveEl_2(El_2 e, int objId, NPLabDbContext db) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); currObj = (from p in db.Object where p.Id == objId select p).FirstOrDefault(); //e.Object = currObj; //.ObjectsId = currObj.Id; currObj.El_2.Add(e); db.Entry(e).State = System.Data.Entity.EntityState.Added; foreach (Sectors sec in e.ListOfSectors) { db.Entry(sec).State = System.Data.Entity.EntityState.Added; foreach (Floors f in sec.ListOfFloors) { db.Entry(f).State = System.Data.Entity.EntityState.Added; foreach (Rooms r in f.ListOfRooms) { db.Entry(r).State = System.Data.Entity.EntityState.Added; foreach (Installations inst in r.ListOfInstallations) db.Entry(inst).State = System.Data.Entity.EntityState.Added; } } } db.SaveChanges(); }
private void ChooseObj_Load(object sender, EventArgs e) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); var db = new NPLabDbContext(); string[] objNames = (from p in db.Object where p.ObjectName.Length > 0 && p.ObjectName != null select p.ObjectName).ToArray<string>(); ListObjects.Items.AddRange(objNames); }
private void SearchField_TextChanged(object sender, EventArgs e) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); var db = new NPLabDbContext(); string[] objNames = (from p in db.Object where p.ObjectName.IndexOf(SearchField.Text.ToLower()) != -1 && p.ObjectName != null select p.ObjectName).ToArray<string>(); ListObjects.Items.Clear(); ListObjects.Items.AddRange(objNames); }
public static void SaveEl_3m(EL_3m e, int objId, NPLabDbContext db) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); //var db = new NPLabDbContext(); currObj = (from p in db.Object where p.Id == objId select p).FirstOrDefault(); currObj.El_3m.Add(e); db.Entry(e).State = System.Data.Entity.EntityState.Added; foreach (LightningGrounding cab in e.ListOfGroundings_El_3m) db.Entry(cab).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); }
public static void SaveEl_3(EL_3 e, int objId, NPLabDbContext db) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); currObj = (from p in db.Object where p.Id == objId select p).FirstOrDefault(); //e.Object = currObj; //.ObjectsId = currObj.Id; currObj.El_3.Add(e); db.Entry(e).State = System.Data.Entity.EntityState.Added; foreach (Grounding gr in e.ListOfGroundings) db.Entry(gr).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); }
public static void Main() { Database.SetInitializer( new MigrateDatabaseToLatestVersion<NPLabDbContext,Configuration>()); var db = new NPLabDbContext(); var engineer = new Engineers { NameOfEngineer = "Malin Zhelev", Time = DateTime.Now }; db.Engineers.Add(engineer); db.SaveChanges(); Console.WriteLine(db.Engineers.Count()); }
private void Load_Click(object sender, EventArgs e) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); var db = new NPLabDbContext(); if (ListObjects.SelectedIndex == -1) { MessageBox.Show("Не сте избрали обект"); return; } int toLoad; try { toLoad = (from p in db.Object where p.ObjectName == ListObjects.SelectedItem.ToString() select p.Id).First(); } catch { MessageBox.Show("Грешка! Не съществува такъв обект"); return; } Main M = new Main(toLoad, H); M.Show(); M.Focus(); this.Close(); }
public static void SaveEl_4(EL_4 e, int objId, NPLabDbContext db) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); //var db = new NPLabDbContext(); currObj = (from p in db.Object where p.Id == objId select p).FirstOrDefault(); //currObj.El_4.Add(e); //db.Entry(e).State = System.Data.Entity.EntityState.Added; //foreach (Sectors_El_4 sec in e.ListOfSectors) //{ // db.Entry(sec).State = System.Data.Entity.EntityState.Added; // foreach (Floors_El_4 f in sec.ListOfFloors) // { // db.Entry(f).State = System.Data.Entity.EntityState.Added; // foreach (Rooms_El_4 r in f.ListOfRooms) // { // db.Entry(r).State = System.Data.Entity.EntityState.Added; // foreach (Installation_El_4 inst in r.ListOfInstallations) db.Entry(inst).State = System.Data.Entity.EntityState.Added; // } // } //} //foreach (Cabel cab in e.ListOfCabels) db.Entry(cab).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); }
public static void UpdateEl_4(EL_4 isol, DateTime date, int objId, NPLabDbContext db) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); //var db = new NPLabDbContext(); currObj = (from p in db.Object where p.Id == objId select p).FirstOrDefault(); var curr = (from el in currObj.El_4 where el.Date == date select el).FirstOrDefault(); //curr = isol; //db.Entry(isol).State = System.Data.Entity.EntityState.Modified; //foreach (Cabel cab in isol.ListOfCabels) db.Entry(cab).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public static void UpdateEl_1(EL_1 isol, DateTime date, int objId, NPLabDbContext db) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>()); //var db = new NPLabDbContext(); //currObj = (from p in db.Object // where p.Id == objId // select p).FirstOrDefault(); //EL_1 curr = (from el in db.EL_1 // where el.Date == date && el.ObjectsId == objId // select el).FirstOrDefault(); //EL_1 t = isol; //isol = new EL_1(); //foreach (Cabel cab in t.ListOfCabels) //{ // Cabel tempC = new Cabel(); // tempC.CabelModel = cab.CabelModel; // tempC.CabelType = cab.CabelType; // tempC.ConductorsCount = cab.ConductorsCount; // tempC.L1 = cab.L1; // tempC.L2 = cab.L2; // tempC.L3 = cab.L3; // tempC.Measured = cab.Measured; // tempC.N = cab.N; // tempC.Name = cab.Name; // tempC.PE = cab.PE; // tempC.PEN = cab.PEN; // tempC.Thickness = cab.Thickness; // isol.ListOfCabels.Add(tempC); //} //isol.MaxMeasured = t.MaxMeasured; //isol.Min = t.Min; //isol.NameOfEngineer = t.NameOfEngineer; //isol.SourceVoltage = t.SourceVoltage; //isol.MinMeasured = t.MaxMeasured; //isol.Date = t.Date; ////currObj.El_1.Remove(curr); ////curr.ListOfCabels.Clear(); //for (int i = 0; i < curr.ListOfCabels.Count; i++) { Cabel cab = curr.ListOfCabels.ElementAt(i); db.Cabel.Remove(cab); db.Entry(cab).State = System.Data.Entity.EntityState.Deleted; } //curr.ListOfCabels.Clear(); //db.Entry(curr).State = System.Data.Entity.EntityState.Deleted; //currObj.El_1.Add(isol); //.Entry(isol).State = System.Data.Entity.EntityState.Added; //foreach (Cabel cab in isol.ListOfCabels) db.Entry(cab).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); //db.Entry(isol).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public Engineers GetById(string NameOfEngineer, NPLabDbContext context) { return context.Engineers.Find(NameOfEngineer); }
public ICollection<Engineers> GetAll(NPLabDbContext context) { return context.Engineers.ToList(); }