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