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 :;
}
