private void lblLogin_Click(object sender, EventArgs e)
{
if (txtUsername.ForeColor == Color.Black && txtUsername.Text != "" && txtPassword.ForeColor == Color.Black && txtPassword.Text != "")
{
cn = new OleDbConnection();
cn.ConnectionString = "Provider='Microsoft.ACE.OLEDB.12.0';Data Source='Usuarios.accdb'";
cn.Open();
string sql = "Select * from Usuario where Username = '******' and Clave = '{1}'";
sql = String.Format(sql, txtUsername.Text.ToLower(), txtPassword.Text.ToLower());
cmd = new OleDbCommand(sql, cn);
da = new OleDbDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "DatosLog");
if (ds.Tables["DatosLog"].Rows.Count != 0)
{
Var.user = txtUsername.Text.ToLower();
Var.UserRoom = Convert.ToInt32(ds.Tables["DatosLog"].Rows[0].ItemArray[2]);
home = true;
this.Close();
MyHouse house = new MyHouse();
house.Show();
}
else
MessageBox.Show("That's not a valid Username/Password");
cn.Close();
}
else
MessageBox.Show("Fill in every field", "Error");
}
private void lblHouse_Click(object sender, EventArgs e)
{
this.Visible = false;
if (Var.user != null)
{
MyHouse mi_casa = new MyHouse();
mi_casa.Show();
}
else
{
LoginHouse login = new LoginHouse();
login.Show();
}
}
