public static void SaveEl_1(EL_1 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_1.Add(e);
db.Entry(e).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_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 void LoadIsol(EL_1 isol)
{
}
//private void IsolationTable_Scroll(object sender, EventArgs e) { IsolationTable.VerticalScroll.Value = (sender as ScrollBar).Value; }
private void Main_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'nPLabDataSet.Engineers' table. You can move, or remove it, as needed.
//this.engineersTableAdapter.Fill(this.nPLabDataSet.Engineers);
Database.SetInitializer(new MigrateDatabaseToLatestVersion<NPLabDbContext, Configuration>());
currObj = (from p in db.Object
where p.Id == this.objId
select p).FirstOrDefault();
//
//var db = new NPLabDbContext();
//Създаване на скролбар
IsolationTable.AutoScroll = true;
//Инициализация на статичните данни
Stats = new StaticClass();
//
tempIsol = new EL_1
{
Date = DateTime.Now,
SourceVoltage = System.Convert.ToInt32(Naprejenie.Value),
Min = System.Convert.ToDouble(Norm.Value),
MinMeasured = System.Convert.ToInt32(MinMeas.Value),
MaxMeasured = System.Convert.ToInt32(MaxMeas.Value),
};
EngineerNameIsol.Items.AddRange(Stats.Engineers);
EngineerNameIsol.SelectedIndex = 0;
EngineerNameImp.Items.AddRange(Stats.Engineers);
EngineerNameImp.SelectedIndex = 0;
EngineerNameGr.Items.AddRange(Stats.Engineers);
EngineerNameGr.SelectedIndex = 0;
EngineerNameLiPro.Items.AddRange(Stats.Engineers);
EngineerNameLiPro.SelectedIndex = 0;
EngineerNameDef.Items.AddRange(Stats.Engineers);
EngineerNameDef.SelectedIndex = 0;
//Добавяне на вече съществуващите контроли към списъците с тях
Names.Add(textBoxName);
TypeCabs.Add(TypeCabel);
Count.Add(Number);
Surface.Add(CabelArea);
MeasuredForm.Add(Measured);
Conductors.Add(Cond);
Rem.Add(Delete);
//По подразбиране се избира тип кабел "СВТ"
tempIsol.ListOfCabels.Add(new Cabel());
TypeCabel.SelectedIndex = 0;
textBoxName_TextChanged(textBoxName, new EventArgs());
Number_ValueChanged(Number, new EventArgs());
CabelArea_ValueChanged(CabelArea, new EventArgs());
Measured_ValueChanged(Measured, new EventArgs());
tempImp.Coefficent = System.Convert.ToInt32(Coefficient.Value);
tempImp.MaxMeasured = System.Convert.ToDouble(Maximum.Value);
tempImp.MinMeasured = System.Convert.ToDouble(Minimum.Value);
Grounding gr = new Models.Grounding
{
AuxiliaryGrounding = System.Convert.ToDouble(AuxGr1.Value),
Probe = System.Convert.ToDouble(Probe1.Value),
Measured = System.Convert.ToDouble(Meas1.Value),
Adjusted = System.Convert.ToDouble(Adj1.Value),
Name = GroundingName.Text
};
tempGr.ListOfGroundings.Add(gr);
LightningGrounding LiGr = new Models.LightningGrounding
{
AuxiliaryGrounding = System.Convert.ToDouble(AuxLi1.Value),
Probe = System.Convert.ToDouble(ProbeLi1.Value),
Measured = System.Convert.ToDouble(MeasLi1.Value),
Adjusted = System.Convert.ToDouble(AdjLi1.Value),
Name = LightningName.Text
};
tempLiPro.ListOfGroundings_El_3m.Add(LiGr);
LoadObj(currObj);
tempDef.DNHighest = System.Convert.ToDouble(MaxIN.Value);
tempDef.DNLowest = System.Convert.ToDouble(MinIN.Value);
tempDef.DTHighest = System.Convert.ToDouble(Maxt.Value);
tempDef.DTLowest = System.Convert.ToDouble(Mint.Value);
tempDef.maxDN = System.Convert.ToDouble(NormIN.Value);
tempDef.maxDT = System.Convert.ToDouble(Normt.Value);
}
public void LoadIsol(EL_1 e, bool clear)
{
EngineerNameIsol.SelectedItem = e.NameOfEngineer;
IsolationDate.Value = e.Date;
Norm.Value = System.Convert.ToDecimal(e.Min);
MinMeas.Value = e.MinMeasured;
MaxMeas.Value = e.MaxMeasured;
Naprejenie.Value = e.SourceVoltage;
if (clear)
{
for (int j = 1; j < Rem.Count; j++) Rem[1].PerformClick();
}
int i;
for (i = 0; i < e.ListOfCabels.Count; i++)
{
Cabel cab = e.ListOfCabels.ElementAt(i);
Names[i].Text = cab.CabelType;
TypeCabs[i].SelectedItem = cab.CabelModel;
Count[i].Value = cab.ConductorsCount;
Surface[i].Value = System.Convert.ToDecimal(cab.Thickness);
MeasuredForm[i].Value = System.Convert.ToDecimal(cab.Measured);
if(Names.Count < e.ListOfCabels.Count) ButtonForAdd.PerformClick();
}
//Rem[i-1].PerformClick();
//Rem[i-2].PerformClick();
tempIsol = e;
}
private void SaveIsol_Click(object sender, EventArgs e)
{
if (!isNewIsol) SaveLoad.UpdateEl_1(tempIsol, IsolationDate.Value, objId, db);
else
{
if (currObj.El_1.Any<EL_1>(p => p.Date == IsolationDate.Value))
{
MessageBox.Show("Вече съществува актуализация със същата дата!");
return;
}
SaveLoad.SaveEl_1(tempIsol, objId, db);
//currObj.El_1.Add(tempIsol);
}
//db.SaveChanges();
foreach (Control con in Isolation.Controls)
{
if (con == NewActIsol || con == EditActIsol || con == SaveIsol || con == BackIsol || con == EngineerNameIsol || con == IsolationDate)
con.Enabled = true;
else con.Enabled = false;
}
SwitchVisIsol();
EL_1 t = tempIsol;
tempIsol = 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;
tempIsol.ListOfCabels.Add(tempC);
}
tempIsol.MaxMeasured = t.MaxMeasured;
tempIsol.Min = t.Min;
tempIsol.NameOfEngineer = t.NameOfEngineer;
tempIsol.SourceVoltage = t.SourceVoltage;
tempIsol.MinMeasured = t.MaxMeasured;
tempIsol.Date = t.Date;
}