public List<User> User_GetById(string Id)
 {
     List<Data.User> list = new List<Data.User>();
     using (SqlCommand dbCmd = new SqlCommand("sp_User_GetById", GetConnection()))
     {
         Data.User obj = new Data.User();
         dbCmd.CommandType = CommandType.StoredProcedure;
         dbCmd.Parameters.Add(new SqlParameter("@Id", Id));
         SqlDataReader dr = dbCmd.ExecuteReader();
         if (dr.HasRows)
         {
             while (dr.Read())
             {
                 list.Add(obj.UserIDataReader(dr));
             }
             dr.Close();
             //conn.Close();
         }
         else
         {
             dr.Close();
         }
     }
     return list;
 }
Exemple #2
0
        /// <summary>
        /// Lấy thông tin user
        /// </summary>
        /// <returns></returns>
        public List <User> User_GetByAll()
        {
            List <Data.User> list = new List <Data.User>();

            using (SqlCommand dbCmd = new SqlCommand("sp_User_GetByAll", GetConnection()))
            {
                Data.User obj = new Data.User();
                dbCmd.CommandType = CommandType.StoredProcedure;
                SqlDataReader dr = dbCmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        list.Add(obj.UserIDataReader(dr));
                    }
                }
                dr.Close();
                obj = null;
            }
            return(list);
        }