private void button1_Click(object sender, EventArgs e)
{
GOOD_FOODDataSet dataB = parent.getDataBase();
GOOD_FOODDataSet.ComenziRow crow = dataB.Comenzi.NewComenziRow();
crow.id_client = IDClient;
crow.data_comanda = new DateTime();
GOOD_FOODDataSet.SubcomenziRow scrow;
foreach (DataGridViewRow r in Comanda_DataGridView.Rows)
{
int cantitate = 1;
int IDProdus = 0;
foreach (DataGridViewCell cell in r.Cells)
{
if (r.Cells.IndexOf(cell) == 0)
{
foreach (GOOD_FOODDataSet.MeniuRow mr in dataB.Meniu)
{
if (mr.denumire_produs == cell.Value)
{
IDProdus = mr.id_produs;
}
}
}
else if (r.Cells.IndexOf(cell) == 3)
{
cantitate = Convert.ToInt32(cell.Value.ToString());
}
}
scrow = dataB.Subcomenzi.NewSubcomenziRow();
scrow.cantitate = cantitate;
scrow.id_produs = IDProdus;
scrow.id_comanda = crow.id_comanda;
dataB.Subcomenzi.Rows.Add(scrow);
}
dataB.Comenzi.Rows.Add(crow);
parent.updateDataBase();
MessageBox.Show("Comanda trimisa!");
this.Close();
}
private void GenMeniu_GridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 5)
{
DataGridViewRow row = null;
foreach (DataGridViewRow r in GenMeniu_GridView.Rows)
{
if (GenMeniu_GridView.Rows.IndexOf(r) == e.RowIndex)
{
row = r;
break;
}
}
String fel1 = "";
String fel2 = "";
String fel3 = "";
foreach (DataGridViewCell cell in row.Cells)
{
if (row.Cells.IndexOf(cell) == 0)
{
fel1 = cell.Value.ToString();
}
else if (row.Cells.IndexOf(cell) == 1)
{
fel2 = cell.Value.ToString();
}
else if (row.Cells.IndexOf(cell) == 2)
{
fel3 = cell.Value.ToString();
}
}
int idProd1 = 1;
int idProd2 = 2;
int idProd3 = 3;
GOOD_FOODDataSet dataB = parent.getDataBase();
foreach (GOOD_FOODDataSet.MeniuRow mr in dataB.Meniu)
{
if (mr.denumire_produs == fel1)
{
idProd1 = mr.id_produs;
}
if (mr.denumire_produs == fel2)
{
idProd2 = mr.id_produs;
}
if (mr.denumire_produs == fel3)
{
idProd3 = mr.id_produs;
}
}
GOOD_FOODDataSet.ComenziRow crow = dataB.Comenzi.NewComenziRow();
crow.id_client = userID;
crow.data_comanda = new DateTime();
GOOD_FOODDataSet.SubcomenziRow scrow = dataB.Subcomenzi.NewSubcomenziRow();
scrow.cantitate = 1;
scrow.id_produs = idProd1;
scrow.id_comanda = crow.id_comanda;
dataB.Subcomenzi.Rows.Add(scrow);
scrow = dataB.Subcomenzi.NewSubcomenziRow();
scrow.cantitate = 1;
scrow.id_produs = idProd2;
scrow.id_comanda = crow.id_comanda;
dataB.Subcomenzi.Rows.Add(scrow);
scrow = dataB.Subcomenzi.NewSubcomenziRow();
scrow.cantitate = 1;
scrow.id_produs = idProd3;
scrow.id_comanda = crow.id_comanda;
dataB.Subcomenzi.Rows.Add(scrow);
dataB.Comenzi.Rows.Add(crow);
parent.updateDataBase();
MessageBox.Show("Comanda trimisa!");
this.Close();
}
}