private void logbtn(object sender, RoutedEventArgs e)
{
string u_nam = uname.Text;
string pass = passw.Password;
int count = 0;
try
{
config cn = new config();
SqlConnection sqlcon = cn.cunnection();
sqlcon.Open();
string commandstring = "select * from regis where unam = @a and pass = @b";
SqlCommand sqlcmd = new SqlCommand(commandstring, sqlcon);
sqlcmd.Parameters.Add("@a", SqlDbType.VarChar).Value = u_nam;
sqlcmd.Parameters.Add("@b", SqlDbType.VarChar).Value = pass;
SqlDataReader read = sqlcmd.ExecuteReader();
while (read.Read())
{
count++;
if (read["unam"].ToString() == u_nam && read["pass"].ToString() == pass)
{
massage mass = new massage("Login Successful !!");
mass.ShowDialog();
main ma = new main(read["unam"].ToString());
ma.Show();
this.Close();
}
}
if (count == 0)
{
massage mass = new massage("Invalid Username And Password");
mass.ShowDialog();
}
sqlcon.Close();
}
catch (Exception)
{
massage mass = new massage("Invalid Username And Password");
mass.ShowDialog();
}
}
private void regclk(object sender, RoutedEventArgs e)
{
string u_nam = unam.Text;
string name = nam.Text;
string f_key = fkey.Text;
string pass1 = pass.Password;
string pass2 = cpass.Password;
if (u_nam == "")
{
massage mass = new massage("Input User Name..");
mass.ShowDialog();
}
else if (name == "")
{
massage mass = new massage("Input Name..");
mass.ShowDialog();
}
else if (f_key == "")
{
massage mass = new massage("Input Forgot key..");
mass.ShowDialog();
}
else if (pass1 == "")
{
massage mass = new massage("Input Password..");
mass.ShowDialog();
}
else if (pass2 == "")
{
massage mass = new massage("Input Confirm Password..");
mass.ShowDialog();
}
else
{
if (pass1 == pass2)
{
try
{
config cn = new config();
SqlConnection sqlcon = cn.cunnection();
SqlCommand cmd = new SqlCommand("insert into regis values(@a,@b,@c,@d)", sqlcon);
cmd.Parameters.Add("@a", SqlDbType.VarChar).Value = u_nam;
cmd.Parameters.Add("@b", SqlDbType.VarChar).Value = name;
cmd.Parameters.Add("@c", SqlDbType.VarChar).Value = f_key;
cmd.Parameters.Add("@d", SqlDbType.VarChar).Value = pass1;
sqlcon.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
massage mass = new massage("Registration Successful !!");
mass.ShowDialog();
main mi = new main(u_nam);
mi.Show();
this.Close();
}
sqlcon.Close();
}
catch (Exception)
{
massage mass = new massage("This User Name is Alrady Used !!");
mass.ShowDialog();
}
}
else
{
massage mass = new massage("Password does not Match !!");
mass.ShowDialog();
}
}
}
