public static void IsValid(TourPrice tourPrice, int?Id = null) { Exception ex = new Exception("Validate excption"); var inputDateRange = new DateRange(tourPrice.StartDate, tourPrice.EndDate); var tour = TourDAL.GetById(tourPrice.TourId); if (tour == null) { ex.Data.Add("Tour", "Không tìm thấy tour"); } var tourPrices = TourPriceDAL.Find(tp => (tp.TourId == tour.Id) && (!Id.HasValue || tp.Id != Id)); foreach (var x in tourPrices) { var sourceDateRange = new DateRange(x.StartDate, x.EndDate); if (!inputDateRange.BeforeOrAfter(sourceDateRange)) { ex.Data.Add("Thời gian", "Thời gian bắt đầu và kết thúc không hợp lệ"); break; } } if (ex.Data.Count > 0) { throw ex; } }
private TourPrice addNewTourPrice() { DateTime start_date = dtpStart_date.Value; DateTime end_date = dtpEnd_date.Value; decimal price = 0; try { price = decimal.Parse(tbTourPrice.Text.Trim()); } catch { MessageBox.Show("Giá tiền không hợp lệ!"); tbTourPrice.Clear(); tbTourPrice.Focus(); return(null); } if (!checkDateTime(start_date, end_date)) { MessageBox.Show("Ngày hết hạn không được nhỏ hơn ngày áp dụng!"); return(null); } tourPrice = new DTO.TourPrice(); tourPrice.price = price; tourPrice.start_date = start_date; tourPrice.end_date = end_date; return(tourPrice); }
private void btnTourPriceEdit_Click(object sender, EventArgs e) { if (TourPriceMode != OperationType.Edit) { LoadTourPriceMode(OperationType.Edit); return; } try { var tourPrice = new TourPrice( Int32.Parse(tbTourID.Text), dtpTourPriceStartDate.Value, dtpTourPriceEndDate.Value, Int32.Parse(tbTourPriceValue.Text), tbTourPriceNote.Text ); tourPrice.Id = Int32.Parse(tbTourPriceID.Text); TourPriceBLL.Update(tourPrice); MessageBox.Show($"Sửa giá tour cho tour {tbTourID.Text} thành công"); LoadTourPriceMode(OperationType.View); Thread threadLoadTourPriceDataGridView = new Thread(new ThreadStart(() => LoadTourPriceDataGridView())); threadLoadTourPriceDataGridView.Start(); } catch (Exception ex) { GUIExtensionMethod.HandleError(ex); } }
private void btnTourPriceAdd_Click(object sender, EventArgs e) { if (TourPriceMode != OperationType.Add) { LoadTourPriceMode(OperationType.Add); return; } try { var tourPrice = new TourPrice( Int32.Parse(tbTourID.Text), dtpTourPriceStartDate.Value, dtpTourPriceEndDate.Value, Int32.Parse(tbTourPriceValue.Text.Equals("") ? "-1" : tbTourPriceValue.Text), tbTourPriceNote.Text ); TourPriceBLL.Add(tourPrice); MessageBox.Show($"Thêm giá tour cho tour {tbTourID.Text} thành công"); LoadTourPriceMode(OperationType.View); Thread threadLoadTourPriceDataGridView = new Thread(new ThreadStart(() => LoadTourPriceDataGridView())); threadLoadTourPriceDataGridView.Start(); } catch (FormatException) { MessageBox.Show("Giá tiền không được để số"); } catch (Exception ex) { GUIExtensionMethod.HandleError(ex); } }
public void LoadTourPriceForm(TourPrice data) { tbTourPriceID.Text = data.Id.ToString(); tbTourPriceValue.Text = data.Price.ToString(); tbTourPriceNote.Text = data.Note?.ToString(); dtpTourPriceStartDate.Value = data.StartDate; dtpTourPriceEndDate.Value = data.EndDate; }
public static void Update(TourPrice tourPrice) { try { IsValid(tourPrice, tourPrice.Id); TourPriceDAL.Update(tourPrice); } catch (Exception ex) { throw ex; } }
public static void Add(TourPrice tourPrice) { try { IsValid(tourPrice); TourPriceDAL.Add(tourPrice); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Update([FromBody] TourPrice tourPrice) { try { _logger.LogInformation("Try to update tourPrice: {0}", tourPrice.Id); _context.TourPrices.Update(tourPrice); await _context.SaveChangesAsync(); } catch (Exception e) { _logger.LogError(e.ToString()); return(BadRequest(e.Message)); } _logger.LogInformation("TourPrice was updated by user: {0}", User.Identity.Name); return(Ok("Info was updated successfully")); }
protected void btnCalculate_Click(object sender, EventArgs e) { Tour tour = Module.TourGetById(_tourId); // Danh sách các vai trò IList list = Module.RoleGetAll(); for (int numberOfCustomer = 1; numberOfCustomer <= 8; numberOfCustomer++) { //Tính giá net cho từng số lượng khách hàng TourPrice tourPrice = Module.TourPriceGetByTourAndCustomers(tour, numberOfCustomer); // Tạo một bảng giá sale, số lượng phần tử tối đa bằng số role Hashtable tourSalePrices = new Hashtable(list.Count); // Tạo một datatable DataTable table = new DataTable(); table.Columns.Add("Service", typeof(string)); table.Columns.Add("Detail", typeof(string)); table.Columns.Add("Unit price", typeof(double)); table.Columns.Add("Total", typeof(double)); // Tạo một loạt các cột trong data table = role // Tạo dữ liệu trong hashtable theo id foreach (Role role in list) { table.Columns.Add(role.Name, typeof(double)); // Thêm vào bảng băm các giá bán tương ứng tourSalePrices.Add(role.Id, Module.TourSalePriceGet(tour, numberOfCustomer, role.Id)); } int currentRow = 0; if (Module.HotelSection != null) { TourModuleBase hotelModule = _moduleLoader.GetModuleFromSection(Module.HotelSection) as TourModuleBase; if (hotelModule != null) { hotelModule.ExportTourConfigToDataTable(_tourId, table, list, numberOfCustomer); } double[] hotel = Calculate(table, currentRow, table.Rows.Count); tourPrice.TourNetHotelPrice = hotel[3]; int ii = 4; foreach (Role role in list) { ((TourSalePrice)tourSalePrices[role.Id]).HotelPrice = hotel[ii]; ii++; } currentRow = table.Rows.Count - 1; } if (Module.RestaurantSection != null) { TourModuleBase restaurantModule = _moduleLoader.GetModuleFromSection(Module.RestaurantSection) as TourModuleBase; if (restaurantModule != null) { restaurantModule.ExportTourConfigToDataTable(_tourId, table, list, numberOfCustomer); } double[] meal = Calculate(table, currentRow, table.Rows.Count); tourPrice.TourNetMealPrice = meal[3]; int ii = 4; foreach (Role role in list) { ((TourSalePrice)tourSalePrices[role.Id]).MealPrice = meal[ii]; ii++; } currentRow = table.Rows.Count - 1; } if (Module.TransportSection != null) { TourModuleBase transportModule = _moduleLoader.GetModuleFromSection(Module.TransportSection) as TourModuleBase; if (transportModule != null) { transportModule.ExportTourConfigToDataTable(_tourId, table, list, numberOfCustomer); } double[] transport = Calculate(table, currentRow, table.Rows.Count); tourPrice.TourNetTransportPrice = transport[3]; int ii = 4; foreach (Role role in list) { ((TourSalePrice)tourSalePrices[role.Id]).TransportPrice = transport[ii]; ii++; } currentRow = table.Rows.Count - 1; } if (Module.LandscapeSection != null) { TourModuleBase landscapeModule = _moduleLoader.GetModuleFromSection(Module.LandscapeSection) as TourModuleBase; if (landscapeModule != null) { landscapeModule.ExportTourConfigToDataTable(_tourId, table, list, numberOfCustomer); } double[] entrancefee = Calculate(table, currentRow, table.Rows.Count); tourPrice.TourNetEntranceFeePrice = entrancefee[3]; int ii = 4; foreach (Role role in list) { ((TourSalePrice)tourSalePrices[role.Id]).EntranceFeePrice = entrancefee[ii]; ii++; } currentRow = table.Rows.Count - 1; } if (Module.GuideSection != null) { TourModuleBase guideModule = _moduleLoader.GetModuleFromSection(Module.GuideSection) as TourModuleBase; if (guideModule != null) { guideModule.ExportTourConfigToDataTable(_tourId, table, list, numberOfCustomer); } double[] guide = Calculate(table, currentRow, table.Rows.Count); tourPrice.TourNetGuidesPrice = guide[3]; int ii = 4; foreach (Role role in list) { ((TourSalePrice)tourSalePrices[role.Id]).GuidePrice = guide[ii]; ii++; } currentRow = table.Rows.Count - 1; } if (Module.BoatSection != null) { TourModuleBase boatModule = _moduleLoader.GetModuleFromSection(Module.BoatSection) as TourModuleBase; if (boatModule != null) { boatModule.ExportTourConfigToDataTable(_tourId, table, list, numberOfCustomer); } double[] boat = Calculate(table, currentRow, table.Rows.Count); tourPrice.TourNetBoatPrice = boat[3]; int ii = 4; foreach (Role role in list) { ((TourSalePrice)tourSalePrices[role.Id]).BoatPrice = boat[ii]; ((TourSalePrice)tourSalePrices[role.Id]).OtherPrice = 0; ii++; } //currentRow = table.Rows.Count - 1; } tourPrice.TourNetOtherPrice = 0; DataRow row = table.NewRow(); double[] total = new double[table.Columns.Count]; foreach (DataRow datarow in table.Rows) { for (int ii = 2; ii < table.Columns.Count; ii++) { if (!string.IsNullOrEmpty(datarow[ii].ToString())) { total[ii] += Convert.ToDouble(datarow[ii]); } } } tourPrice.TotalNet = total[3]; int jj = 4; foreach (Role role in list) { ((TourSalePrice)tourSalePrices[role.Id]).Total = total[jj]; ((TourSalePrice)tourSalePrices[role.Id]).NumberOfCustomers = numberOfCustomer; ((TourSalePrice)tourSalePrices[role.Id]).LastCalculateDate = DateTime.Now; ((TourSalePrice)tourSalePrices[role.Id]).ExtraFee = 0; ((TourSalePrice)tourSalePrices[role.Id]).Tour = tour; ((TourSalePrice)tourSalePrices[role.Id]).RoleId = role.Id; Module.SaveOrUpdate((TourSalePrice)tourSalePrices[role.Id]); jj++; } for (int ii = 2; ii < table.Columns.Count; ii++) { row[ii] = total[ii]; } table.Rows.Add(row); tourPrice.NumberOfCustomers = numberOfCustomer; tourPrice.LastCaculateDate = DateTime.Now; tourPrice.ExtraFee = 0; tourPrice.Tour = tour; Module.SaveOrUpdate(tourPrice); } ShowMessage("Calculating completed!"); //DataExports.ExportToExcel(Context, table, "Report", "report.xls"); }
public void update(TourPrice price) { _unitOfWork.TourPriceRepository.Update(price); _unitOfWork.Save(); }
public int addWithoutId(TourPrice tourprice) { _unitOfWork.TourPriceRepository.Insert(tourprice); _unitOfWork.Save(); return(tourprice.id); }
public void add(TourPrice tourprice) { _unitOfWork.TourPriceRepository.Insert(tourprice); _unitOfWork.Save(); }
public void SaveOrUpdate(TourPrice tourPrice) { _commonDao.SaveOrUpdateObject(tourPrice); }