예제 #1
0
        private void btnPayment_Click(object sender, EventArgs e)
        {
            if (Convert.ToInt32(txtCusPay.Text) < Convert.ToInt32(cbCost.Text))
            {
                MessageBox.Show("Số tiền khách trả phải lớn hơn số tiền cần trả");
            }
            else
            {
                ArrayList temp  = new ArrayList();
                ArrayList temp2 = new ArrayList();
                foreach (var user in db.KhachHangs)
                {
                    temp.Add(Convert.ToInt32(user.stt));
                }
                KhachHang kh = new KhachHang()
                {
                    MaKH  = "KH" + Convert.ToString(temp.Count + 1),
                    TenKH = txtNameCus.Text
                };
                db.KhachHangs.Add(kh);
                db.SaveChanges();



                foreach (var user in db.PhieuVes)
                {
                    temp2.Add(Convert.ToInt32(user.stt));
                }
                PhieuVe pv = new PhieuVe()
                {
                    MaPhieu      = "PV" + Convert.ToString(temp2.Count + 1),
                    MaKH         = "KH" + Convert.ToString(temp.Count + 1),
                    TenKH        = txtNameCus.Text,
                    TenNVBV      = txtNameEmp.Text,
                    MaNVBV       = txtIdEmp.Text,
                    SoTien       = Convert.ToInt32(cbCost.Text),
                    ChoNgoi      = txtSit.Text,
                    NgayKhoiHanh = Convert.ToDateTime(dtTimeStart.Text),
                    MaChuyenxe   = cbIDveh.Text,


                    TenDD = cbLocation.Text
                };
                db.PhieuVes.Add(pv);
                db.SaveChanges();

                /*
                 * after add infor of hoaDon, move on QLKH to continue update data of customer
                 */
                ManageCustomer manageCustomer = new ManageCustomer();
                this.Hide();
                manageCustomer.ShowDialog();
                this.Show();
            }
        }
        private void btnDelete_Click(object sender, EventArgs e)
        {
            String    Makh = txtMaKh.Text;
            KhachHang kh   = db.KhachHangs.Where(p => p.MaKH == Makh).SingleOrDefault();
            PhieuVe   pv   = db.PhieuVes.Where(p => p.MaKH == Makh).SingleOrDefault();

            db.PhieuVes.Remove(pv);
            db.KhachHangs.Remove(kh);

            db.SaveChanges();
            LoadData();
        }