Example #1
0
 public void saveCustomer(Customer cus)
 {
     cmd.CommandText = "INSERT INTO customer(name, address, email, phone, birthday, point)" +
                 " values(@name, @address, @email, @phone, @birthday, @point)";
             cmd.Parameters.AddWithValue("@name", cus.getName());
             cmd.Parameters.AddWithValue("@address", cus.getAddress());
             cmd.Parameters.AddWithValue("@email", cus.getEmail());
             cmd.Parameters.AddWithValue("@phone", cus.getPhone());
             cmd.Parameters.AddWithValue("@birthday", cus.getBirthday());
             cmd.Parameters.AddWithValue("@point", cus.getPoint());
             cmd.ExecuteNonQuery();
             conn.Close();
 }
Example #2
0
 public void updateCustomer(Customer cus)
 {
     cmd.CommandText = " UPDATE customer SET name = @name, address=@address, "+
                       " email = @email, phone = @phone, birthday=@birthday "+
                       " where id = @id ";
     cmd.Parameters.AddWithValue("@name", cus.getName());
     cmd.Parameters.AddWithValue("@address", cus.getAddress());
     cmd.Parameters.AddWithValue("@email", cus.getEmail());
     cmd.Parameters.AddWithValue("@phone", cus.getPhone());
     cmd.Parameters.AddWithValue("@birthday", cus.getBirthday());
     cmd.Parameters.AddWithValue("@id", cus.getId());
     cmd.ExecuteNonQuery();
     conn.Close();
 }
Example #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("Are you sure to add a customer?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    name = textBoxName.Text;
                    address = textBoxAddress.Text;
                    email = textBoxEmail.Text;
                    phone = textBoxPhone.Text;
                    birthday = textBoxBirthday.Text;

                    cus = new Customer(name, address, email, phone, birthday, "0");
                    if (cus.repOK())
                    {
                        //MessageBox.Show(cus.toString());
                        cusMan = new CustomerManager();
                        cusMan.saveCustomer(cus);

                        //write text file
                        //MessageBox.Show(cus.toString());
                        DateTime now = DateTime.Now;
                        System.IO.StreamWriter file = new System.IO.StreamWriter(@"person.txt", true);
                        file.WriteLine("Add customer{" + cus.toStringInfo() + "}" + "    " + now);
                        file.Close();
                        tableGetData();
                        MessageBox.Show("Add customer successfully.");
                    }
                    else
                    {
                        MessageBox.Show("Invalid Customer.");
                    }
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Example #4
0
        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("Are you sure to delete a customer?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    int selectedIndex = table1.CurrentCell.RowIndex;
                    if (selectedIndex >= 0)
                    {
                        String id = table1.Rows[selectedIndex].Cells[0].Value.ToString();

                        cusMan = new CustomerManager();
                        cusMan.deleteCustomer(id);

                        //print log
                        cus = new Customer();
                        DateTime now = DateTime.Now;
                        System.IO.StreamWriter file = new System.IO.StreamWriter(@"person.txt", true);
                        file.WriteLine("Delete customer{" + id + "}" + "    " + now);
                        file.Close();
                        tableGetData();
                        MessageBox.Show("Delete Customer successfully.");
                    }

                    else
                        MessageBox.Show("Select a customer to delete.");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Example #5
0
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("Are you sure to update a customer?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    int selectedIndex = table1.CurrentCell.RowIndex;
                    if (selectedIndex >= 0)
                    {
                        String id = table1.Rows[selectedIndex].Cells[0].Value.ToString();
                        name = textBoxName.Text;
                        address = textBoxAddress.Text;
                        email = textBoxEmail.Text;
                        phone = textBoxPhone.Text;
                        birthday = textBoxBirthday.Text;
                        point = labelPoint.Text;

                        cus = new Customer(id, name, address, email, phone, birthday, point);
                        if (cus.repOK())
                        {
                            //MessageBox.Show("ID= " + cusID + "\n" + cus.toString());
                            cusMan = new CustomerManager();
                            cusMan.updateCustomer(cus);

                            //write text file
                            DateTime now = DateTime.Now;
                            System.IO.StreamWriter file = new System.IO.StreamWriter(@"person.txt", true);
                            file.WriteLine("Update customer{" + cus.toStringInfo() + "}" + "    " + now);
                            file.Close();
                            tableGetData();
                            MessageBox.Show("Update customer successfully.");
                        }
                        else
                        {
                            MessageBox.Show("Invalid Customer.");
                        }
                    }
                    else
                        MessageBox.Show("Select a customer to update.");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }