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