protected void btnEnter_Click(object sender, EventArgs e) { BsnClsAdministrator bsn_administrator = new BsnClsAdministrator(); string pass = encryptPassw(textPassword.Text); EntClsAdministrator obj_administrator = bsn_administrator.Login(textNameUser.Text, pass); Session.Add("admin", obj_administrator.PasswordA); Response.Redirect("Principal.aspx"); }
public EntClsAdministrator Login(string name, string passwordA) { EntClsAdministrator obj_admin = new EntClsAdministrator(); string storeProcedure = "loginAdministrator"; using (DbConnection con = dpf.CreateConnection()) { con.ConnectionString = constr; using (DbCommand cmd = dpf.CreateCommand()) { cmd.Connection = con; cmd.CommandText = storeProcedure; cmd.CommandType = CommandType.StoredProcedure; DbParameter param = cmd.CreateParameter(); param.DbType = DbType.String; param.ParameterName = "name"; param.Value = name; cmd.Parameters.Add(param); DbParameter param1 = cmd.CreateParameter(); param1.DbType = DbType.String; param1.ParameterName = "passwordA"; param1.Value = passwordA; cmd.Parameters.Add(param1); con.Open(); using (DbDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { obj_admin = new EntClsAdministrator((string)dr["name"], (string)dr["passwordA"]); } } } } return(obj_admin); }