Ejemplo n.º 1
0
 public static void Delete_KH(KhachHangDTO kh)
 {
     try
     {
         HoaDonDTO       hd               = new HoaDonDTO();
         PhieuDatHangDTO pdh              = new PhieuDatHangDTO();
         List <string>   ds               = new List <string>();
         string          delete_kh        = string.Format("DELETE FROM db_khach_hang WHERE ma_kh='{0}'", kh.ma_kh);
         string          delete_hd_in_kh  = string.Format("SELECT ma_hd FROM db_hoa_don WHERE ma_kh = '{0}'", kh.ma_kh);
         string          delete_pdh_in_kh = string.Format("SELECT ma_pdh FROM db_phieu_dat_hang WHERE ma_kh = '{0}'", kh.ma_kh);
         ds = Xoa_thong_tin(delete_hd_in_kh);
         for (int i = 0; i < ds.Count; i++)
         {
             hd.ma_hd = ds[0];
             ChiTietHoaDonDAO.delete_SPHD(hd);
             HoaDonDAO.Delete_HD(hd);
         }
         ds = Xoa_thong_tin(delete_pdh_in_kh);
         for (int i = 0; i < ds.Count; i++)
         {
             pdh.ma_pdh = ds[0];
             ChiTietPhieuDatHangDAO.delete_SPPDH(pdh);
             PhieuDatHangDAO.Delete_PDH(pdh);
         }
         cnn = DataProvider.ConnectData();
         DataProvider.Execute(cnn, delete_kh);
         cnn.Close();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 2
0
        public void Add(List <CTHDDTO> entity)
        {
            SqlDataAdapter da        = new SqlDataAdapter("Select * from CTHD", conn);
            HoaDonDTO      hoaDonDTO = new HoaDonDTO();
            HoaDonDAO      hoaDonDAO = new HoaDonDAO();
            int            _HDId     = hoaDonDAO.GetByLastestId();


            foreach (var item in entity)
            {
                item.HDId = _HDId;
                //CTHDDTO tempcthd = new CTHDDTO(_HDId, item[0], item[1], item[2]);
                Add(item);
            }
        }
Ejemplo n.º 3
0
        public void Add(GiaoHangDTO entity)
        {
            SqlDataAdapter da = new SqlDataAdapter("Select * from GiaoHang", conn);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            HoaDonDAO hoaDonDAO = new HoaDonDAO();
            int       _HDId     = hoaDonDAO.GetByLastestId();
            DataRow   r         = dt.NewRow();
            var       _dateDeli = DateTime.Now;

            r[0] = entity.Id;
            r[1] = _HDId;
            r[2] = entity.TotalPrice;
            r[3] = _dateDeli;
            r[4] = entity.CustomerName;
            r[5] = entity.DeliveryContact;
            r[6] = entity.DeliveryAddress;

            dt.Rows.Add(r);
            SqlCommandBuilder cm = new SqlCommandBuilder(da);

            da.Update(dt);
        }