public void sistemsRelations(int systemID)
{
// Insert relation of auto and system
string qry_insAutoSystem = "INSERT INTO rel_autos_sist (autos_ID, sistema_ID) VALUES ";
qry_insAutoSystem += "(";
string qry_insAutoSystemMod;
string ID_currentCB;
// insert code for relation of system
foreach (CheckBox cb in stackAutos.Children)
{
// we get the id of the name of each cb, combobox,
// of course we have to know if cb was checked
if (cb.IsChecked.HasValue && cb.IsChecked.Value == true)
{
ID_currentCB = cb.Name.ToString();
ID_currentCB = ID_currentCB.Trim(new char[] { '_' });
// we append to the list of IDS of checked comboboxes
// could not append several insert values so we do one insert at a time
qry_insAutoSystemMod = qry_insAutoSystem + ID_currentCB + ", " + systemID + ")";
MessageBox.Show("QRY: " + qry_insAutoSystemMod);
using (db.setComm(qry_insAutoSystemMod))
{
affectedRows = db.getComm().ExecuteNonQuery();
}
if (affectedRows == 0)
{
db.sendMBandCloseConn("No se pudo crear las relaciones pertinentes de sistemas y autos.");
return;
}
}
}
}
public void autosRelations(int carID)
{
// GET ALL EVENTS SO WE CREATE A
List <int> eventos_IDs = new List <int>();
string qry_getAllEvents = "SELECT ID FROM evento";
using (db.setComm(qry_getAllEvents))
{
db.setReader();
while (db.getReader().Read())
{
eventos_IDs.Add(Convert.ToInt32(db.getReader()["ID"]));
}
}
//EDIT_CAMPOS_FUNCTION REGISTER IN THE TABLE
// SEPARATE IN A FUNCTION
// Insert relation of auto and systems
string qry_insAutoSystem = "INSERT INTO rel_autos_sist (autos_ID, sistema_ID) VALUES ";
qry_insAutoSystem += "(" + carID + ", ";
string qry_insAutoSystemMod;
string ID_currentCB;
// insert code for relation of system
string qry_editcampos = "INSERT INTO edit_campos_funktion ";
qry_editcampos += "(funktion_ID, evento_ID, auto_ID) VALUES (";
string qry_getSysFunktions = "SELECT";
foreach (CheckBox cb in stackSystems.Children)
{
// we get the id of the name of each cb, combobox,
// of course we have to know if cb was checked
if (cb.IsChecked.HasValue && cb.IsChecked.Value == true)
{
// ID OF CURRENT SYSTEM
ID_currentCB = cb.Name.ToString();
ID_currentCB = ID_currentCB.Trim(new char[] { '_' });
// we append to the list of IDS of checked comboboxes
// could not append several insert values so we do one insert each
qry_insAutoSystemMod = qry_insAutoSystem + ID_currentCB + ")";
using (db.setComm(qry_insAutoSystemMod))
{
affectedRows = db.getComm().ExecuteNonQuery();
}
if (affectedRows == 0)
{
db.sendMBandCloseConn("No se pudo crear las relaciones pertinentes de auto y sistemas.");
return;
}
}
}
}
private void deletePermanent(object sender, RoutedEventArgs e)
{
if (RestoreStack.Children.Count < 1)
{
return;
}
if (whichItem != 1)
{
MessageBox.Show("Solo puedes eliminar de manera permanente autos");
return;
}
MessageBoxResult result = MessageBox.Show(
"Estás seguro de eliminar este(os) auto(s) de maner definitiva? Esta accion no se puede revertir.",
"Eliminar Auto Permanente",
MessageBoxButton.YesNoCancel
);
switch (result)
{
case MessageBoxResult.Yes:
string ID_currentCB;
foreach (CheckBox cb in RestoreStack.Children)
{
// we get the id of the name of each cb, combobox,
// of course we have to know if cb was checked
if (cb.IsChecked.HasValue && cb.IsChecked.Value == true)
{
// ID OF CURRENT ITEM
ID_currentCB = cb.Name.ToString();
ID_currentCB = ID_currentCB.Trim(new char[] { '_' });
deleteOnceNForAll(ID_currentCB);
}
}
break;
case MessageBoxResult.No:
MessageBox.Show("Auto(s) no eliminado(s).", "Eliminar Auto Permanente");
break;
case MessageBoxResult.Cancel:
MessageBox.Show("Auto(s) no eliminado(s).", "Eliminar Auto Permanente");
break;
}
fillItems2Edit(qry_getAutos, whichItem);
}
private void Restore(object sender, RoutedEventArgs e)
{
if (RestoreStack.Children.Count < 1)
{
return;
}
string ID_currentCB;
foreach (CheckBox cb in RestoreStack.Children)
{
// we get the id of the name of each cb, combobox,
// of course we have to know if cb was checked
if (cb.IsChecked.HasValue && cb.IsChecked.Value == true)
{
// ID OF CURRENT ITEM
ID_currentCB = cb.Name.ToString();
ID_currentCB = ID_currentCB.Trim(new char[] { '_' });
updateOrDelete(1, ID_currentCB);
}
}
switch (whichItem)
{
case 1:
fillItems2Edit(qry_getAutos, whichItem);
break;
case 2:
fillItems2Edit(qry_getFunciones, whichItem);
break;
case 3:
fillItems2Edit(qry_getSistemas, whichItem);
break;
}
}
