public AdminWindow(User AdminInfo)
 {
     InitializeComponent();
 }
Esempio n. 2
0
        public User GetAdminLoginDetails(string UserName)
        {
            User AdminInfo = null;
            string commandText = "SELECT * FROM AdminInfo WHERE (UserName = @userName)";

            using (SqlCeConnection connection = new SqlCeConnection(connectionSting))
            {
                using (SqlCeCommand command = new SqlCeCommand(commandText, connection))
                {
                    try
                    {
                        connection.Open();
                        command.Parameters.AddWithValue("@userName", UserName);
                        SqlCeDataReader reader = command.ExecuteReader();

                        AdminInfo = new User();

                        while (reader.Read())
                        {
                            AdminInfo.UID = new Guid(reader[0].ToString());
                            AdminInfo.Name = reader[1].ToString();
                            AdminInfo.UserName = reader[2].ToString();
                            AdminInfo.Password = reader[3].ToString();
                            AdminInfo.IDNumber = reader[4].ToString();

                        }
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(e.ToString());
                    }
                }
            }

            return AdminInfo;
        }