示例#1
0
        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);
        }