private void Button_Click_OK(Object sender, RoutedEventArgs e)
{
using (PersistanceContext db = new PersistanceContext())
{
List <User> users = db.Users.Where(u => u.Login.Equals(Login.Text)).ToList();
/////////////////////////////////////////////////
///Проверка правильности ввода логина и пароля///
/////////////////////////////////////////////////
// По результатам проверки - вывод
if (users.Count == 0 || !users[0].Password.Equals(Password.Password))
{
MessageBox.Show("Неверно введен логин или пароль!", "Ошибка авторизации!");
}
else
{
User CurrentUser = users[0];;
mainWindow.CurrentUser = CurrentUser;
bool isEngineer = CurrentUser.Role.Equals("engineer");
mainWindow.AddPcpButton.IsEnabled = isEngineer;
mainWindow.AddEsnButton.IsEnabled = isEngineer;
mainWindow.EditPcpButton.IsEnabled = isEngineer;
mainWindow.EditEsnButton.IsEnabled = isEngineer;
mainWindow.Show();
Close();
}
}
}
/// <summary>
/// Кнопка добавить
/// </summary>
private void Button_Click_OK(Object sender, RoutedEventArgs e)
{
ProgressiveCavityPump newPump = new ProgressiveCavityPump();
newPump.RateCoefficients = new List <RateCoefficient>();
newPump.PowerCoefficients = new List <PowerCoefficient>();
newPump.TorqueCoefficients = new List <TorqueCoefficient>();
try
{
for (int i = 1; i < RateCoefficients.Children.Count; i++)
{
TextBox box = (TextBox)(RateCoefficients.Children[i] as StackPanel).Children[1];
int order = i - 1;
newPump.RateCoefficients.Add(new RateCoefficient(order, double.Parse(box.Text)));
}
for (int i = 1; i < PowerCoefficients.Children.Count; i++)
{
TextBox box = (TextBox)(PowerCoefficients.Children[i] as StackPanel).Children[1];
int order = i - 1;
newPump.PowerCoefficients.Add(new PowerCoefficient(order, double.Parse(box.Text)));
}
for (int i = 1; i < TorqueCoefficients.Children.Count; i++)
{
TextBox box = (TextBox)(TorqueCoefficients.Children[i] as StackPanel).Children[1];
int order = i - 1;
newPump.TorqueCoefficients.Add(new TorqueCoefficient(order, double.Parse(box.Text)));
}
newPump.Name = ((TextBox)NamePCP.Children[1]).Text;
newPump.Diameter = Convert.ToDouble(((TextBox)Diameter.Children[1]).Text);
newPump.NominalRate = Convert.ToDouble(((TextBox)NominalRate.Children[1]).Text);
newPump.BaseSpeed = Convert.ToDouble(((TextBox)NominalSpeed.Children[1]).Text);
}
catch
{
MessageBox.Show("Ошибка Неправильно задано одно из полей.");
return;
}
this.Hide();
//MainWindow.Button_Click_UpdateGrafESN(null, null);
using (PersistanceContext db = new PersistanceContext())
{
db.PcpPumps.Add(newPump);
db.SaveChanges();
//Обновляем каталог
MainWindow.CatalogPcp = db.PcpPumps.Include("PowerCoefficients").Include("RateCoefficients").Include("TorqueCoefficients").ToList();
//Отображаем таблицу каталога ЭЦН
MainWindow.ShowPCPDataBase();
}
MainWindow.Button_Click_UpdateGrafPCP(null, null);
}
/// <summary>
/// Кнопка добавить
/// </summary>
private void Button_Click_OK(Object sender, RoutedEventArgs e)
{
ElectricSubmersiblePump pump = new ElectricSubmersiblePump();
pump.HeadCoefficients = new List <HeadCoefficient>();
pump.PowerCoefficients = new List <PowerCoefficient>();
pump.EfficiencyCoefficients = new List <EfficiencyCoefficient>();
TextBox[] HeadTextBoxes = { TB_HeadX0, TB_HeadX1, TB_HeadX2, TB_HeadX3, TB_HeadX4,
TB_HeadX5, TB_HeadX6, TB_HeadX7, TB_HeadX8, TB_HeadX9 };
TextBox[] PowerTextBoxes = { TB_Power0, TB_Power1, TB_Power2, TB_Power3, TB_Power4,
TB_Power5, TB_Power6, TB_Power7, TB_Power8, TB_Power9 };
TextBox[] EfficiencyTextBoxes = { TB_Efficiency0, TB_Efficiency1, TB_Efficiency2, TB_Efficiency3, TB_Efficiency4,
TB_Efficiency5, TB_Efficiency6, TB_Efficiency7, TB_Efficiency8, TB_Efficiency9 };
try
{
for (int i = 0; i < HeadTextBoxes.Count(); i++)
{
TextBox box = HeadTextBoxes[i];
pump.HeadCoefficients.Add(new HeadCoefficient(i, double.Parse(box.Text)));
}
for (int i = 0; i < PowerTextBoxes.Count(); i++)
{
TextBox box = PowerTextBoxes[i];
pump.PowerCoefficients.Add(new PowerCoefficient(i, double.Parse(box.Text)));
}
for (int i = 0; i < EfficiencyTextBoxes.Count(); i++)
{
TextBox box = EfficiencyTextBoxes[i];
pump.EfficiencyCoefficients.Add(new EfficiencyCoefficient(i, double.Parse(box.Text)));
}
pump.Name = NameTB.Text;
pump.BaseFrequency = Convert.ToDouble(TB_BaseFrequency.Text);
pump.ConditionalDimension = ConditionalDimensionComboBox.Text;
pump.NominalRate = Convert.ToDouble(TB_NominalRate.Text);
pump.MinAvailableRate = Convert.ToDouble(TB_MinAvailableRate.Text);
pump.MaxAvailableRate = Convert.ToDouble(TB_MaxAvailableRate.Text);
pump.MinRecomendedRate = Convert.ToDouble(TB_MinRecomendedRate.Text);
pump.MaxRecomendedRate = Convert.ToDouble(TB_MaxRecomendedRate.Text);
}
catch (Exception ex)
{
MessageBox.Show("Ошибка Неправильно задано одно из полей.");
return;
}
this.Hide();
MainWindow.Button_Click_UpdateGrafESN(null, null);
using (PersistanceContext db = new PersistanceContext())
{
db.EspPumps.Add(pump);
db.SaveChanges();
//Обновляем каталог
MainWindow.CatalogEsp = db.EspPumps.Include("PowerCoefficients")
.Include("EfficiencyCoefficients").Include("HeadCoefficients").ToList();
//Отображаем таблицу каталога ЭЦН
MainWindow.ShowESPDataBase();
}
}
/// <summary>
/// Кнопка добавить
/// </summary>
private void Button_Click_OK(Object sender, RoutedEventArgs e)
{
TextBox[] HeadTextBoxes = { TB_HeadX0, TB_HeadX1, TB_HeadX2, TB_HeadX3, TB_HeadX4,
TB_HeadX5, TB_HeadX6, TB_HeadX7, TB_HeadX8, TB_HeadX9 };
TextBox[] PowerTextBoxes = { TB_Power0, TB_Power1, TB_Power2, TB_Power3, TB_Power4,
TB_Power5, TB_Power6, TB_Power7, TB_Power8, TB_Power9 };
TextBox[] EfficiencyTextBoxes = { TB_Efficiency0, TB_Efficiency1, TB_Efficiency2, TB_Efficiency3, TB_Efficiency4,
TB_Efficiency5, TB_Efficiency6, TB_Efficiency7, TB_Efficiency8, TB_Efficiency9 };
ChosenPump.HeadCoefficients.Clear();
ChosenPump.PowerCoefficients.Clear();
ChosenPump.EfficiencyCoefficients.Clear();
for (int i = 0; i < HeadTextBoxes.Count(); i++)
{
TextBox box = HeadTextBoxes[i];
ChosenPump.HeadCoefficients.Add(new HeadCoefficient(i, double.Parse(box.Text)));
}
for (int i = 0; i < PowerTextBoxes.Count(); i++)
{
TextBox box = PowerTextBoxes[i];
ChosenPump.PowerCoefficients.Add(new PowerCoefficient(i, double.Parse(box.Text)));
}
for (int i = 0; i < EfficiencyTextBoxes.Count(); i++)
{
TextBox box = EfficiencyTextBoxes[i];
ChosenPump.EfficiencyCoefficients.Add(new EfficiencyCoefficient(i, double.Parse(box.Text)));
}
ChosenPump.Name = NameTB.Text;
ChosenPump.BaseFrequency = Convert.ToDouble(TB_BaseFrequency.Text);
ChosenPump.ConditionalDimension = ConditionalDimensionComboBox.Text;
ChosenPump.NominalRate = Convert.ToDouble(TB_NominalDischarge.Text);
ChosenPump.MinAvailableRate = Convert.ToDouble(TB_MinAvailableDischarge.Text);
ChosenPump.MaxAvailableRate = Convert.ToDouble(TB_MaxAvailableDischarge.Text);
ChosenPump.MinRecomendedRate = Convert.ToDouble(TB_MinRecomendedDischarge.Text);
ChosenPump.MaxRecomendedRate = Convert.ToDouble(TB_MaxRecomendedDischarge.Text);
this.Hide();
using (PersistanceContext db = new PersistanceContext())
{
ElectricSubmersiblePump espForChange = db.EspPumps.Include("PowerCoefficients")
.Include("EfficiencyCoefficients").Include("HeadCoefficients").Where(esp => esp.Id == ChosenPump.Id).ToList()[0];
db.EspPumps.Remove(espForChange);
espForChange = ChosenPump;
db.EspPumps.Add(espForChange);
db.SaveChanges();
List <ElectricSubmersiblePump> espList = db.EspPumps.Include("PowerCoefficients")
.Include("EfficiencyCoefficients").Include("HeadCoefficients").ToList();
//Обновляем каталог
MainWindow.CatalogEsp = espList;
//Отображаем таблицу каталога ЭЦН
MainWindow.ShowESPDataBase();
}
MainWindow.Button_Click_UpdateGrafESN(null, null);
}
public static void Run()
{
using (PersistanceContext db = new PersistanceContext())
{
db.Database.CreateIfNotExists();
Console.Write("GasFluids: ");
db.GasFluids.Include("GasFluidComponents").Include("GasFluidComponents.ChemicalCompound").ToList().ForEach(delegate(GasFluid fluid)
{
Console.WriteLine(fluid.Id + " " + fluid.GasFluidComponents[0].Name + " " + fluid.GasFluidComponents[0].X);
});
Console.WriteLine("Pumps: ");
db.EspPumps.Include("PowerCoefficients").Include("EfficiencyCoefficients").Include("HeadCoefficients").ToList().ForEach(p =>
{
Console.WriteLine("EsnPump " + p.Id);
Console.WriteLine("N:" + p.Name);
Console.WriteLine("Diameter: " + p.Diameter);
Console.WriteLine("CD: " + p.ConditionalDimension);
Console.WriteLine("BF: " + p.BaseFrequency);
Console.WriteLine("ND: " + p.NominalRate);
Console.Write("E: ");
foreach (EfficiencyCoefficient ec in p.EfficiencyCoefficients)
{
Console.Write(string.Format("{0} - {1};", ec.Order, ec.Value));
}
Console.WriteLine();
Console.Write("P: ");
foreach (PowerCoefficient pc in p.PowerCoefficients)
{
Console.Write(string.Format("{0} - {1};", pc.Order, pc.Value));
}
Console.WriteLine();
Console.Write("H: ");
foreach (HeadCoefficient ec in p.HeadCoefficients)
{
Console.Write(string.Format("{0} - {1};", ec.Order, ec.Value + 1));
}
Console.WriteLine();
});
db.PcpPumps.Include("PowerCoefficients").Include("RateCoefficients").Include("TorqueCoefficients").ToList().ForEach(p =>
{
Console.WriteLine("PcpPump " + p.Id);
Console.WriteLine("N:" + p.Name);
Console.WriteLine("Diameter: " + p.Diameter);
Console.WriteLine("NS:" + p.BaseSpeed);
Console.Write("D: ");
foreach (RateCoefficient dc in p.RateCoefficients)
{
Console.Write(string.Format("{0} - {1};", dc.Order, dc.Value));
}
Console.WriteLine();
Console.Write("P: ");
foreach (PowerCoefficient pc in p.PowerCoefficients)
{
Console.Write(string.Format("{0} - {1};", pc.Order, pc.Value));
}
Console.WriteLine();
Console.Write("H: ");
foreach (TorqueCoefficient tc in p.TorqueCoefficients)
{
Console.Write(string.Format("{0} - {1};", tc.Order, tc.Value + 1));
}
Console.WriteLine();
}
);
}
//using (WateredWellContext db = new WateredWellContext())
//{
// db.WateredWells.ToList().ForEach(delegate (WateredWell well)
// {
// Console.Write(well.Id);
// });
//}
//using (DryWellContext db = new DryWellContext())
//{
// DryLayerContext db1 = new DryLayerContext();
// db1.Database.CreateIfNotExists();
// db.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
// db1.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
// db.Database.CreateIfNotExists();
// DryWell dryWell = new DryWell();
// dryWell.InitTest(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
// db.dryWells.Add(dryWell);
// db.SaveChanges();
// db.dryWells.Include("Layer").ToList().ForEach(delegate (DryWell well)
// {
// Console.WriteLine(well.Id + " " + well.Layer.Id);
// });
//}
//using (DryLayerContext db = new DryLayerContext())
//{
// db.Database.CreateIfNotExists();
// db.dryLayers.ToList().ForEach(delegate (DryLayer layer)
// {
// Console.Write(layer.Id);
// });
//}
}
