public NewOperatieForm(ref IAutoService serviceApi, DetaliuComanda detaliuComanda) { _serviceApi = serviceApi; _detaliuComanda = detaliuComanda; InitializeComponent(); BuildMecanicForm(); }
public void DeleteOrder(int id) { if (!ExistsOrder(id)) { return; } var order = _context.Comenzi.First(c => c.Id == id); DetaliuComanda detaliuComanda = _context.DetaliiComenzi.FirstOrDefault(c => c.ComandaId == order.Id); if (detaliuComanda == null) { return; } ExecuteQuery($"DELETE FROM MaterialDetaliuComanda WHERE DetaliiComenzi_Id = {detaliuComanda.Id};"); ExecuteQuery($"DELETE FROM ImagineDetaliuComanda WHERE DetaliiComenzi_Id = {detaliuComanda.Id};"); ExecuteQuery($"DELETE FROM MecanicDetaliuComanda WHERE DetaliiComenzi_Id = {detaliuComanda.Id};"); ExecuteQuery($"DELETE FROM OperatieDetaliuComanda WHERE DetaliiComenzi_Id = {detaliuComanda.Id};"); detaliuComanda.Materiale.Clear(); detaliuComanda.Imagini.Clear(); detaliuComanda.Mecanici.Clear(); detaliuComanda.Operatii.Clear(); _context.Comenzi.Remove(order); _context.SaveChanges(); }
private void BuildComanda() { try { var imageCounter = 0; var kmBoard = 0; var imagesList = new List <Imagine>(); if (_serviceAutoCheckBox.IsChecked ?? false) { kmBoard = int.Parse(_kmBoardTextBox.Text); } var comanda = new Comanda() { Id = Guid.NewGuid(), Auto = _auto, Client = _auto.Client, DataProgramare = _programDatePicker.DisplayDate.Date, DataSystem = DateTime.Now, Descriere = _commandDescBox.Text, StareComanda = StareComanda.InAsteptare, KmBoard = kmBoard }; foreach (var image in _imaginesList) { var img = new BitmapImage(new Uri(image.Path)); var memStream = new MemoryStream(); var encoder = new JpegBitmapEncoder(); encoder.Frames.Add(BitmapFrame.Create(img)); encoder.Save(memStream); var item = new Imagine() { Id = Guid.NewGuid(), Data = DateTime.Now, Descriere = image.Descriere, Foto = memStream.ToArray(), Titlu = image.Titlu, }; imagesList.Add(item); imageCounter++; } _detaliuComanda = new DetaliuComanda() { Id = Guid.NewGuid(), Comanda = comanda, Imagines = imagesList }; } catch (Exception e) { Console.WriteLine(e); } }
private void createComandaButton_Click(object sender, EventArgs e) { if (stareComandaTexbox.Text == "" || dataProgramareTextbox.Text == "") { MessageBox.Show("Nu s-au completat fieldurile pentru stare comanda si data programare"); return; } Comanda comanda = new Comanda(); DetaliuComanda detaliuComanda = new DetaliuComanda(); detaliuComanda.esteStearsa = "false"; comanda.StareComanda = stareComandaTexbox.Text; comanda.DataSystem = DateTime.Now; comanda.DataProgramare = DateTime.ParseExact(dataProgramareTextbox.Text, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture); comanda.DataFinalizare = DateTime.ParseExact(dataFinalizareTextbox.Text, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture); comanda.KmBord = Int32.Parse(kmBordTextbox.Text); comanda.Descriere = descriereTextbox.Text; comanda.DetaliuComanda = detaliuComanda; auto = autoRepository.GetById(auto.AutoId); auto.Comandas.Add(comanda); autoRepository.Update(auto); MessageBox.Show("Comanda a fost creata cu succes!"); }
public NewOperatiePage(DetaliuComanda detaliuComanda) { InitializeComponent(); _detaliuComanda = detaliuComanda; Mecanics = GetMecanicsData(); Operations = new ObservableCollection <SelectableViewModel <Operatie> >(); DataContext = this; }
public void Create(DetaliuComanda detaliuComanda) { if (detaliuComanda != null) { throw new System.ArgumentNullException(); } detaliuComandaRepository.Add(detaliuComanda); detaliuComandaRepository.Save(); }
public DetaliuComanda Add(DetaliuComanda detaliuComanda) { if (GetById(detaliuComanda.DetaliuComandaId) != null) { return(null); } db.DetaliuComandas.Add(detaliuComanda); db.SaveChanges(); return(detaliuComanda); }
private bool BuildComanda() { try { var kmBoard = 0; var imagesList = new List <Imagine>(); if (serviceAutoCheckBox.Checked) { kmBoard = int.Parse(kmBoardTextBox.Text); } var comanda = new Comanda() { Auto = _auto, Client = _auto.Client, DataProgramare = dataProgramareDatePicker.Value, DataSystem = DateTime.Now, Descriere = descriereComandaBox.Text, StareComanda = StareComanda.InAsteptare, KmBoard = kmBoard }; foreach (var image in _imaginesList) { var img = FromFile(image.Path); var imageStream = new MemoryStream(); img.Save(imageStream, img.RawFormat); imagesList.Add(new Imagine() { Data = DateTime.Now, Descriere = image.Descriere, Foto = imageStream.ToArray(), Titlu = image.Titlu }); } _detaliuComanda = new DetaliuComanda() { Comanda = comanda, Imagines = imagesList }; return(true); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public Boolean Delete(int id) { DetaliuComanda detaliuComanda = db.DetaliuComandas.Find(id); if (detaliuComanda == null) { return(false); } db.DetaliuComandas.Remove(detaliuComanda); db.SaveChanges(); return(true); }
/// <inheritdoc /> /// <summary> /// Creates the detaliu comanda. /// </summary> /// <param name="detaliuComanda">The detaliu comanda.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> public bool CreateDetaliuComanda(DetaliuComanda detaliuComanda) { try { _detaliuComandaWrite = new WriteDetaliuComandaRepository(_context); _detaliuComandaWrite.Create(detaliuComanda); _context.SaveChanges(); return(true); } catch (Exception e) { var message = DbEntityCustomException.BuildMessageExceptions(e); throw new DbEntityCustomException(message); } }
public void Update(DetaliuComanda detaliuComanda) { if (detaliuComanda != null) { throw new System.ArgumentNullException(); } var comanda = detaliuComandaRepository.Where(c => c.Id == detaliuComanda.Id).FirstOrDefault(); comanda.Comanda = detaliuComanda.Comanda == null ? comanda.Comanda : detaliuComanda.Comanda; comanda.Imagines = detaliuComanda.Imagines == null ? comanda.Imagines : detaliuComanda.Imagines; comanda.Materials = detaliuComanda.Materials == null ? comanda.Materials : detaliuComanda.Materials; comanda.Mecanics = detaliuComanda.Mecanics == null ? comanda.Mecanics : detaliuComanda.Mecanics; comanda.Operaties = detaliuComanda.Operaties == null ? comanda.Operaties : detaliuComanda.Operaties; detaliuComandaRepository.Save(); }
public DetaliuComanda Update(DetaliuComanda detaliuComanda) { if (GetById(detaliuComanda.DetaliuComandaId) == null) { return(null); } DetaliuComanda detaliuComanda1 = GetById(detaliuComanda.DetaliuComandaId); detaliuComanda1.Mecanics = detaliuComanda.Mecanics; detaliuComanda1.Imagines = detaliuComanda.Imagines; detaliuComanda1.Comanda = detaliuComanda.Comanda; detaliuComanda1.esteStearsa = detaliuComanda.esteStearsa; db.SaveChanges(); return(detaliuComanda); }
public void CreateNew(DetaliuComandaDto detaliuComandaDto) { if (detaliuComandaDto == null) { throw new ArgumentNullException(nameof(detaliuComandaDto)); } var detaliuComanda = new DetaliuComanda { /*Comanda = detaliuComandaDto.Comanda, * Imagines = detaliuComandaDto.Imagines, * Materials = detaliuComandaDto.Materials, * Mecanici = detaliuComandaDto.Mecanici, * Operaties = detaliuComandaDto.Operaties*/ }; detaliuComandaRepository.Add(detaliuComanda); unitOfWork.Commit(); }
/// <inheritdoc /> /// <summary> /// Adds the mecanics. /// </summary> /// <param name="selectedMecanics">The selected mecanics.</param> /// <param name="detaliuComanda">The detaliu comanda.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> /// <exception cref="DbEntityCustomException"></exception> public bool AddMecanics(List <Mecanic> selectedMecanics, DetaliuComanda detaliuComanda) { try { _detaliuComandaWrite = new WriteDetaliuComandaRepository(context); foreach (var selectedMecanic in selectedMecanics) { detaliuComanda.Mecanici.Add(selectedMecanic); } _detaliuComandaWrite.Update(detaliuComanda); context.SaveChanges(); return(true); } catch (Exception e) { var message = DbEntityCustomException.BuildMessageExceptions(e); throw new DbEntityCustomException(message); } }
/// <inheritdoc /> /// <summary> /// Adds the operatie. /// </summary> /// <param name="operatie">The operatie.</param> /// <param name="detaliuComanda">The detaliu comanda.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> /// <exception cref="DbEntityCustomException"></exception> public bool AddOperatie(Operatie operatie, DetaliuComanda detaliuComanda) { try { _operatieWrite = new WriteOperatieRepository(context); _detaliuComandaWrite = new WriteDetaliuComandaRepository(context); _operatieWrite.Create(operatie); if (detaliuComanda.Operaties == null) { detaliuComanda.Operaties = new List <Operatie>(); } detaliuComanda.Operaties.Add(operatie); _detaliuComandaWrite.Update(detaliuComanda); context.SaveChanges(); return(true); } catch (Exception e) { var message = DbEntityCustomException.BuildMessageExceptions(e); throw new DbEntityCustomException(message); } }
private void AddOrderDetailsButton_OnClick(object sender, RoutedEventArgs e) { List <Material> materials = new List <Material>(); List <Operatie> operations = new List <Operatie>(); List <Mecanic> mechanics = new List <Mecanic>(); List <Imagine> images = new List <Imagine>(); DataRowView selectedRow = (DataRowView)DisplayOrderOrdersDataGrid.SelectedItem; string autoIdText = selectedRow["Id"].ToString(); int orderId = Convert.ToInt32(autoIdText); IList selectedMaterials = DisplayOrderMaterialsDataGrid.SelectedItems; int materialsSize = selectedMaterials.Count; for (var i = 0; i < materialsSize; i++) { DataRowView row = (DataRowView)DisplayOrderMaterialsDataGrid.SelectedItems[i]; string textId = row["Id"].ToString(); Console.WriteLine(textId); // a luat bine int id = Convert.ToInt32(textId); Material material = _client.FindMaterialById(id); _totalCost += material.Pret; material.Cantitate -= 1; _client.UpdateMaterial(material); materials.Add(material); // merge bine foreach (var item in materials) { Console.WriteLine(item.Denumire, material.Id); } } IList selectedOperations = DisplayOrderOperationsDataGrid.SelectedItems; int operationsSize = selectedOperations.Count; for (var i = 0; i < operationsSize; i++) { DataRowView row = (DataRowView)DisplayOrderOperationsDataGrid.SelectedItems[i]; string textId = row["Id"].ToString(); int id = Convert.ToInt32(textId); Operatie operation = _client.FindOperationById(id); operations.Add(operation); } IList selectedMechanics = DisplayOrderMechanicsDataGrid.SelectedItems; int mechanicsSize = selectedMechanics.Count; for (var i = 0; i < mechanicsSize; i++) { DataRowView row = (DataRowView)DisplayOrderMechanicsDataGrid.SelectedItems[i]; string textId = row["Id"].ToString(); int id = Convert.ToInt32(textId); Mecanic mecanic = _client.FindMecanicById(id); mechanics.Add(mecanic); } IList selectedImages = DisplayOrderImagesDataGrid.SelectedItems; int imagesSize = selectedImages.Count; for (var i = 0; i < imagesSize; i++) { DataRowView row = (DataRowView)DisplayOrderImagesDataGrid.SelectedItems[i]; string textId = row["Id"].ToString(); int id = Convert.ToInt32(textId); Imagine image = _client.FindImageById(id); images.Add(image); } DetaliuComanda orderDetails = new DetaliuComanda() { ComandaId = orderId, Imagini = images.ToArray(), Mecanici = mechanics.ToArray(), Materiale = materials.ToArray(), Operatii = operations.ToArray() }; _client.AddOrderDetails(orderDetails); Comanda order = _client.FindOrderById(orderId); order.ValoarePiese = _totalCost + _serviceFee; _client.UpdateOrder(order); }
static void Main(string[] args) { SasiuRepository sasiuRepository = new SasiuRepository(); AutoRepository autoRepository = new AutoRepository(); ClientRepository clientRepository = new ClientRepository(); Sasiu sasiu = new Sasiu(); sasiu.SasiuId = 1; sasiu.CodSasiu = "12"; sasiu.Denumire = "dsfsdfsdf"; //sasiuRepository.Add(sasiu); //sasiuRepository.Update(sasiu); Client client = new Client(); client.Nume = "TestName"; client.Prenume = "TestPrenume"; client.Adresa = "TestAdresa"; client.Localitate = "TestLocali"; client.Judet = "TestJudet"; client.Telefon = "0746653884"; client.Email = "TestEmail"; ////List<Sasiu> sasiuri = sasiuApi.GetSasiuri(); ////foreach (Sasiu sas in sasiuri) ////{ //// Console.WriteLine(sas.Denumire); ////Console.Read(); ////sasiuRepository.UpdateSasiu(2, sasiu); ////sasiuRepository.Delete(2); Auto auto = new Auto(); auto.NumarAuto = "TestNrAuto"; auto.SerieSasiu = "TestSerie"; auto.Sasiu = sasiu; Comanda comanda = new Comanda(); comanda.StareComanda = "TestStareComanda"; comanda.DataSystem = DateTime.Now; comanda.DataProgramare = DateTime.Now; comanda.DataFinalizare = DateTime.Now; comanda.KmBord = 100; comanda.Descriere = "Test Descriere"; comanda.ValoarePiese = 100; Imagine imagine = new Imagine(); imagine.Titlu = "TitluTest"; imagine.Descriere = "TestDescriere"; imagine.Data = DateTime.Now; DetaliuComanda detaliuComanda = new DetaliuComanda(); detaliuComanda.Imagines.Add(imagine); comanda.DetaliuComanda = detaliuComanda; auto.Comandas.Add(comanda); //client.Autoes.Add(auto); client.Autoes.Add(auto); clientRepository.Add(client); //// clientRepository.Delete(1); }
public void AddOrderDetails(DetaliuComanda orderDetails) { _context.DetaliiComenzi.Add(orderDetails); _context.SaveChanges(); }
private static void Main(string[] args) { Console.WriteLine("Test Model Designer First"); var context = new CarServiceModelContainer(); var autoRepository = new AutoRepository(context); var clientRepository = new ClientRepository(context); var comandaRepository = new ComandaRepository(context); var detaliuComandaRepository = new DetaliuComandaRepository(context); var imagineRepository = new ImagineRepository(context); var materialRepository = new MaterialRepository(context); var mecanicRepository = new MecanicRepository(context); var operatieRepository = new OperatieRepository(context); var sasiuRepository = new SasiuRepository(context); ICarService carService = new CarService.Service.impl.CarService(autoRepository, clientRepository, comandaRepository, detaliuComandaRepository, imagineRepository, materialRepository, mecanicRepository, operatieRepository, sasiuRepository); var client = new Client() { Adresa = "Str. Palat", Email = "*****@*****.**", Nume = "Birsan", Prenume = "Ioana", Judet = "Iasi", Localitate = "Iasi", Telefon = "0040784043489" }; // var clientId = carService.AddClient(client); var clientToUpdate = carService.FindClientByEmail("*****@*****.**"); clientToUpdate.Judet = "Suceava"; // carService.UpdateClient(clientToUpdate); var sasiu = new Sasiu() { CodSasiu = "4F", Denumire = "Sasiu Audi" }; var sasiuId = carService.AddSasiu(sasiu); var auto = new Auto() { NumarAuto = "SV120COR", SerieSasiu = " WAUZZZ4FZ6A111222", }; // var autoId = carService.AddAuto(auto, clientToUpdate.Id, sasiuId); var autoToUpdate = carService.FindAutoByNumarAuto("SV120COR"); var detaliuComanda = new DetaliuComanda(); var comanda = new Comanda() { DataProgramare = DateTime.Now, DataFinalizare = DateTime.Today, DataSystem = DateTime.UtcNow, Descriere = "Schimbare placute frana fata", KmBord = 10, ValoarePiese = 100m, DetaliuComanda = detaliuComanda }; // var comandaId = carService.AddComanda(comanda, clientToUpdate.Id); carService.DeleteClient(clientToUpdate.Id); // carService.DeleteAuto(autoToUpdate.Id); var clients = carService.GetAllClients(); foreach (var c in clients) { Console.WriteLine(c.Nume + " " + c.Prenume); } }
public void CreateClientAutoSasiuComandaDetaliuComanda() { try { var newClient = new Client() { Adresa = "Decebal 4", Email = RandomString(15), Judet = "Neamt", Localitate = "Targu Neamt", Nume = "Loghin", Prenume = "Alexandru", Telefon = RandomString(10, true) }; var newSasiu = new Sasiu() { CodSasiu = "2F", Denumire = "Audi 64 BMW" }; var serieSasiu = $"AM0000{newSasiu.CodSasiu}123AS000"; var newAuto = new Auto() { Client = newClient, NumarAuto = RandomString(10), Sasiu = newSasiu, SerieSasiu = serieSasiu }; var comanda = new Comanda() { Auto = newAuto, Client = newAuto.Client, DataProgramare = DateTime.Now.AddDays(Random.Next(1, 20)), DataFinalizare = DateTime.Now.AddDays(Random.Next(20, 40)), DataSystem = DateTime.Now, Descriere = "Reparat motor", StareComanda = (StareComanda)Enum.ToObject(typeof(StareComanda), Random.Next(1, 4)) }; var newDetaliuComanda = new DetaliuComanda() { Comanda = comanda, Operaties = new List <Operatie>() { new Operatie() { Denumire = RandomString(10), TimpExecutie = 12 }, new Operatie() { Denumire = RandomString(10), TimpExecutie = 43 } } }; var response = _autoService.CreateDetaliuComanda(newDetaliuComanda); Assert.IsTrue(response); } catch (Exception e) { Console.WriteLine(e); throw; } }
private void buttonAddDetails_Click(object sender, EventArgs e) { List <Material> materials = new List <Material>(); List <Operatie> operations = new List <Operatie>(); List <Mecanic> mechanics = new List <Mecanic>(); List <Imagine> images = new List <Imagine>(); int index = dataGridViewAddDetailByOrder.CurrentCell.RowIndex; DataGridViewRow selectedRow = dataGridViewAddDetailByOrder.Rows[index]; int orderId = Convert.ToInt32(selectedRow.Cells[0].Value); foreach (DataGridViewRow row in dataGridViewAddDetailsMaterials.SelectedRows) { int id = Convert.ToInt32(row.Cells[0].Value); Material material = _carService.FindMaterialById(id); TotalCost += material.Pret; material.Cantitate -= 1; _carService.UpdateMaterial(material); materials.Add(material); } foreach (DataGridViewRow row in dataGridViewAddDetailsOperations.SelectedRows) { int id = Convert.ToInt32(row.Cells[0].Value); Operatie operation = _carService.FindOperationById(id); operations.Add(operation); } foreach (DataGridViewRow row in dataGridViewAddDetailsMechanics.SelectedRows) { int id = Convert.ToInt32(row.Cells[0].Value); Mecanic mecanic = _carService.FindMecanicById(id); mechanics.Add(mecanic); } foreach (DataGridViewRow row in dataGridViewAddDetailsImages.SelectedRows) { int id = Convert.ToInt32(row.Cells[0].Value); Imagine image = _carService.FindImageById(id); images.Add(image); } DetaliuComanda orderDetails = new DetaliuComanda() { ComandaId = orderId, Imagini = images, Mecanici = mechanics, Materiale = materials, Operatii = operations }; _carService.AddOrderDetails(orderDetails); labelAddDetails.Text = @"Order details added."; labelAddDetails.Visible = true; Comanda order = _carService.FindOrderById(orderId); order.ValoarePiese = TotalCost + ServiceFee; _carService.UpdateOrder(order); }
public DetaliuComanda GetById(int id) { DetaliuComanda detaliuComanda = db.DetaliuComandas.Find(id); return(detaliuComanda); }
public void AddOrderDetails(DetaliuComanda orderDetails) { _api.AddOrderDetails(orderDetails); }