private void MeniuAdministrator_AdaugarePersoanl_Load(object sender, EventArgs e)
{
cboFunctie.SelectedIndex = 0;
conn = conectare.ConectareBazDate();
dataGridView1.Hide();
btnStergerePersonal.Hide();
}
private void btnInapoi_Click(object sender, EventArgs e)
{
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
OleDbCommand cmdSelect;
OleDbDataReader reader;
conn.Open();
cmdSelect = new OleDbCommand("SELECT Rol FROM Conturi where Conturi.idCont = @idCont", conn);
cmdSelect.Parameters.AddWithValue("@idCont", Cont);
reader = cmdSelect.ExecuteReader();
reader.Read();
if (reader.GetValue(0).ToString() == "Administrator")
{
this.Hide();
var meniu = new MeniuAdministrator(Cont);
meniu.ShowDialog();
this.Close();
}
else
{
if (reader.GetValue(0).ToString() == "Personal Hotel")
{
this.Hide();
var meniu = new MeniuPersonalHotel(Cont);
meniu.ShowDialog();
this.Close();
}
else
{
if (reader.GetValue(0).ToString() == "Personal Restaurant")
{
this.Hide();
var meniu = new MeniuPersonalRestaurant(Cont);
meniu.ShowDialog();
this.Close();
}
else
{
if (reader.GetValue(0).ToString() == "ResponsabilEvenimente")
{
this.Hide();
var meniu = new MeniuResponsabilEvenimente(Cont);
meniu.ShowDialog();
this.Close();
}
}
}
}
}
private void MeniuResponsabilEvenimente_Load(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
conn.Open();
OleDbCommand cmdSelectNume;
OleDbDataReader readerNume;
// verificarea existentei user-ului
cmdSelectNume = new OleDbCommand("SELECT Nume FROM DetaliiCont where DetaliiCont.idCont = @idCont", conn);
cmdSelectNume.Parameters.AddWithValue("@idCont", this.cont);
readerNume = cmdSelectNume.ExecuteReader();
readerNume.Read();
lblNume.Text = Convert.ToString(readerNume.GetValue(0));
int i = 0;
dataGridView1.ColumnCount = 7;
dataGridView1.Columns[0].Name = "Nr";
dataGridView1.Columns[1].Name = "Tip Eveniment";
dataGridView1.Columns[2].Name = "Locatie";
dataGridView1.Columns[3].Name = "Data-Ora";
dataGridView1.Columns[4].Name = "Perioada desfasurare";
dataGridView1.Columns[5].Name = "Aprobare";
dataGridView1.Columns[6].Name = "Id";
dataGridView1.Columns[6].Visible = false;
OleDbCommand cmdSelect, cmdSelect2;
OleDbDataReader reader, reader2;
cmdSelect = new OleDbCommand("Select idSolicitare, idCont,idLocatie,TipEveniment, BeneficiiLimuzina, BeneficiiMuzica,BeneficiiAranjamentFloral, BeneficiiDansatori,BeneficiiAranjamentBaloane, BeneficiiAnimatori, Specificatii, Data, PerioadaDesfasurare,Aprobare, idMeniu FROM SolicitariEvenimente", conn);
cmdSelect.Parameters.AddWithValue("@idCont", this.cont);
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
i++;
cmdSelect2 = new OleDbCommand("Select idLocatie, Denumire from Locatii where idLocatie=@idLoc", conn);
cmdSelect2.Parameters.AddWithValue("@idLoc", reader.GetValue(2));
reader2 = cmdSelect2.ExecuteReader();
reader2.Read();
string[] row1 = new string[] { i.ToString(), reader.GetValue(3).ToString(), reader2.GetValue(1).ToString(), reader.GetValue(11).ToString(), reader.GetValue(12).ToString(), reader.GetValue(13).ToString(), reader.GetValue(0).ToString() };
dataGridView1.Rows.Add(row1);
}
conn.Close();
}
private void MeniuClient_RezervareCamera_Load(object sender, EventArgs e)
{
conn = conectarestr.ConectareBazDate();
conn.Open();
OleDbCommand cmdSelect;
OleDbDataReader reader;
cmdSelect = new OleDbCommand("Select NrCamera, NrPaturi, Detalii, PretCamera from Camere", conn);
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
cboCamera.Items.Add(reader.GetValue(0).ToString());
}
conn.Close();
}
public bool ValidareUser(string user, out string ErrorMessage)
{
//TO DO: Verficarea existaentei aceluiasi user in momentul inregistrarii
var input = user;
ErrorMessage = string.Empty;
OleDbCommand cmdSelect;
OleDbDataReader reader;
ConectareBD conectare = new ConectareBD();
OleDbConnection conn = conectare.ConectareBazDate();
if (string.IsNullOrWhiteSpace(input))
{
ErrorMessage = "Trebuie sa adaugi un nume de utilizator";
return(false);
}
else
{
conn.Open();
cmdSelect = new OleDbCommand("SELECT User, Parola FROM Conturi where Conturi.User = '******'", conn);
reader = cmdSelect.ExecuteReader();
if (reader.HasRows)
{
ErrorMessage = "User-ul este deja folosit";
return(false);
}
}
return(true);
}
private void MeniuPersonalRestaurant_VizualizeazaPreparate_Load(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
conn.Open();
int i = 0;
int j = 0;
OleDbCommand cmdSelect, cmdselect2;
OleDbDataReader reader, reader2;
cmdselect2 = new OleDbCommand("SELECT Distinct TipPreparat from Preparate", conn);
reader2 = cmdselect2.ExecuteReader();
while (reader2.Read())
{
this.treeView1.Nodes.Add("'" + reader2.GetValue(0).ToString());
i++;
cmdSelect = new OleDbCommand(" SELECT idPreparat,TipPreparat, NumePreparat, Pret FROM Preparate where Preparate.TipPreparat =@Preparat", conn);
cmdSelect.Parameters.AddWithValue("@Preparat", reader2.GetValue(0));
reader = cmdSelect.ExecuteReader();
j = 0;
while (reader.Read())
{
j++;
treeView1.Nodes[i - 1].Nodes.Add("'" + reader.GetValue(2).ToString() + "' - '" + reader.GetValue(3).ToString() + "' lei");
treeView1.Nodes[i - 1].NodeFont = new Font("Monotype Corsiva", 16);
treeView1.Nodes[i - 1].Nodes[j - 1].NodeFont = new Font("Monotype Corsiva", 14);
}
}
}
private void VizualizareContClient_Load(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
OleDbCommand cmdSelect, cmdSelect2;
OleDbDataReader reader;
conn.Open();
// verificarea existentei user-ului
cmdSelect = new OleDbCommand("SELECT Nume, Prenume, Email, Telefon FROM DetaliiCont where DetaliiCont.idCont = @idCont", conn);
cmdSelect2 = new OleDbCommand("SELECT User, Parola FROM Conturi where Conturi.idCont = @idCont", conn);
cmdSelect.Parameters.AddWithValue("@idCont", this.ContClient);
cmdSelect2.Parameters.AddWithValue("@idCont", this.ContClient);
reader = cmdSelect.ExecuteReader();
reader.Read();
txtNume.Text = Convert.ToString(reader.GetValue(0));
txtPrenume.Text = Convert.ToString(reader.GetValue(1));
txtEmail.Text = Convert.ToString(reader.GetValue(2));
TxtTelefon.Text = Convert.ToString(reader.GetValue(3));
reader = cmdSelect2.ExecuteReader();
reader.Read();
txtUser.Text = Convert.ToString(reader.GetValue(0));
txtParola.Text = Convert.ToString(reader.GetValue(1));
conn.Close();
}
private void MeniuPersonalHotelPrincipal_Load(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
OleDbCommand cmdSelect;
OleDbDataReader reader;
conn.Open();
// verificarea existentei user-ului
cmdSelect = new OleDbCommand("SELECT Nume FROM DetaliiCont where DetaliiCont.idCont = @idCont", conn);
cmdSelect.Parameters.AddWithValue("@idClient", this.cont);
reader = cmdSelect.ExecuteReader();
reader.Read();
}
private void MeniuAdministrator_Load(object sender, EventArgs e)
{
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
OleDbCommand cmdSelect;
OleDbDataReader reader;
conn.Open();
// verificarea existentei user-ului
cmdSelect = new OleDbCommand("SELECT Nume FROM DetaliiCont where DetaliiCont.idCont = @idCont", conn);
cmdSelect.Parameters.AddWithValue("@idClient", this.ContAdministrator);
reader = cmdSelect.ExecuteReader();
reader.Read();
lblNume.Text = Convert.ToString(reader.GetValue(0));
}
private void MeniuPersonalHotelVerificaDisponibilitatea_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dataSetCamere.Camere' table. You can move, or remove it, as needed.
this.camereTableAdapter.Fill(this.dataSetCamere.Camere);
conn = conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
OleDbCommand cmdSelect;
OleDbDataReader reader;
conn.Open();
// verificarea existentei user-ului
cmdSelect = new OleDbCommand("SELECT Nume FROM DetaliiCont where DetaliiCont.idCont = @idCont", conn);
cmdSelect.Parameters.AddWithValue("@idClient", this.cont);
reader = cmdSelect.ExecuteReader();
reader.Read();
}
private void button1_Click(object sender, EventArgs e)
{
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
conn.Open();
if (textBox1.Text == "")
{
MessageBox.Show("Introduceti mesaj");
}
else
{
if (comboBox1.Text == "")
{
MessageBox.Show("Introduceti nota");
}
else
{
string insert = "INSERT INTO Feedback([Mesaj],[idCont],[NotaAcordataServicii]) VALUES ('" + textBox1.Text + "','" + ContClient + "','" + comboBox1.Text + "')";
OleDbCommand cmdInsert;
OleDbDataAdapter adapter = new OleDbDataAdapter();
cmdInsert = new OleDbCommand(insert, conn);
try
{
// inserarea in conturi
adapter.InsertCommand = new OleDbCommand(insert, conn);
adapter.InsertCommand.ExecuteNonQuery();
cmdInsert.Dispose();
MessageBox.Show("Recenzia dumneavoastra a fost primita");
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void MeniuClient_Restaurant_Meniu_Load(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
conn.Open();
int i = 0;
int j = 0;
OleDbCommand cmdSelect, cmdselect2, cmdSelect3;
OleDbDataReader reader, reader2, reader3;
cmdselect2 = new OleDbCommand("SELECT Distinct TipPreparat from Preparate", conn);
reader2 = cmdselect2.ExecuteReader();
while (reader2.Read())
{
this.treeView1.Nodes.Add("'" + reader2.GetValue(0).ToString());
i++;
cmdSelect = new OleDbCommand(" SELECT idPreparat,TipPreparat, NumePreparat, Pret FROM Preparate where Preparate.TipPreparat =@Preparat", conn);
cmdSelect.Parameters.AddWithValue("@Preparat", reader2.GetValue(0));
reader = cmdSelect.ExecuteReader();
j = 0;
while (reader.Read())
{
j++;
treeView1.Nodes[i - 1].Nodes.Add("'" + reader.GetValue(2).ToString() + "' - '" + reader.GetValue(3).ToString() + "' lei");
treeView1.Nodes[i - 1].NodeFont = new Font("Monotype Corsiva", 16);
treeView1.Nodes[i - 1].Nodes[j - 1].NodeFont = new Font("Monotype Corsiva", 14);
/*
* cmdSelect3 = new OleDbCommand("SELECT Ingrediente from Preparate where Preparate.idPreparat =@Preparat", conn);
* cmdSelect3.Parameters.AddWithValue("@Preparat", reader.GetValue(0));
* reader3 = cmdSelect3.ExecuteReader();
* while (reader3.Read())
* {
* treeView1.Nodes[i - 1].Nodes[0].Nodes.Add("Ingrediente:" + reader3.GetValue(0));
*
*
* }
*/
}
}
}
private void MeniuPersonalRestaurant_AdaugareMeniu_Load(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
conn.Open();
OleDbCommand cmdSelect;
OleDbDataReader reader;
cmdSelect = new OleDbCommand("SELECT * from Preparate", conn);
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
chLB_preparate.Items.Add(reader[1].ToString());
}
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
conn.Open();
var q = "SELECT DetaliiCont.[idDC], DetaliiCont.[Nume], DetaliiCont.[Prenume], DetaliiCont.[Telefon], DetaliiCont.[Email], DetaliiCont.[Adresa], DetaliiCont.[Functia] FROM DetaliiCont ";
var cmd = new OleDbCommand(q, conn);
var da = new OleDbDataAdapter(q, conn);
OleDbDataReader reader;
reader = cmd.ExecuteReader();
var ds = new DataSet();
da.Fill(ds, "Detalii cont");
}
private void MeniuClient_Evenimente_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'testareBDDataSet.Meniu' table. You can move, or remove it, as needed.
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "MM/dd/yyyy hh:mm:ss";
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
int i = 0;
OleDbCommand cmdSelect, cmdselect2;
OleDbDataReader reader, reader2;
conn.Open();
// verificarea existentei user-ului
cmdselect2 = new OleDbCommand("SELECT Meniu.idMeniu, Meniu.NumeMeniu, Meniu.Pret FROM Meniu", conn);
reader2 = cmdselect2.ExecuteReader();
while (reader2.Read())
{
cboMeniu.Items.Add(reader2.GetValue(1).ToString());
this.treeView1.Nodes.Add("'" + reader2.GetValue(1).ToString() + "' - '" + reader2.GetValue(2).ToString() + "' lei");
i++;
cmdSelect = new OleDbCommand(" SELECT MeniuPreparat.idMeniu, MeniuPreparat.idPreparat, Preparate.idPreparat, Preparate.NumePreparat from MeniuPreparat INNER JOIN Preparate on MeniuPreparat.idPreparat = Preparate.idPreparat where MeniuPreparat.idMeniu = @idMeniu", conn);
cmdSelect.Parameters.AddWithValue("@idMeniu", reader2.GetValue(0));
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
treeView1.Nodes[i - 1].Nodes.Add("'" + reader.GetValue(3).ToString() + "'");
}
}
OleDbDataReader readerLocatii;
cmdSelect = new OleDbCommand("Select idLocatie, Denumire, Capacitate from Locatii", conn);
readerLocatii = cmdSelect.ExecuteReader();
while (readerLocatii.Read())
{
cboLocatii.Items.Add(readerLocatii.GetValue(1));
}
conn.Close();
}
private void MeniuPersonalRestaurant_Preparate_Load(object sender, EventArgs e)
{
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
}
public void btnInregistrare_Click(object sender, EventArgs e)
{
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
conn.Open();
Boolean valid = true;
lblDimensiune.ForeColor = System.Drawing.Color.Black;
lblLiteraMare.ForeColor = System.Drawing.Color.Black;
lblLiteraMica.ForeColor = System.Drawing.Color.Black;
lblCifra.ForeColor = System.Drawing.Color.Black;
LblCaracter.ForeColor = System.Drawing.Color.Black;
lblNull.Text = "";
lblTelErr.Text = "";
lblUserErr.Text = "";
String user = txtUser.Text;
String parola = txtParola.Text;
String Email = txtEmail.Text;
String Telefon = TxtTelefon.Text;
String Nume = txtNume.Text;
string Prenume = txtPrenume.Text;
if (validare.ValidareTelefon(TxtTelefon.Text, out string ErrorMessage) == false)
{
lblTelErr.Text = ErrorMessage.ToString();
valid = false;
}
if (validare.ValidareParola(txtParola.Text, out string ErrorMessagePass) == false)
{
if (ErrorMessagePass.ToString() == "0")
{
lblNull.Text = "Trebuie sa introduci o parola";
}
else
{
// label-urile se coloreaza in rosu in functie de validarile nerespectate
for (int i = 0; i <= ErrorMessagePass.ToString().Length - 1; i++)
{
if (ErrorMessagePass.Substring(i, 1) == "1")
{
lblDimensiune.ForeColor = System.Drawing.Color.Red;
}
if (ErrorMessagePass.Substring(i, 1) == "2")
{
lblLiteraMare.ForeColor = System.Drawing.Color.Red;
}
if (ErrorMessagePass.Substring(i, 1) == "3")
{
lblLiteraMica.ForeColor = System.Drawing.Color.Red;
}
if (ErrorMessagePass.Substring(i, 1) == "4")
{
lblCifra.ForeColor = System.Drawing.Color.Red;
}
if (ErrorMessagePass.Substring(i, 1) == "5")
{
LblCaracter.ForeColor = System.Drawing.Color.Red;
}
}
}
valid = false;
}
if (validare.ValidareUser(txtUser.Text, out string ErrorMessageUser) == false)
{
lblUserErr.Text = ErrorMessageUser.ToString();
valid = false;
}
if (valid == true)
{
// TO DO: Inregistrarea noului utilizator
OleDbCommand cmdSelect, cmdInsert, cmdInsertDetalii;
string insert, insertDetalii;
OleDbDataReader reader;
insert = "INSERT INTO Conturi([User],[Parola],[Rol]) VALUES ('" + txtUser.Text + "','" + txtParola.Text + "','Client')";
cmdInsert = new OleDbCommand(insert, conn);
OleDbDataAdapter adapter = new OleDbDataAdapter();
try
{
// inserarea in conturi
adapter.InsertCommand = new OleDbCommand(insert, conn);
adapter.InsertCommand.ExecuteNonQuery();
cmdInsert.Dispose();
// inserarea in detaliicont
cmdSelect = new OleDbCommand("SELECT idCont FROM Conturi where Conturi.User = @User", conn);
cmdSelect.Parameters.AddWithValue("@User", this.txtUser.Text);
reader = cmdSelect.ExecuteReader();
reader.Read();
idCont = reader.GetValue(0);
insertDetalii = "INSERT INTO DetaliiCont([Nume],[Prenume],[Telefon],[Email],[idCont]) VALUES ('" + txtNume.Text + "','" + txtPrenume.Text + "','" + TxtTelefon.Text + "','" + txtEmail.Text + "', '" + idCont + "')";
cmdInsertDetalii = new OleDbCommand(insertDetalii, conn);
adapter.InsertCommand = new OleDbCommand(insertDetalii, conn);
adapter.InsertCommand.ExecuteNonQuery();
cmdInsertDetalii.Dispose();
MessageBox.Show("Utilizatorul a fost adaugat!");
conn.Close();
//deschidere meniu
this.Hide();
var meniu = new MeniuClient(idCont);
meniu.ShowDialog();
this.Close();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void btnConectare_Click(object sender, EventArgs e)
{
conectare.ConectareBazDate();
conn = conectare.ConectareBazDate();
OleDbCommand cmdSelect, cmdSelect2;
OleDbDataReader reader, reader2;
conn.Open();
// verificarea existentei user-ului
cmdSelect = new OleDbCommand("SELECT User, Parola, Rol FROM Conturi where Conturi.User = @User AND Conturi.Parola = @Parola", conn);
cmdSelect.Parameters.AddWithValue("@User", this.txtUser.Text);
cmdSelect.Parameters.AddWithValue("@Parola", this.txtParola.Text);
reader = cmdSelect.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
cmdSelect2 = new OleDbCommand("SELECT idCont FROM Conturi where Conturi.User = @User", conn);
cmdSelect2.Parameters.AddWithValue("@User", this.txtUser.Text);
reader2 = cmdSelect2.ExecuteReader();
reader2.Read();
idCont = reader2.GetValue(0);
if (reader.GetValue(2).ToString() == "Client")
{
this.Hide();
var meniu = new MeniuClient(idCont);
meniu.ShowDialog();
this.Close();
}
else
{
if (reader.GetValue(2).ToString() == "Administrator")
{
this.Hide();
var meniu = new MeniuAdministrator(idCont);
meniu.ShowDialog();
this.Close();
}
else
{
if (reader.GetValue(2).ToString() == "Personal Hotel")
{
this.Hide();
var meniu = new MeniuPersonalHotelPrincipal(idCont);
meniu.ShowDialog();
this.Close();
}
else
{
if (reader.GetValue(2).ToString() == "Personal Restaurant")
{
this.Hide();
var meniu = new MeniuPersonalRestaurant(idCont);
meniu.ShowDialog();
this.Close();
}
else
{
if (reader.GetValue(2).ToString() == "ResponsabilEvenimente")
{
this.Hide();
var meniu = new MeniuResponsabilEvenimente(idCont);
meniu.ShowDialog();
this.Close();
}
}
}
}
}
}
else
{
MessageBox.Show("User-ul sau parola au fost introduse gresit!");
conn.Close();
}
}
private void Rezerva_Click(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
conn.Open();
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "MM/dd/yyyy hh:mm:ss";
if (DateTime.Compare(dateTimePicker1.Value, DateTime.Today) < 0)
{
MessageBox.Show("Data si ora introduse trebuie sa fie mai mari decat data si ora curente");
}
else
{
if (textBox1.Text == "")
{
MessageBox.Show("Introduceti numarul persoanelor");
}
else
{
OleDbCommand cmdSelect;
OleDbDataReader reader;
int suma = 0;
cmdSelect = new OleDbCommand("select NrPersoane, Data from RezervariRestaurant where Data between @Start and @Stop", conn);
cmdSelect.Parameters.AddWithValue("@Start", dateTimePicker1.Value.ToString());
cmdSelect.Parameters.AddWithValue("@Stop", dateTimePicker1.Value.AddHours(1).ToString());
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
suma = suma + Convert.ToInt32(reader.GetValue(0));
}
if (suma >= 150)
{
MessageBox.Show("Nu mai avem locuri disponibile pentru acest interval orar");
}
else
{
string insert = "Insert into RezervariRestaurant([idCont],[Data],[NrPersoane]) values ('" + ContClient.ToString() + "','" + dateTimePicker1.Value + "','" + textBox1.Text + "')";
OleDbCommand cmdInsert;
OleDbDataAdapter adapter = new OleDbDataAdapter();
cmdInsert = new OleDbCommand(insert, conn);
try
{
// inserarea in conturi
adapter.InsertCommand = new OleDbCommand(insert, conn);
adapter.InsertCommand.ExecuteNonQuery();
cmdInsert.Dispose();
MessageBox.Show("Rezervarea dumneavoastra a fost inregistrata");
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
private void cboTip_SelectedIndexChanged(object sender, EventArgs e)
{
conn = conectare.ConectareBazDate();
conn.Open();
OleDbCommand cmdSelect, cmdSelect2;
OleDbDataReader reader, reader2;
dataGridView1.Columns.Clear();
int i = 0;
Beneficii.Visible = false;
if (cboTip.SelectedItem.ToString() == "Hotel")
{
dataGridView1.ColumnCount = 6;
dataGridView1.Columns[0].Name = "Nr";
dataGridView1.Columns[1].Name = "Nr Camera";
dataGridView1.Columns[2].Name = "Check in";
dataGridView1.Columns[3].Name = "CheckOut";
dataGridView1.Columns[4].Name = "Specificatii";
dataGridView1.Columns[5].Name = "Pret";
cmdSelect = new OleDbCommand("Select idRezervareCamera, NrCamera,DataStart, DataStop, Specificatii,Pret, idCont FROM RezervariCamere where idCont=@idCont", conn);
cmdSelect.Parameters.AddWithValue("@idCont", this.ContClient);
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
i++;
string[] row1 = new string[] { i.ToString(), reader.GetValue(1).ToString(), reader.GetValue(2).ToString(), reader.GetValue(3).ToString(), reader.GetValue(4).ToString(), reader.GetValue(5).ToString() };
dataGridView1.Rows.Add(row1);
}
}
else
{
if (cboTip.SelectedItem.ToString() == "Evenimente")
{
dataGridView1.ColumnCount = 7;
dataGridView1.Columns[0].Name = "Nr";
dataGridView1.Columns[1].Name = "Tip Eveniment";
dataGridView1.Columns[2].Name = "Locatie";
dataGridView1.Columns[3].Name = "Data-Ora";
dataGridView1.Columns[4].Name = "Perioada desfasurare";
dataGridView1.Columns[5].Name = "Aprobare";
dataGridView1.Columns[6].Name = "Id";
dataGridView1.Columns[6].Visible = false;
cmdSelect = new OleDbCommand("Select idSolicitare, idCont,idLocatie,TipEveniment, BeneficiiLimuzina, BeneficiiMuzica,BeneficiiAranjamentFloral, BeneficiiDansatori,BeneficiiAranjamentBaloane, BeneficiiAnimatori, Specificatii, Data, PerioadaDesfasurare,Aprobare, idMeniu FROM SolicitariEvenimente where idCont=@idCont", conn);
cmdSelect.Parameters.AddWithValue("@idCont", this.ContClient);
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
i++;
cmdSelect2 = new OleDbCommand("Select idLocatie, Denumire from Locatii where idLocatie=@idLoc", conn);
cmdSelect2.Parameters.AddWithValue("@idLoc", reader.GetValue(2));
reader2 = cmdSelect2.ExecuteReader();
reader2.Read();
string[] row1 = new string[] { i.ToString(), reader.GetValue(3).ToString(), reader2.GetValue(1).ToString(), reader.GetValue(11).ToString(), reader.GetValue(12).ToString(), reader.GetValue(13).ToString(), reader.GetValue(0).ToString() };
dataGridView1.Rows.Add(row1);
}
}
else
{
if (cboTip.SelectedItem.ToString() == "Restaurant")
{
dataGridView1.ColumnCount = 3;
dataGridView1.Columns[0].Name = "Nr";
dataGridView1.Columns[1].Name = "Data";
dataGridView1.Columns[2].Name = "Numar persoane";
cmdSelect = new OleDbCommand("Select Data, NrPersoane, idCont from RezervariRestaurant where idCont=@idCont", conn);
cmdSelect.Parameters.AddWithValue("@idCont", this.ContClient);
reader = cmdSelect.ExecuteReader();
while (reader.Read())
{
i++;
string[] row1 = new string[] { i.ToString(), reader.GetValue(0).ToString(), reader.GetValue(1).ToString() };
dataGridView1.Rows.Add(row1);
}
}
}
}
conn.Close();
}