private void back_Click(object sender, EventArgs e)
{
this.Hide();
home_page fm = new home_page();
fm.Show();
}
private void signin_Click(object sender, EventArgs e)
{
if (email.Text == "" || password.Text == "")
{
MessageBox.Show("Please provide UserName and Password");
return;
}
try
{
cmd = new SqlCommand("Select EmailId, Password from dbo.User_Profile where EmailId=@username and Password=@password", con);
cmd.Parameters.AddWithValue("@username", email.Text);
cmd.Parameters.AddWithValue("@password", password.Text);
con.Open();
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapt.Fill(ds);
con.Close();
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
MessageBox.Show("Login Successful!");
cmd = new SqlCommand(" SELECT USERNAME FROM[ExpenseManager].[dbo].User_Profile WHERE EmailId = @email;", con);
cmd.Parameters.AddWithValue("@email", email.Text);
con.Open();
SqlDataReader rd;
rd = cmd.ExecuteReader();
if (rd.Read())
{
GlobalClass.GlobalVar = rd["USERNAME"].ToString();
}
this.Hide();
home_page fm = new home_page();
fm.Show();
}
else
{
MessageBox.Show("Login Failed!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}