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 btnAprobare_Click(object sender, EventArgs e)
{
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = " UPDATE SolicitariEvenimente SET Aprobare = 'Aprobat' where idSolicitare =@Solicitare";
cmd.Parameters.AddWithValue("@Soliocitare", dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[6].Value.ToString());
cmd.ExecuteNonQuery();
conn.Close();
this.Hide();
var vizualizareCont = new MeniuResponsabilEvenimente(cont);
vizualizareCont.ShowDialog();
this.Close();
}
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();
}
}