private void BTRegister_Click(object sender, EventArgs e)
{
SQLiteConnection con = new SQLiteConnection(@"data source = C:\Users\Kutay\Desktop\RepairShop.db");
string query = @"insert into Employee (Name,Surname,Email,Password,Phone) values(@Name,@Surname,@Email,@Password,@Phone)";
SQLiteCommand cmd = new SQLiteCommand(query, con);
if ((TBName.Text.Trim() != "" && TBName.Text.Trim() != "Ad") &&
(TBSurname.Text.Trim() != "" && TBSurname.Text.Trim() != "Soyad") &&
(TBMail.Text.Trim() != "" && TBMail.Text.Trim() != "Mail") &&
(TBPassword.Text.Trim() != "" && TBPassword.Text.Trim() != "Password") &&
(TBPhone.Text.Trim() != "" && TBPhone.Text.Trim() != "Telefon") &&
(TBConfirm.Text.Trim() != "" && TBConfirm.Text.Trim() != "Confirmation Code"))
{
SQLiteCommand cm = new SQLiteCommand("Select Conf from Confirmation", con);
con.Open();
SQLiteDataReader dr = cm.ExecuteReader();
int i = 0;
while (dr.Read())
{
a = dr.GetString(0);
ConfCode.Add(a);
}
dr.Close();
con.Close();
if (!ConfCode.ToArray().Contains <string>(TBConfirm.Text.Trim()))
{
lblMsg.ForeColor = Color.DarkRed;
lblMsg.Text = "Wrong Conf. Code";
}
else
{
cmd.Parameters.Add(new SQLiteParameter("@Name", TBName.Text.Trim()));
cmd.Parameters.Add(new SQLiteParameter("@Surname", TBSurname.Text.Trim()));
cmd.Parameters.Add(new SQLiteParameter("@Email", TBMail.Text.Trim()));
cmd.Parameters.Add(new SQLiteParameter("@Password", TBPassword.Text.Trim()));
cmd.Parameters.Add(new SQLiteParameter("@Phone", TBPhone.Text.Trim()));
con.Open();
cmd.ExecuteNonQuery();
TBName.Clear(); TBSurname.Clear(); TBMail.Clear(); TBPassword.Clear(); TBPhone.Clear();
lblMsg.ForeColor = Color.DarkGreen;
lblMsg.Text = "Succesfull Registration";
}
}
else
{
lblMsg.ForeColor = Color.DarkRed;
lblMsg.Text = "Please fill all areas.";
}
}
private void BLogin_Click(object sender, EventArgs e)
{
string username = TBUsername.Text;
foreach (Credencial c in credenciales)
{
if (username == c.username)
{
string password = TBPassword.Text;
if (password == c.password)
{
if (c.acceso == "ADMIN")
{
this.Close();
th = new Thread(openMenuAdmin);
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
else
{
this.Close();
th = new Thread(openMenuAlumnos);
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
}
else
{
MessageBox.Show("Password incorrecto :( ");
TBUsername.Clear();
TBPassword.Clear();
break;
}
}
}
MessageBox.Show("No existe usuario :( ");
TBUsername.Clear();
TBPassword.Clear();
}
private void Login()
{
try
{
if (TBUsername.Text != "")
{
if (TBPassword.Text != "")
{
if (employeeModel.Login(TBUsername.Text, Helpers.SHA1(TBPassword.Text)))
{
FormMain Frm = new FormMain();
Frm.Show();
Hide();
}
else
{
Msg("Usuario y/o contraseña incorrecta. \npor favor vuelve a intentarlo.");
}
}
else
{
Msg("Ingresa tu contraseña!");
TBPassword.Focus();
}
}
else
{
Msg("Ingresa tu Usuario");
TBUsername.Focus();
}
}
catch (Exception er)
{
PBLog.Save(this, er);
}
}
private void TBPassword_Click(object sender, EventArgs e)
{
TBPassword.Clear();
}
private void BLogin_Click(object sender, EventArgs e)
{
string username = TBUsername.Text;
foreach (Credencial c in credenciales)
{
if (username == c.username)
{
string password = TBPassword.Text;
if (password == c.password)
{
if (c.acceso == "ADMIN")
{
foreach (Credencial crec in credenciales)
{
if (password == crec.password)
{
foreach (Persona p in personas)
{
if (p.rut == crec.rut)
{
currentUser = p;
}
}
}
}
this.Close();
th = new Thread(openMenuAdmin); //Definir el currentUser para enviar al menuadmin TODO
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
else
{
foreach (Credencial crec in credenciales)
{
if (password == crec.password)
{
foreach (Persona p in personas)
{
if (p.rut == crec.rut)
{
currentUser = p;
}
}
}
}
this.Close();
th = new Thread(openMenuAlumnos); //Definir el currentUser para enviar al menualumnos TODO
th.SetApartmentState(ApartmentState.STA);
th.Start();
}
}
else
{
MessageBox.Show("Password incorrecto :( ");
TBUsername.Clear();
TBPassword.Clear();
break;
}
}
}
MessageBox.Show("No existe usuario :( ");
TBUsername.Clear();
TBPassword.Clear();
}
