Esempio n. 1
0
        public static CustomerDatabaseError AddToDatabase(Customer cust)
        {

            SQLiteConnection connection = new SQLiteConnection(DatabaseManager.CONNECTION_STRING);
            SQLiteCommand command = new SQLiteCommand("INSERT INTO customers(name, phone, adress,  join_date) VALUES(@name,@phone,@adress,CURRENT_TIMESTAMP)", connection);
            command.Parameters.AddWithValue("@name", cust.Name);
            command.Parameters.AddWithValue("@phone", cust.Name);
            command.Parameters.AddWithValue("@adress", cust.Name);

            try
            {
                connection.Open();
            }
            catch (SQLiteException ex)
            {
                return CustomerDatabaseError.ERR_DATABASE_CONNECTION;
            }

            try
            {
                command.ExecuteNonQuery();
            }
            catch (SQLiteException ex)
            {
                return CustomerDatabaseError.ERR_UKNOWN;
            }
            return CustomerDatabaseError.ERR_SUCCESS;
        }
Esempio n. 2
0
        public static bool CreateCard(Customer customer)
        {

            SQLiteConnection connection = new SQLiteConnection(DatabaseManager.CONNECTION_STRING);
            SQLiteCommand command = new SQLiteCommand(@"INSERT INTO clubcard(customer_id, activation_date, expire_date, balance) 
                VALUES(@customerID, CURRENT_TIMESTAMP, @expireDate, 0);", connection);
            command.Parameters.AddWithValue("@customerID", customer.ID);
            command.Parameters.AddWithValue("@expireDate", DateTime.Now.AddYears(Helper.CLUBCARD_EXPIRE_PERIOD));

            try
            {
                connection.Open();
            }
            catch (SQLiteException ex)
            {
                return false;
            }

            try
            {
                command.ExecuteNonQuery();
            }
            catch (SQLiteException ex)
            {
                return false;
            }

            return true;
        }
Esempio n. 3
0
        private void btnAddCustomer_Click(object sender, EventArgs e)
        {
            string phone = txtCustomerAddPhone.Text;
            string address = txtCustomerAddAddress.Text;
            string name = txtCustomerAddName.Text;
            Customer nCust = new Customer(name, address, phone);
            var result = Customer.AddToDatabase(nCust);
            if (result == Customer.CustomerDatabaseError.ERR_SUCCESS)
            {
                if (MessageBox.Show("Customer added successfully. Do you want to add a clubcard for this customer?", "Notice", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    if (ClubCard.CreateCard(nCust))
                    {
                        MessageBox.Show("Successfully created a clubcard!", "Notice");
                    }

                }
            }
        }
Esempio n. 4
0
        public static ClubCard CreateCard(Customer customer, float amount=0)
        {
            SQLiteConnection connection = new SQLiteConnection(DatabaseManager.CONNECTION_STRING);
            SQLiteCommand command = new SQLiteCommand("INSERT INTO clubcards (customer_id, balance) VALUES (@customerId,@amount)", connection);
            command.Parameters.AddWithValue("@customerId", customer.ID);
            command.Parameters.AddWithValue("@amount", amount);

            try
            {
                connection.Open();
            }
            catch
            {
                return null;
            }
            try
            {
                command.ExecuteNonQuery();
            }
            catch
            {
                return null;
            }

            command.CommandText = @"select last_insert_rowid()";
            int cardID = 0;
            try
            {
                cardID = Convert.ToInt32(command.ExecuteScalar());

            }
            catch { }

            connection.Close();
            ClubCard c = new ClubCard();
            c.Balance = amount;
            c.CardID = cardID;
            c.CustomerID = customer.ID;

            return c;

        }