//Admin a = new Admin();
//reg
public int insert(signing s)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Bishal\Desktop\Municipal management\Municipal management\Registration.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand cmd = new SqlCommand("insert into Reg (FirstName,LastName,UserName,Password,ConfirmPassword,MobileNo,DateofBirth,Gender)values('" + s.firstName + "','" + s.lastName + "','" + s.userName + "','" + s.password + "','" + s.confirmPassword + "','" + s.mobileNo + "','" + s.dob + "','" + s.gender + "')", con);
try
{
return(cmd.ExecuteNonQuery());
}
catch
{
con.Close();
throw;
}
}
//login
public DataTable Select(signing s)
{
DataTable dt = new DataTable("Reg");
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Bishal\Desktop\Municipal management\Municipal management\Registration.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand cmd = new SqlCommand("select * from Reg where UserName ='******' and Password ='******'", con);
try
{
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dt.Load(rd);
return(dt);
}
catch
{
con.Close();
throw;
}
}
private void logIn_Click(object sender, EventArgs e)
{
signing s = new signing();
s.userName = userNameTextBox.Text;
s.password = pswdTextbox.Text;
Connection cn = new Connection();
DataTable dt = new DataTable();
dt = cn.Select(s);
if (dt.Rows.Count > 0)
{
this.Hide();
welcome wel = new welcome();
wel.Show();
}
else
{
MessageBox.Show("Invalid userName and Password");
}
}
