private void btnUpdate_Click(object sender, RoutedEventArgs e) { if (lvManuf.SelectedIndex >= 0) { newEquipment ne = (newEquipment)lvManuf.SelectedItem; foreach (var item in db.newEquipment) { if (item.intManufacturerID == ne.intManufacturerID && item.intModelID == ne.intModelID && item.intLocationId == ne.intLocationId && item.intGarageRoom == ne.intGarageRoom && item.strManufYear == ne.strManufYear && item.strSerialNo == ne.strSerialNo && item.intMetered == ne.intMetered && item.LastDate == ne.LastDate) { item.intManufacturerID = (int)intManufacturerID.SelectedItem; item.intModelID = (int)intModelID.SelectedItem; item.intLocationId = (int)intLocationId.SelectedItem; item.intGarageRoom = intGarageRoom.Text; //50 chisel item.strManufYear = strManufYear.Text; //4 chisla item.strSerialNo = strSerialNo.Text; //20 chisel item.intMetered = Convert.ToDouble(intMetered.Text); item.LastDate = Convert.ToDateTime(LastDate.Text); if (CreateDate.Text != null) { item.CreateDate = Convert.ToDateTime(CreateDate.Text); } break; } } db.SaveChanges(); lvManuf.ItemsSource = db.newEquipment.ToList(); } }
private void LookInfo_Click(object sender, RoutedEventArgs e) { newEquipment equipment = (newEquipment)CarsList.SelectedItem; LookInfo page = new LookInfo(equipment); MainWindow.cframe.NavigationService.Navigate(page); }
private void MainTable_SelectionChanged(object sender, SelectionChangedEventArgs e) { newEquipment g = MainTable.SelectedItem as newEquipment; Report report = new Report(g); MainWindow.MF.NavigationService.Navigate(report); }
public ActionResult DeleteConfirmed(int id) { newEquipment newEquipment = db.newEquipments.Find(id); db.newEquipments.Remove(newEquipment); db.SaveChanges(); return(RedirectToAction("Index")); }
//First, FirstOfDefault public static void Exm10() { newEquipment query = db.newEquipment.First(); Console.WriteLine(query); newEquipment query2 = db.newEquipment.FirstOrDefault(f => f.intEquipmentID == 2352452); Console.WriteLine(query); }
public Report(newEquipment g) { InitializeComponent(); ReportBind.DataContext = g; if (g.bitActive) { bitActive.Foreground = new SolidColorBrush(Colors.Green); bitActive.Content = "Активная;"; } else { bitActive.Foreground = new SolidColorBrush(Colors.Red); bitActive.Content = "Не активная;"; } if (g.bitKTG) { bitKTG.Foreground = new SolidColorBrush(Colors.Green); bitKTG.Content = "Участвует при расчете КТГ;"; } else { bitKTG.Foreground = new SolidColorBrush(Colors.Red); bitKTG.Content = "Не участвует при расчете КТГ;"; } if (g.bitMeter) { bitMeter.Foreground = new SolidColorBrush(Colors.Green); bitMeter.Content = "Участвует в расчете мото-часов;"; } else { bitMeter.Foreground = new SolidColorBrush(Colors.Red); bitMeter.Content = "Не участвует в расчете мото-часов;"; } List <TableSelect> tableSelect = new List <TableSelect>(); var joinTabs = (from ne in db.newEquipment join tm in db.TrackMeter on ne.intEquipmentID equals tm.intEquipmentID where ne.intGarageRoom == g.intGarageRoom select new { intGarageRoom = ne.intGarageRoom, dMeterDate = tm.dMeterDate, intMeterReading = tm.intMeterReading, intTotalMeter = tm.intTotalMeter }) .ToList(); foreach (var jt in joinTabs) { TableSelect tableSelects = new TableSelect(); tableSelects.intGarageRoom = jt.intGarageRoom; tableSelects.dMeterDate = jt.dMeterDate; tableSelects.intMeterReading = jt.intMeterReading; tableSelects.intTotalMeter = Convert.ToDouble(jt.intTotalMeter); tableSelect.Add(tableSelects); } TableMeters.ItemsSource = tableSelect; }
public void Set_Data(int ManID, int ModID, int locID) { try { using (MCSEntities db = new MCSEntities()) { newEquipment Eq = new newEquipment { //intEquipmentID = 847, //[intEquipmentID] [int] IDENTITY(1,1) NOT NULL, intGarageRoom = null, //[intGarageRoom] [nvarchar](50) NULL, intManufacturerID = ManID, //[intManufacturerID] [int] NOT NULL, intModelID = ModID, //**** //[intModelID] [int] NOT NULL, strManufYear = DateTime.Now.Year.ToString(), //[strManufYear] [nvarchar](4) NULL, intSNPrefixID = (int)DateTime.Now.Second, //[intSNPrefixID] [int] NOT NULL, strSerialNo = null, //[strSerialNo] [nvarchar](20) NULL, intEquipmentTypeID = (new Random()).Next(1, 999), //[intEquipmentTypeID] [int] NOT NULL, intSMCSFamilyID = (new Random()).Next(1, 999), //[intSMCSFamilyID] [int] NOT NULL, intSizeID = (new Random()).Next(300, 9999), //[intSizeID] [int] NOT NULL, CreateDate = null, //[CreateDate] [date] NULL, intMetered = ((double)(new Random()).Next(1000, 9999)) / 100, //[intMetered] [float] NOT NULL, LastDate = DateTime.Now, //[LastDate] [date] NOT NULL, intLastMetered = ((double)(new Random()).Next(1000, 9999)) / 100, //[intLastMetered] [float] NOT NULL, intTotalMetered = ((double)(new Random()).Next(1000, 9999)) / 100, //[intTotalMetered] [float] NOT NULL, intlimitDay = (new Random()).Next(1, 30), //[intlimitDay] [int] NULL, intlimitWeek = (new Random()).Next(1, 7), //[intlimitWeek] [int] NULL, bitActive = Convert.ToBoolean((new Random()).Next(0, 1)), //[bitActive] [bit] NOT NULL, bitPreservation = Convert.ToBoolean((new Random()).Next(0, 1)), //[bitPreservation] [bit] NOT NULL, bitMeter = Convert.ToBoolean((new Random()).Next(0, 1)), //[bitMeter] [bit] NOT NULL, bitKTG = Convert.ToBoolean((new Random()).Next(0, 1)), //[bitKTG] [bit] NOT NULL, isDelete = Convert.ToBoolean((new Random()).Next(0, 1)), //[isDelete] [bit] NOT NULL CONSTRAINT [DF_newEquipment_isDelete] DEFAULT ((0)), intLocationId = locID, //[intLocationId] [int] NOT NULL, strDescription = null, //[strDescription] [nvarchar](1050) NULL, floatCostTires = null, //[floatCostTires] [float] NULL, intCostTiresCurrency = null, //[intCostTiresCurrency] [int] NULL, floatAverageDivergence = null, //[floatAverageDivergence] [float] NULL, floatFullPrice = null, //[floatFullPrice] [float] NULL, intFullPriceCurrency = null, //[intFullPriceCurrency] [int] NULL, dateStartUpDate = null, //[dateStartUpDate] [date] NULL, intServiceLife = null, //[intServiceLife] [int] NULL, intHoweverOddsAcceleration = null, //[intHoweverOddsAcceleration] [int] NULL, bitMethodAmortization = true //[bitMethodAmortization] [bit] NOT NULL, //TablesLocation = null, //TablesManufacturer = null, //TablesModel = null }; db.newEquipment.Add(Eq); db.SaveChanges(); MessageBox.Show("Данные записаны"); } } catch (Exception) { MessageBox.Show("Невозможно записать данные"); } }
public async Task <ActionResult> GetTrackMeterByEquipmentId(int equipmentId) { newEquipment query = await db.newEquipments.FirstOrDefaultAsync(w => w.intEquipmentID == equipmentId); if (query == null) { return(HttpNotFound()); } Thread.Sleep(new Random().Next(4000)); return(PartialView("NewEquipmentPartial", query)); }
public ActionResult Edit([Bind(Include = "intEquipmentID,intGarageRoom,intManufacturerID,intModelID,strManufYear,intSNPrefixID,strSerialNo,intEquipmentTypeID,intSMCSFamilyID,intSizeID,CreateDate,intMetered,LastDate,intLastMetered,intTotalMetered,intlimitDay,intlimitWeek,bitActive,bitPreservation,bitMeter,bitKTG,isDelete,intLocationId,strDescription,floatCostTires,intCostTiresCurrency,floatAverageDivergence,floatFullPrice,intFullPriceCurrency,dateStartUpDate,intServiceLife,intHoweverOddsAcceleration,bitMethodAmortization")] newEquipment newEquipment) { if (ModelState.IsValid) { db.Entry(newEquipment).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.intManufacturerID = new SelectList(db.TablesManufacturers, "intManufacturerID", "strManufacturerChecklistId", newEquipment.intManufacturerID); ViewBag.intModelID = new SelectList(db.TablesModels, "intModelID", "strName", newEquipment.intModelID); return(View(newEquipment)); }
public LookInfo(newEquipment equipment) { InitializeComponent(); string model = db.TablesModel.ToList().Find(x => x.intModelID == equipment.intModelID).strName; tbxHeader.Text = equipment.intGarageRoom + "/" + model; tbxUnHeader.Text = equipment.CreateDate.ToString(); tbxManuf.Text = db.TablesManufacturer.ToList().Find(x => x.intManufacturerID == equipment.intManufacturerID).strName; tbxModel.Text = db.TablesModel.ToList().Find(x => x.intModelID == equipment.intModelID).strName; tbxYear.Text = equipment.strManufYear; tbxNumber.Text = equipment.strSerialNo; tbxGroup.Text = equipment.intServiceLife.ToString(); tbxModif.Text = db.TablesEquipmentType.ToList().Find(x => x.intEquipmentTypeId == equipment.intEquipmentTypeID).strUnits; tbxSMSC.Text = db.TablesSMCSFamily.ToList().Find(x => x.intSMCSFamilyID == equipment.intSMCSFamilyID).strName; tbxSize.Text = db.TablesSize.ToList().Find(x => x.intSizeID == equipment.intSizeID).strSize; tbxDay.Text = equipment.intlimitDay.ToString(); tbxWeek.Text = equipment.intlimitWeek.ToString(); if (equipment.bitActive == true) { tbxStatus.Text = "Активная; "; tbxStatus.Foreground = new SolidColorBrush(Colors.Green); } else { tbxStatus.Text = "Не активная; "; tbxStatus.Foreground = new SolidColorBrush(Colors.Red); } if (equipment.bitKTG == true) { tbxStatus.Text = tbxStatus.Text + "Учавствует при расчете КТГ; "; tbxStatus.Foreground = new SolidColorBrush(Colors.Green); } else { tbxStatus.Text = tbxStatus.Text + "Не учавствует при расчете КТГ; "; tbxStatus.Foreground = new SolidColorBrush(Colors.Red); } if (equipment.bitMeter == true) { tbxStatus.Text = tbxStatus.Text + "Учавствует в расчете мото-часов; "; tbxStatus.Foreground = new SolidColorBrush(Colors.Green); } else { tbxStatus.Text = tbxStatus.Text + "Не учавствует в расчете мото-часов; "; tbxStatus.Foreground = new SolidColorBrush(Colors.Red); } }
// GET: newEquipments/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } newEquipment newEquipment = db.newEquipments.Find(id); if (newEquipment == null) { return(HttpNotFound()); } return(View(newEquipment)); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { newEquipment ne = (newEquipment)lvManuf.SelectedItem; if (ne != null) { db.newEquipment.Remove(ne); db.SaveChanges(); lvManuf.ItemsSource = db.newEquipment.ToList(); } else { MessageBox.Show("Please select the item you want to delete"); } }
// GET: newEquipments/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } newEquipment newEquipment = db.newEquipments.Find(id); if (newEquipment == null) { return(HttpNotFound()); } ViewBag.intManufacturerID = new SelectList(db.TablesManufacturers, "intManufacturerID", "strManufacturerChecklistId", newEquipment.intManufacturerID); ViewBag.intModelID = new SelectList(db.TablesModels, "intModelID", "strName", newEquipment.intModelID); return(View(newEquipment)); }
public static void MyConnection(bool x) { newEquipments = new List <newEquipment>(); DbProviderFactory provider; DbConnection con; if (x) { string factory = ConfigurationManager.AppSettings["factorySQL"]; provider = DbProviderFactories.GetFactory(factory); con = provider.CreateConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnectionSQL"].ConnectionString; } else { string factory = ConfigurationManager.AppSettings["factoryOLEDB"]; provider = DbProviderFactories.GetFactory(factory); con = provider.CreateConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnectionOLEDB"].ConnectionString; } //Создать команду DbCommand cmd = provider.CreateCommand(); cmd.CommandText = ConfigurationManager.AppSettings["newEquipment"]; cmd.Connection = con; //Открыть соединение и получить данные using (con) { con.Open(); DbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { newEquipment equipment = new newEquipment(); equipment.intEquipmentID = Convert.ToInt32(reader["intEquipmentID"]); equipment.intGarageRoom = reader["intGarageRoom"].ToString(); equipment.intManufacturerID = Convert.ToInt32(reader["intManufacturerID"]); equipment.intModelID = Convert.ToInt32(reader["intModelID"]); equipment.strManufYear = reader["strManufYear"].ToString(); equipment.strSerialNo = reader["strSerialNo"].ToString(); newEquipments.Add(equipment); } } }
private void lvManuf_SelectionChanged(object sender, SelectionChangedEventArgs e) { newEquipment ne = (newEquipment)lvManuf.SelectedItem; if (ne != null) { intManufacturerID.SelectedItem = ne.intManufacturerID; intModelID.SelectedItem = ne.intModelID; intLocationId.SelectedItem = ne.intLocationId; intGarageRoom.Text = ne.intGarageRoom; strManufYear.Text = ne.strManufYear; strSerialNo.Text = ne.strSerialNo; intMetered.Text = ne.intMetered.ToString(); LastDate.Text = ne.LastDate.ToString(); CreateDate.Text = ne.CreateDate.ToString(); } }
private void Button_Click_1(object sender, RoutedEventArgs e) { newEquipment equipment = new newEquipment(); equipment.intGarageRoom = lbintGarageRoom.Text; equipment.intManufacturerID = ((TablesManufacturer)lbManufacturer.SelectedItem).intManufacturerID; equipment.intModelID = ((TablesModel)lbModel.SelectedItem).intModelID; equipment.strManufYear = lbstrManufYear.Text; equipment.intSNPrefixID = ((TablesSNPrefix)lbPrefix.SelectedItem).intSNPrefixID; equipment.strSerialNo = lbstrSerialNo.Text; equipment.LastDate = Convert.ToDateTime(lbLastDate.SelectedDate); Double.TryParse(lbintLastMetered.Text, out double lm); equipment.intLastMetered = lm; Int32.TryParse(lbintTotalMetered.Text, out int tm); equipment.intTotalMetered = tm; equipment.bitActive = Convert.ToBoolean(chbbitActive.IsChecked); equipment.bitKTG = Convert.ToBoolean(chbbitKTG.IsChecked); equipment.bitPreservation = Convert.ToBoolean(chbbitPreservation.IsChecked); equipment.bitMeter = Convert.ToBoolean(chbbitMeter.IsChecked); equipment.bitMethodAmortization = Convert.ToBoolean(chbbitMethodAmortization.IsChecked); Double.TryParse(lbfloatFullPrice.Text, out double fp); equipment.floatFullPrice = fp; Int32.TryParse(lbintServiceLife.Text, out int sf); equipment.intServiceLife = sf; Int32.TryParse(lbintHoweverOddsAcceleration.Text, out int hoa); equipment.intHoweverOddsAcceleration = hoa; equipment.dateStartUpDate = Convert.ToDateTime(lbdateStartUpDate.SelectedDate); try { ModelEntity db = new ModelEntity(); db.newEquipment.Add(equipment); db.SaveChanges(); MessageBox.Show("Автомобиль добавлен успешно!"); } catch (Exception ex) { MessageBox.Show("Автомобиль не добавлен: " + ex.Message); } }
private void btnCreate_Click(object sender, RoutedEventArgs e) { if (intManufacturerID.SelectedItem != null && intModelID.SelectedItem != null && intLocationId.SelectedItem != null) { newEquipment newEquip = new newEquipment(); newEquip.intManufacturerID = (int)intManufacturerID.SelectedItem; newEquip.intModelID = (int)intModelID.SelectedItem; newEquip.intLocationId = (int)intLocationId.SelectedItem; newEquip.intGarageRoom = intGarageRoom.Text; //50 chisel newEquip.strManufYear = strManufYear.Text; //4 chisla newEquip.strSerialNo = strSerialNo.Text; //20 chisel newEquip.intMetered = Convert.ToDouble(intMetered.Text); newEquip.LastDate = Convert.ToDateTime(LastDate.Text); if (CreateDate.Text != null) { newEquip.CreateDate = Convert.ToDateTime(CreateDate.Text); } db.newEquipment.Add(newEquip); db.SaveChanges(); lvManuf.ItemsSource = db.newEquipment.ToList(); } else { if (intManufacturerID.SelectedItem == null) { MessageBox.Show("FIll Manufacturer ID"); } else if (intModelID.SelectedItem == null) { MessageBox.Show("FIll intModelID"); } else if (intLocationId.SelectedItem == null) { MessageBox.Show("FIll intLocationId"); } } }
public Report(newEquipment g) { InitializeComponent(); TableTrackMeter.ItemsSource = db.TrackMeters.ToList(); ReportBind.DataContext = g; }
private void Submit_Click(object sender, RoutedEventArgs e) { newEquipment addingEquipment = new newEquipment(); //проверка номера гаража if (!String.IsNullOrEmpty(RoomNumber.Text)) { addingEquipment.intGarageRoom = RoomNumber.Text; } else { AddToStatusInFo("Введите номер гаража!"); goto spotWhereNothingHappens; } //провера производителя if (Manufacturer.Text != "Выберете") { foreach (var item in MainWindow.ManufacturerList) { if (item.strName == Manufacturer.Text) { addingEquipment.intManufacturerID = item.intManufacturerID; break; } } } else { AddToStatusInFo("Выберете производителя!"); goto spotWhereNothingHappens; } //проверка модели if (Model.Text != "Выберете") { foreach (var item in MainWindow.ModelList) { if (item.strName == Model.Text) { addingEquipment.intModelID = item.intModelID; break; } } } else { AddToStatusInFo("Выберете модель!"); goto spotWhereNothingHappens; } //проверка года выпуска int year; Int32.TryParse(Year.Text, out year); if (Int32.TryParse(Year.Text, out year) && year > 1900 && year < DateTime.Now.Year) { addingEquipment.strManufYear = Year.Text; } else { AddToStatusInFo("Введите коррекный год выпуска!"); goto spotWhereNothingHappens; } //проверка префикса if (Prefix.Text != "Выберете") { foreach (var item in MainWindow.PrefixList) { if (item.strPrefix == Prefix.Text) { addingEquipment.intSNPrefixID = item.intSNPrefixID; break; } } } else { AddToStatusInFo("Выберете префикс!"); goto spotWhereNothingHappens; } //проверка серийного номера if (String.IsNullOrEmpty(Serial.Text)) { AddToStatusInFo("Введите серийный номер!"); goto spotWhereNothingHappens; } else { foreach (var item in MainWindow.newEquipmentList) { if (item.strSerialNo == Serial.Text) { AddToStatusInFo("Такой серийный номер уже существует!"); goto spotWhereNothingHappens; } } addingEquipment.strSerialNo = Serial.Text; } //проверка моточасов double lMoto; double tMoto; if (!Double.TryParse(LastMeter.Text, out lMoto)) { AddToStatusInFo("В последние моточасы введено не число!"); goto spotWhereNothingHappens; } if (!Double.TryParse(TotalMeter.Text, out tMoto)) { AddToStatusInFo("В общие моточасы введено не число!"); goto spotWhereNothingHappens; } if (lMoto > tMoto) { AddToStatusInFo("Последние моточасы не могут быть больше всех моточасов!"); goto spotWhereNothingHappens; } addingEquipment.intLastMetered = lMoto; addingEquipment.intTotalMetered = tMoto; addingEquipment.bitActive = (bool)IsActive.IsChecked; addingEquipment.bitKTG = (bool)IsKTG.IsChecked; addingEquipment.bitPreservation = (bool)IsPreserved.IsChecked; addingEquipment.bitMeter = (bool)IsMetered.IsChecked; addingEquipment.bitMethodAmortization = (bool)AmortType.IsChecked; //проверка стоимости double price; if (Double.TryParse(Price.Text, out price) && price > 0) { addingEquipment.floatFullPrice = price; } else { AddToStatusInFo("Введите коррекную стоимость машины!"); goto spotWhereNothingHappens; } //проверка срока службы int lCycle; if (Int32.TryParse(LifeCycle.Text, out lCycle) && lCycle > 0) { addingEquipment.intServiceLife = lCycle; } else { AddToStatusInFo("Введите коррекный срок службы машины!"); goto spotWhereNothingHappens; } MainWindow.DataBase.newEquipment.Add(addingEquipment); MainWindow.DataBase.SaveChanges(); MainWindow.MainFrame.Source = new Uri(@"MainFraimPages\EverithingIsGood.xaml", UriKind.RelativeOrAbsolute); spotWhereNothingHappens :; }