Beispiel #1
0
        /// <summary>
        /// Returns a GroupMember object if it exists in the databse otherwise it returns a null. If the
        /// email exists in the database as in the GroupMember table in database the method will return a GroupMember
        /// object otherwise it will return an empty GroupMember object.
        /// </summary>
        /// <param >int CampResNo</param>
        /// <returns>List of GroupMemeber</returns>
        public GroupMember GetGroupMembers(string coEmail)
        {
            GroupMember            selectedMember    = null;
            EventAccountDataHelper groupMembergetter = new EventAccountDataHelper();
            //selectedMember=groupMembergetter
            String       sql     = String.Format("SELECT * FROM GROUPMEMBERS WHERE Co_email='{0}'", coEmail);
            MySqlCommand command = new MySqlCommand(sql, connection);

            try
            {
                connection.Open();
                MySqlDataReader reader = command.ExecuteReader();

                int groupId; string coEMail; int campResNo; bool checkIn;

                while (reader.Read())
                {
                    coEMail   = Convert.ToString(reader["Co_email"]);
                    campResNo = Convert.ToInt32(reader["CampRes_No"]);
                    checkIn   = Convert.ToBoolean(reader["Check_in"]);

                    selectedMember         = new GroupMember(coEMail, campResNo);
                    selectedMember.CheckIn = checkIn;
                }
            }
            catch { MessageBox.Show("error while loading from database."); }
            finally { connection.Close(); }
            return(selectedMember);
        }
Beispiel #2
0
 public ReturnForm()
 {
     InitializeComponent();
     //turetu is duomenu bazes sukrauti itemus ir issaugoti sarase +
     dataHelper = new ItemDataHelper();
     materials = dataHelper.GetAllMaterials();
     eaDataHelper = new EventAccountDataHelper();
     phidgetScanner = new PhidgetHandler();
     customerRFID = null;
     invoiceDataHelper = new InvoiceDataHelper();
     //Activate and Open RFID +
     try
     {
         phidgetScanner.OpenRFIDReader();
         phidgetScanner.myRFIDReader.Tag += new TagEventHandler(ChangeTagOnForm);
     }
     catch { MessageBox.Show("No RFID reader detected."); }
 }
        /// <summary>
        /// Returns a GroupMember object if it exists in the databse otherwise it returns a null. If the 
        /// email exists in the database as in the GroupMember table in database the method will return a GroupMember 
        /// object otherwise it will return an empty GroupMember object.
        /// </summary>
        /// <param >int CampResNo</param>
        /// <returns>List of GroupMemeber</returns>
        public GroupMember GetGroupMembers(string coEmail)
        {
            GroupMember selectedMember = null;
            EventAccountDataHelper groupMembergetter = new EventAccountDataHelper();
            //selectedMember=groupMembergetter
            String sql = String.Format("SELECT * FROM GROUPMEMBERS WHERE Co_email='{0}'",coEmail);
            MySqlCommand command = new MySqlCommand(sql, connection);
            try
            {
                connection.Open();
                MySqlDataReader reader = command.ExecuteReader();

                int groupId; string coEMail; int campResNo; bool checkIn;

                while (reader.Read())
                {
                    coEMail = Convert.ToString(reader["Co_email"]);
                    campResNo = Convert.ToInt32(reader["CampRes_No"]);
                    checkIn = Convert.ToBoolean(reader["Check_in"]);

                    selectedMember = new GroupMember(coEMail, campResNo);
                    selectedMember.CheckIn = checkIn;
                }
            }
            catch { MessageBox.Show("error while loading from database."); }
            finally { connection.Close(); }
            return selectedMember;
        }
        private void btnLoadFileAndSave_Click(object sender, EventArgs e)
        {
            // this is the loading part that will read the paypal text file.
            // I used a predefined name for testing. We will just have to indicate the name
            // of the paypal textfile for the updates.
            // At the same time it will update the balance of the client
            read = new PaypalInvoiceReader(userSelectedFilePath);
            s = read.readfile();

            foreach ( string m in s)
            {
               richTextBox1.Text += m + "\n";

               int index = s.IndexOf(m);
               if (index > 3)
               {

                   int[] arrID = new int[s.Count - 4];
                   decimal[] arrB = new decimal[s.Count - 4];
                   string[] arrS = m.Split(' ');
                   foreach (string l in arrS)
                   {
                       arrID[index - 4] = Convert.ToInt32(arrS[0]);
                       arrB[index - 4] = Convert.ToDecimal(arrS[1]);
                   }

                   EventAccountDataHelper accountHelper = new EventAccountDataHelper();

                   accountHelper.UpdateAccountBalanceWithPaypalFIle(arrID[index - 4], arrB[index - 4]);
               }
            }
        }
 public EventAccount EventAccountIdGetter(EventAccountDataHelper datHelp, int iD)
 {
     accountHolder = datHelp.GetAccount(iD);
     return accountHolder;
 }
 public EventAccount EventAccountIdGetter(EventAccountDataHelper datHelp, int iD)
 {
     accountHolder = datHelp.GetAccount(iD);
     return(accountHolder);
 }