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