예제 #1
0
        public void EditTrip(int iddoan, string tendoan, int idtour, int slkh, int slpt, string ngaybd, string ngaykt, string mota, string tongchiphi, string doanhthu, ObservableCollection <CUSTOMER> customerlist, ObservableCollection <STAFF> stafflist, ObservableCollection <HOTEL> hotellist, ObservableCollection <VEHICLE> vehiclelist, ObservableCollection <EATING> eatinglist, ObservableCollection <OTHERCOST> othercostlist)
        {
            doan             = DataProvider.Ins.DB.DOAN.Where(x => x.IDDOAN == iddoan).SingleOrDefault();
            doan.TENDOAN     = tendoan;
            doan.IDTOUR      = idtour;
            doan.SOLUONGKH   = slkh;
            doan.SOLUONGPT   = slpt;
            doan.NGAYBATDAU  = ngaybd;
            doan.NGAYKETTHUC = ngaykt;
            doan.MOTA        = mota;
            doan.TONGCHIPHI  = tongchiphi;
            doan.DOANHTHU    = doanhthu;
            DataProvider.Ins.DB.SaveChanges();

            if (customerlist != null)
            {
                //Xoá chi tiết địa điểm cũ
                ObservableCollection <CT_DOAN_KHACHHANG> TRIP_CUSTOMER_DETAIL = new ObservableCollection <CT_DOAN_KHACHHANG>(DataProvider.Ins.DB.CT_DOAN_KHACHHANG.Where(x => x.IDDOAN == iddoan));

                foreach (var item in TRIP_CUSTOMER_DETAIL)
                {
                    DataProvider.Ins.DB.CT_DOAN_KHACHHANG.Remove(item);
                    DataProvider.Ins.DB.SaveChanges();
                }

                foreach (var item in customerlist)
                {
                    CUSTOMER_TRIP_DETAIL customer_list_detail = new CUSTOMER_TRIP_DETAIL();
                    customer_list_detail.AddNewCustomer_Trip_Detail(doan.IDDOAN, item.khachhang.IDKH);
                }
            }
            if (stafflist != null)
            {
                //Xoá chi tiết địa điểm cũ
                ObservableCollection <CT_DOAN_NHANVIEN> TRIP_STAFF_DETAIL = new ObservableCollection <CT_DOAN_NHANVIEN>(DataProvider.Ins.DB.CT_DOAN_NHANVIEN.Where(x => x.IDDOAN == iddoan));

                foreach (var item in TRIP_STAFF_DETAIL)
                {
                    DataProvider.Ins.DB.CT_DOAN_NHANVIEN.Remove(item);
                    DataProvider.Ins.DB.SaveChanges();
                }

                foreach (var item in stafflist)
                {
                    STAFF_TRIP_DETAIL staff_list_detail = new STAFF_TRIP_DETAIL();
                    staff_list_detail.AddNewStaff_Trip_Detail(doan.IDDOAN, item.nhanvien.IDNV, item.NHIEMVU);
                }
            }
            if (hotellist != null)
            {
                //Xoá chi tiết cũ
                ObservableCollection <CT_DOAN_KHACHSAN> TRIP_HOTEL_DETAIL = new ObservableCollection <CT_DOAN_KHACHSAN>(DataProvider.Ins.DB.CT_DOAN_KHACHSAN.Where(x => x.IDDOAN == iddoan));

                foreach (var item in TRIP_HOTEL_DETAIL)
                {
                    DataProvider.Ins.DB.CT_DOAN_KHACHSAN.Remove(item);
                    DataProvider.Ins.DB.SaveChanges();
                }

                foreach (var item in hotellist)
                {
                    HOTEL_TRIP_DETAIL hotel_list_detail = new HOTEL_TRIP_DETAIL();
                    hotel_list_detail.AddNewHotel_Trip_Detail(doan.IDDOAN, item.khachsan.IDKS, item.TONGCHIPHI);
                }
            }
            if (eatinglist != null)
            {
                //Xoá chi tiết cũ
                ObservableCollection <CT_DOAN_BUAAN> TRIP_EATING_DETAIL = new ObservableCollection <CT_DOAN_BUAAN>(DataProvider.Ins.DB.CT_DOAN_BUAAN.Where(x => x.IDDOAN == iddoan));

                foreach (var item in TRIP_EATING_DETAIL)
                {
                    DataProvider.Ins.DB.CT_DOAN_BUAAN.Remove(item);
                    DataProvider.Ins.DB.SaveChanges();
                }

                foreach (var item in eatinglist)
                {
                    EATING_TRIP_DETAIL eating_trip_detail = new EATING_TRIP_DETAIL();
                    eating_trip_detail.AddNewEating_Trip_Detail(doan.IDDOAN, item.CHIPHIBUAAN, item.MOTA);
                }
            }
            if (othercostlist != null)
            {
                //Xoá chi tiết cũ
                ObservableCollection <CT_DOAN_CHIPHIKHAC> TRIP_OTHERCOST_DETAIL = new ObservableCollection <CT_DOAN_CHIPHIKHAC>(DataProvider.Ins.DB.CT_DOAN_CHIPHIKHAC.Where(x => x.IDDOAN == iddoan));

                foreach (var item in TRIP_OTHERCOST_DETAIL)
                {
                    DataProvider.Ins.DB.CT_DOAN_CHIPHIKHAC.Remove(item);
                    DataProvider.Ins.DB.SaveChanges();
                }
                foreach (var item in othercostlist)
                {
                    OTHERCOST_TRIP_DETAIL othercost_trip_detail = new OTHERCOST_TRIP_DETAIL();
                    othercost_trip_detail.AddNewOtherCost_Trip_Detail(doan.IDDOAN, item.CHIPHI, item.MOTA);
                }
            }
            if (vehiclelist != null)
            {
                //Xoá chi tiết cũ
                ObservableCollection <CT_DOAN_PHUONGTIEN> TRIP_VEHICLE_DETAIL = new ObservableCollection <CT_DOAN_PHUONGTIEN>(DataProvider.Ins.DB.CT_DOAN_PHUONGTIEN.Where(x => x.IDDOAN == iddoan));

                foreach (var item in TRIP_VEHICLE_DETAIL)
                {
                    DataProvider.Ins.DB.CT_DOAN_PHUONGTIEN.Remove(item);
                    DataProvider.Ins.DB.SaveChanges();
                }
                foreach (var item in vehiclelist)
                {
                    VEHICLE_TRIP_DETAIL vehicle_trip_detail = new VEHICLE_TRIP_DETAIL();
                    vehicle_trip_detail.AddNewVehicle_Trip_Detail(doan.IDDOAN, item.phuongtien.IDPT, item.phuongtien.GIATHUE);
                }
            }
        }
예제 #2
0
        public void AddNewTrip(string tendoan, int idtour, int slkh, int slpt, string ngaybd, string ngaykt, string mota, string tongchiphi, string doanhthu, ObservableCollection <CUSTOMER> customerlist, ObservableCollection <STAFF> stafflist, ObservableCollection <HOTEL> hotellist, ObservableCollection <VEHICLE> vehiclelist, ObservableCollection <EATING> eatinglist, ObservableCollection <OTHERCOST> othercostlist)
        {
            doan             = new DOAN();
            doan.TENDOAN     = tendoan;
            doan.IDTOUR      = idtour;
            doan.SOLUONGKH   = slkh;
            doan.SOLUONGPT   = slpt;
            doan.NGAYBATDAU  = ngaybd;
            doan.NGAYKETTHUC = ngaykt;
            doan.MOTA        = mota;
            doan.TONGCHIPHI  = tongchiphi;
            doan.DOANHTHU    = doanhthu;
            DataProvider.Ins.DB.DOAN.Add(doan);
            DataProvider.Ins.DB.SaveChanges();

            if (customerlist != null)
            {
                foreach (var item in customerlist)
                {
                    CUSTOMER_TRIP_DETAIL customer_list_detail = new CUSTOMER_TRIP_DETAIL();
                    customer_list_detail.AddNewCustomer_Trip_Detail(doan.IDDOAN, item.khachhang.IDKH);
                }
            }
            if (stafflist != null)
            {
                foreach (var item in stafflist)
                {
                    STAFF_TRIP_DETAIL staff_list_detail = new STAFF_TRIP_DETAIL();
                    staff_list_detail.AddNewStaff_Trip_Detail(doan.IDDOAN, item.nhanvien.IDNV, item.NHIEMVU);
                }
            }
            if (hotellist != null)
            {
                foreach (var item in hotellist)
                {
                    HOTEL_TRIP_DETAIL hotel_list_detail = new HOTEL_TRIP_DETAIL();
                    hotel_list_detail.AddNewHotel_Trip_Detail(doan.IDDOAN, item.khachsan.IDKS, item.TONGCHIPHI);
                }
            }
            if (eatinglist != null)
            {
                foreach (var item in eatinglist)
                {
                    EATING_TRIP_DETAIL eating_trip_detail = new EATING_TRIP_DETAIL();
                    eating_trip_detail.AddNewEating_Trip_Detail(doan.IDDOAN, item.CHIPHIBUAAN, item.MOTA);
                }
            }
            if (othercostlist != null)
            {
                foreach (var item in othercostlist)
                {
                    OTHERCOST_TRIP_DETAIL othercost_trip_detail = new OTHERCOST_TRIP_DETAIL();
                    othercost_trip_detail.AddNewOtherCost_Trip_Detail(doan.IDDOAN, item.CHIPHI, item.MOTA);
                }
            }
            if (vehiclelist != null)
            {
                foreach (var item in vehiclelist)
                {
                    VEHICLE_TRIP_DETAIL vehicle_trip_detail = new VEHICLE_TRIP_DETAIL();
                    vehicle_trip_detail.AddNewVehicle_Trip_Detail(doan.IDDOAN, item.phuongtien.IDPT, item.phuongtien.GIATHUE);
                }
            }
        }