public void UpdateDetaliiComandaPentruComanda(DetaliiComanda detaliiComanda1, DetaliiComanda detaliiComanda2)
{
if (detaliiComanda1 == null || detaliiComanda2 == null)
{
return;
}
var foundDetails =
Context.DetaliiComandas.FirstOrDefault(m => m.DetaliiComandaId == detaliiComanda1.DetaliiComandaId);
if (foundDetails != null)
{
foundDetails.AutoId = detaliiComanda2.AutoId;
foundDetails.MecanicId = detaliiComanda2.MecanicId;
foundDetails.OperatieId = detaliiComanda2.OperatieId;
foundDetails.ImagineId = detaliiComanda2.ImagineId;
foundDetails.ComandaId = detaliiComanda2.ComandaId;
}
else
{
return;
}
Context.DetaliiComandas.AddOrUpdate(foundDetails);
Context.SaveChanges();
}
private void saveOrderDetailsButton_Click(object sender, EventArgs e)
{
if (addedMechanics.Count() == 0)
{
MessageBox.Show("You need at least one mechanic");
}
else if (addedOperations.Count() == 0)
{
MessageBox.Show("You need at least one operation");
}
foreach (MechanicModel mechanic in addedMechanics)
{
foreach (OperationModel operation in addedOperations)
{
DetaliiComanda orderDetails = new DetaliiComanda
{
ComandaId = clonedSessionData.selectedOrder.ComandaId,
AutoId = clonedSessionData.selectedAuto.AutoId,
MecanicId = mechanic.MechanicId,
OperatieId = operation.OperationId,
ImagineId = 2
};
clonedSessionData.orderRepository.AddOrderDetailsForOrder(orderDetails);
}
}
}
public static List <Object> createListOfObjects(string query, string tip)
{
List <Object> list = new List <Object>();
MySqlConnection conn = ConnectionFactory.getConnection();
cmd.Connection = conn;
cmd.CommandText = query;
try
{
conn.Open();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Object o = null;
if (tip == "Cont")
{
o = new Cont(Convert.ToString(rdr["username"]), Convert.ToString(rdr["pass"]), Convert.ToChar(rdr["rol"]));
}
else if (tip == "CategoriiProdus")
{
o = new CategoriiProdus(Convert.ToString(rdr["categorie"]));
}
else if (tip == "Client")
{
o = new Client(Convert.ToInt32(rdr["idClient"]), Convert.ToString(rdr["username"]), Convert.ToString(rdr["nume"]), Convert.ToString(rdr["prenume"]), Convert.ToString(rdr["cnp"]), Convert.ToString(rdr["adresaLivrare"]), Convert.ToString(rdr["nrTelefon"]), Convert.ToString(rdr["email"]), Convert.ToChar(rdr["eClientLoial"]));
}
else if (tip == "Comanda")
{
o = new Comanda(Convert.ToInt32(rdr["idComanda"]), Convert.ToInt32(rdr["idClient"]), Convert.ToString(rdr["dataComanda"]), Convert.ToDouble(rdr["pretTotal"]), Convert.ToString(rdr["modalitatePlata"]));
}
else if (tip == "DetaliiComanda")
{
o = new DetaliiComanda(Convert.ToInt32(rdr["idComanda"]), Convert.ToString(rdr["numeProdus"]), Convert.ToDouble(rdr["pret"]), Convert.ToInt32(rdr["cantitate"]));
}
else if (tip == "Produs")
{
o = new Produs(Convert.ToInt32(rdr["idProdus"]), Convert.ToString(rdr["categorie"]), Convert.ToString(rdr["nume"]), Convert.ToString(rdr["descriere"]), Convert.ToInt32(rdr["gramaj"]), Convert.ToDouble(rdr["pret"]));
}
list.Add(o);
}
rdr.Close();
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.ToString());
}
finally
{
ConnectionFactory.close(conn);
}
return(list);
}
public static void MergeOrderDetailsEntity(DetaliiComanda orderDetailsDb, DetaliiComanda orderDetailsFound)
{
orderDetailsDb.ComandaId = orderDetailsFound.ComandaId;
orderDetailsDb.AutoId = orderDetailsFound.AutoId;
orderDetailsDb.MecanicId = orderDetailsFound.MecanicId;
orderDetailsDb.OperatieId = orderDetailsFound.OperatieId;
orderDetailsDb.ImagineId = orderDetailsFound.ImagineId;
}
public void AddDetaliiComandaPentruComannda(DetaliiComanda detaliiComanda)
{
if (detaliiComanda == null)
{
return;
}
Context.DetaliiComandas.Add(detaliiComanda);
Context.SaveChanges();
}
public void AddOrderDetailsForOrder(DetaliiComanda orderDetails)
{
var orderDetailsToAdd = new DetaliiComanda
{
ComandaId = orderDetails.ComandaId,
AutoId = orderDetails.AutoId,
MecanicId = orderDetails.MecanicId,
OperatieId = orderDetails.OperatieId,
ImagineId = orderDetails.ImagineId == null ? 0 : orderDetails.ImagineId
};
_applicationContext.DetaliiComandas.Add(orderDetailsToAdd);
_applicationContext.SaveChanges();
}
public void DeleteDetaliiComandaPentruComanda(Comanda comanda, DetaliiComanda detaliiComanda)
{
if (detaliiComanda == null)
{
return;
}
var detaliiComandaGasit = Context.DetaliiComandas.FirstOrDefault(m => m.ComandaId == detaliiComanda.ComandaId);
if (detaliiComandaGasit == null)
{
return;
}
Context.DetaliiComandas.Remove(detaliiComanda);
Context.SaveChanges();
}
private void comanda_Click(object sender, RoutedEventArgs e)
{
if ((bool)cash.IsChecked || (bool)card.IsChecked)
{
string modalitatePlata = ((bool)cash.IsChecked) == true ? "cash" : "card";
string data = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Comanda comanda = new Comanda(0, client.IdClient, data, pretTotal, modalitatePlata);
try
{
ComandaBLL.insertComanda(comanda);
comanda = (Comanda)ComandaBLL.selectComanda(comanda);
//MessageBox.Show(comanda.ToString());
DetaliiComandaBLL detaliiComandaBLL = new DetaliiComandaBLL();
for (int i = 0; i < produseCos.Count; i++)
{
DetaliiComanda dc = new DetaliiComanda(comanda.IdComanda, produseCos[i].Nume, produseCos[i].Pret, cantitateProdusCos[i]);
//MessageBox.Show(dc.ToString());
detaliiComandaBLL.insertDetaliiComanda(dc);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
produseCos.Clear();
cantitateProdusCos.Clear();
deseneazaCos();
MessageBox.Show("Cosul de cumparaturi a fost inregistrat");
//MessageBox.Show(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
MessageBox.Show("Nu ati ales modalitatea de plata!");
}
}
public static void insertDetaliuComanda(DetaliiComanda dc)
{
string query = "insert into DetaliiComanda values (" + dc.IdComanda + ", '" + dc.NumeProdus + "', '" + dc.Pret.ToString().Replace(',', '.') + "', " + dc.Cantitate + ");";
//System.Windows.MessageBox.Show(query);
MySqlConnection conn = ConnectionFactory.getConnection();
cmd.Connection = conn;
cmd.CommandText = query;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.ToString());
}
finally
{
ConnectionFactory.close(conn);
}
}
public void selectDetaliiComanda(DetaliiComanda dc)
{
ReflectionDAO.select(dc, "DetaliiComanda");
}
public void insertDetaliiComanda(DetaliiComanda dc)
{
DetaliiComandaDAO.insertDetaliuComanda(dc);
}
public void AddOrderDetailsForOrder(DetaliiComanda orderDetail)
{
orderRepository.AddOrderDetailsForOrder(orderDetail);
}
