private void btnVizitator_Click(object sender, EventArgs e)
{
Auxiliare.UtilizatorLogat = 3;
this.Close();
frmLimba flb = new frmLimba();
flb.Close();
}
private void btnLogare_Click(object sender, EventArgs e)
{
if (txtNumeLogare.Text != "" && txtParolaLogare.Text != "")
{
using (SqlConnection con = new SqlConnection(sirConectare))
{
string sirSQL = "SELECT * FROM Utilizatori WHERE NumeUtilizatorDB = @numeUtilizator and ParolaDB = @parola";
SqlCommand cmd = new SqlCommand(sirSQL, con);
cmd.Parameters.AddWithValue("@numeUtilizator", txtNumeLogare.Text);
cmd.Parameters.AddWithValue("@parola", txtParolaLogare.Text);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
//con.Close();
int count = ds.Tables[0].Rows.Count;
//If count is equal to 1, than show frmMain form
if (count == 1)
{
if (ds.Tables[0].Rows[0][4].ToString() == "A")
{
Auxiliare.UtilizatorLogat = 1;
}
else
{
Auxiliare.UtilizatorLogat = 2;
}
//MessageBox.Show("Nr inregistrari: " + count.ToString() + " utilizator de tip: " + Auxiliare.UtilizatorLogat.ToString());
this.Close();
frmLimba flb = new frmLimba();
flb.Close();
// Form1 fa = new Form1();
//fa.ShowDialog();
}
else
{
if (Auxiliare.Limba == 2)
{
MessageBox.Show("Failed to autentificate. Username or password incorrect. Please retry.");
}
else
{
MessageBox.Show("Autentificare nereusita. Nume sau parola eronata");
}
txtNumeLogare.Clear();
txtParolaLogare.Clear();
txtNumeLogare.Focus();
}
}
}
else
{
if (Auxiliare.Limba == 2)
{
MessageBox.Show("You must fill the Username and Password fields!");
}
else
{
MessageBox.Show("Campurile Nume utilizator si Parola sunt obligatorii!");
}
txtNumeLogare.Focus();
txtParolaLogare.Clear();
}
}