public Int32 logincheck(clsusr1 usr)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("sp_match", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_username", SqlDbType.VarChar, 50).Value = usr.p_username;
cmd.Parameters.Add("@p_password", SqlDbType.VarChar, 50).Value = usr.p_password;
cmd.Parameters.Add("@p_userid", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlParameter log = new SqlParameter("@set", SqlDbType.Int);
log.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(log);
cmd.ExecuteNonQuery();
Int32 a;
a = Convert.ToInt32(cmd.Parameters["@set"].Value);
cmd.Dispose();
con.Close();
return(a);
}
public Int32 insrt_usr(clsusr1 usr)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("sp_insrtlog", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_username", SqlDbType.VarChar, 50).Value = usr.p_username;
cmd.Parameters.Add("@p_password", SqlDbType.VarChar, 50).Value = usr.p_password;
Int32 j = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
return j;
}
public Int32 insrt_usr(clsusr1 usr)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("sp_insrtlog", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_username", SqlDbType.VarChar, 50).Value = usr.p_username;
cmd.Parameters.Add("@p_password", SqlDbType.VarChar, 50).Value = usr.p_password;
Int32 j = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
return(j);
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
clsusr objusr = new clsusr();
clsprp objprp = new clsprp();
clsusr1 objusr1 = new clsusr1();
clsprp1 objprp1 = new clsprp1();
objusr.p_name = txtname.Text;
objusr.p_bloodgrp = drpbldgrp.Text;
objusr.p_gender = drpgndr.Text;
objusr.p_dob = txtdob.Text;
objusr.p_mobile = txtmob.Text;
objusr.p_landline = txtland.Text;
objusr.p_state = drpstate.Text;
objusr.p_city = drpcity.Text;
objusr.p_email = txtemail.Text;
objusr.p_address = txtadd.Text;
objusr1.p_username = txtusr.Text;
objusr1.p_password = txtpass.Text;
Int32 i = objprp.insrt_usr(objusr);
if (i > 0)
{
comment.Text = "registered";
}
else
{
comment.Text = "not registered";
}
Int32 j = objprp1.insrt_usr(objusr1);
if (j > 0)
{
comment.Text = "registered";
}
else
{
comment.Text = "not registered";
}
Response.Redirect("donorlog.aspx");
}
protected void btnlogin_Click1(object sender, EventArgs e)
{
clsusr1 objprp = new clsusr1();
clsprp1 objlog = new clsprp1();
objprp.p_username = txtusr.Text;
objprp.p_password = txtpass.Text;
Int32 login = objlog.logincheck(objprp);
if (login == 1)
{
Int32 cod = objlog.logincheckcod(objprp);
Session["mycod"] = cod;
Session["usrnam"] = txtusr.Text;
Response.Redirect("donorprofile.aspx");
}
else if (login == -1)
Label1.Text = "invalid username and password";
}
public Int32 logincheck(clsusr1 usr)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("sp_match", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_username", SqlDbType.VarChar, 50).Value = usr.p_username;
cmd.Parameters.Add("@p_password", SqlDbType.VarChar, 50).Value = usr.p_password;
cmd.Parameters.Add("@p_userid", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlParameter log = new SqlParameter("@set", SqlDbType.Int);
log.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(log);
cmd.ExecuteNonQuery();
Int32 a;
a = Convert.ToInt32(cmd.Parameters["@set"].Value);
cmd.Dispose();
con.Close();
return a;
}
//protected void check_Click(object sender, EventArgs e)
//{
// clsusr objusr = new clsusr();
// clsprp objnam = new clsprp();
// objusr.p_name = username.Text;
// Int32 j = objnam.search(objusr);
// if (j != 1)
// {
// lb2.Text = "";
// password.Enabled = true;
// confirm.Enabled = true;
// email.Enabled = true;
// mob.Enabled = true; ;
// age.Enabled = true;
// Address.Enabled = true;
// city.Enabled = true;
// state.Enabled = true;
// country.Enabled = true;
// }
// else
// {
// lb2.Text = "Already taken";
// }
//}
protected void Button1_Click(object sender, EventArgs e)
{
clsusr1 objusr = new clsusr1();
clsprp1 objnam = new clsprp1();
objusr.p_username = txtusr.Text;
Int32 j= objnam.search(objusr);
if (j!= 1)
{
Label1.Text = "Now enter Password";
}
else
{
Label1.Text = "already taken";
}
}