public Int32 logincheck(clsusr1 usr) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("sp_adminmatch", 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_adminlog", 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_adminlog", 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 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; Response.Redirect("adminprofile.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_adminmatch", 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 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; objusr1.p_username = txtusrname.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("adminlogin.aspx"); }