void ActionFuelTransferDocuments_Activated(object sender, System.EventArgs e) { ISubdivisionRepository subdivisionRepository = new SubdivisionRepository(); IFuelRepository fuelRepository = new FuelRepository(); ICounterpartyJournalFactory counterpartyJournalFactory = new CounterpartyJournalFactory(); INomenclatureSelectorFactory nomenclatureSelectorFactory = new NomenclatureSelectorFactory(); IEmployeeJournalFactory employeeJournalFactory = new EmployeeJournalFactory(); ICarJournalFactory carJournalFactory = new CarJournalFactory(); IFileChooserProvider fileChooserProvider = new Vodovoz.FileChooser("Категория Расхода.csv"); var expenseCategoryJournalFilterViewModel = new ExpenseCategoryJournalFilterViewModel(); var fuelDocumentsJournalViewModel = new FuelDocumentsJournalViewModel( UnitOfWorkFactory.GetDefaultFactory, ServicesConfig.CommonServices, VodovozGtkServicesConfig.EmployeeService, subdivisionRepository, fuelRepository, counterpartyJournalFactory, nomenclatureSelectorFactory, employeeJournalFactory, carJournalFactory, new GtkReportViewOpener(), fileChooserProvider, expenseCategoryJournalFilterViewModel ); tdiMain.AddTab(fuelDocumentsJournalViewModel); }
public RouteListWorkingJournalViewModel( RouteListJournalFilterViewModel filterViewModel, IUnitOfWorkFactory unitOfWorkFactory, ICommonServices commonServices, IRouteListRepository routeListRepository, FuelRepository fuelRepository, CallTaskRepository callTaskRepository, BaseParametersProvider baseParametersProvider, SubdivisionRepository subdivisionRepository) : base(filterViewModel, unitOfWorkFactory, commonServices) { TabName = "Работа кассы с МЛ"; this.routeListRepository = routeListRepository; this.fuelRepository = fuelRepository; this.callTaskRepository = callTaskRepository; this.baseParametersProvider = baseParametersProvider; this.subdivisionRepository = subdivisionRepository; UseSlider = false; NotifyConfiguration.Enable(); NotifyConfiguration.Instance.BatchSubscribeOnEntity <RouteList>(OnRouteListChanged); InitPopupActions(); }
public void UpdapteFuel_With_Correct_Parameter() { //ARRANGE var options = new DbContextOptionsBuilder <FleetManagmentContext>() .UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name) .Options; using var context = new FleetManagmentContext(options); IFuelRepository fuelRepository = new FuelRepository(context); FuelTO fuel = new FuelTO { Name = "diesel" }; //ACT var addedFuel = fuelRepository.Insert(fuel); context.SaveChanges(); addedFuel.Name = "essence"; fuelRepository.Update(addedFuel); context.SaveChanges(); //ASSERT Assert.IsNotNull(addedFuel); Assert.AreNotEqual(0, addedFuel.Id); Assert.AreEqual("essence", addedFuel.Name); }
public void GetFuel_ById() { //ARRANGE var options = new DbContextOptionsBuilder <FleetManagmentContext>() .UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name) .Options; using var context = new FleetManagmentContext(options); IFuelRepository fuelRepository = new FuelRepository(context); FuelTO fuel = new FuelTO { Name = "diesel", }; FuelTO fuel2 = new FuelTO { Name = "essence", }; //ACT var addedFuel = fuelRepository.Insert(fuel); var addedFuel2 = fuelRepository.Insert(fuel2); context.SaveChanges(); //ASSERT Assert.IsNotNull(addedFuel); Assert.AreNotEqual(0, addedFuel.Id); Assert.AreEqual("diesel", addedFuel.Name); Assert.AreEqual(1, fuelRepository.GetByID(1).Id); }
public void AddFuel_ThrowsException_WhenNullIsProvided() { var options = new DbContextOptionsBuilder <FleetManagmentContext>() .UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name) .Options; using var context = new FleetManagmentContext(options); IFuelRepository fuelRepository = new FuelRepository(context); FuelTO fuel = new FuelTO { Name = "diesel", }; FuelTO fuel2 = new FuelTO { Name = "essence", }; //ACT var addedFuel = fuelRepository.Insert(fuel); context.SaveChanges(); //ASSERT Assert.ThrowsException <ArgumentNullException>(() => fuelRepository.Insert(null)); }
private void MainForm_Load(object sender, EventArgs e) { IRepository reposiory = new FuelRepository(); cmbFuels.DisplayMember = "Type"; cmbFuels.DataSource = reposiory.Get(); sumCafe.Text = "0,00"; }
public int Save(BE.Fuel fuel) { FuelRepository repository = new FuelRepository(); if(fuel.ID > 0) return repository.Update(fuel); else return repository.Insert(fuel); }
public List<object> GetSomeQuery() { var Tov_allRepository = new Tov_allRepository(); var FuelRepository = new FuelRepository(); var someTov = Tov_allRepository.GetAll().Where(a => a.Numend == 5400).Select(a => new { a.Amount, a.Codfuel, a.Datepay }).GroupJoin(FuelRepository.GetAll(), a => a.Codfuel, b => b.Codfuel, (a, b) => new { a, b }).ToList(); return null; }
private void ConfigureDlg() { fuelRepository = new FuelRepository(); yspeccomboboxSubdivision.Sensitive = ViewModel.FuelDocument.FuelExpenseOperation == null && ViewModel.IsNewEditable; yspeccomboboxSubdivision.Binding.AddBinding(ViewModel, w => w.AvailableSubdivisionsForUser, e => e.ItemsList).InitializeFromSource(); yspeccomboboxSubdivision.SetRenderTextFunc <Subdivision>(s => s.Name); yspeccomboboxSubdivision.Binding.AddBinding(ViewModel.FuelDocument, w => w.Subdivision, e => e.SelectedItem).InitializeFromSource(); ydatepicker.Binding.AddBinding(ViewModel.FuelDocument, e => e.Date, w => w.Date).InitializeFromSource(); yentrydriver.RepresentationModel = ViewModel.EmployeeJournal; yentrydriver.Binding.AddBinding(ViewModel.FuelDocument, e => e.Driver, w => w.Subject).InitializeFromSource(); entityviewmodelentryCar.SetEntityAutocompleteSelectorFactory( new DefaultEntityAutocompleteSelectorFactory <Car, CarJournalViewModel, CarJournalFilterViewModel>(ServicesConfig.CommonServices)); entityviewmodelentryCar.Binding.AddBinding(ViewModel.FuelDocument, x => x.Car, x => x.Subject).InitializeFromSource(); yentryfuel.SubjectType = typeof(FuelType); yentryfuel.Binding.AddBinding(ViewModel.FuelDocument, e => e.Fuel, w => w.Subject).InitializeFromSource(); yspinFuelTicketLiters.Binding.AddBinding(ViewModel.FuelDocument, e => e.FuelCoupons, w => w.ValueAsInt).InitializeFromSource(); disablespinMoney.Binding.AddBinding(ViewModel.FuelDocument, e => e.PayedForFuel, w => w.ValueAsDecimal).InitializeFromSource(); labelResultInfo.Binding.AddBinding(ViewModel, e => e.ResultInfo, w => w.Text).InitializeFromSource(); labelAvalilableFuel.Binding.AddBinding(ViewModel, e => e.BalanceState, w => w.Text).InitializeFromSource(); labelExpenseInfo.Binding.AddBinding(ViewModel, e => e.CashExpenseInfo, w => w.Text).InitializeFromSource(); disablespinMoney.Binding.AddBinding(ViewModel, e => e.FuelInMoney, w => w.Active).InitializeFromSource(); ytextviewFuelInfo.Binding.AddBinding(ViewModel, e => e.FuelInfo, w => w.Buffer.Text).InitializeFromSource(); yenumcomboboxPaymentType.ItemsEnum = typeof(FuelPaymentType); yenumcomboboxPaymentType.Binding.AddBinding(ViewModel.FuelDocument, e => e.FuelPaymentType, w => w.SelectedItem).InitializeFromSource(); buttonSave.Binding.AddBinding(ViewModel, e => e.CanEdit, w => w.Sensitive).InitializeFromSource(); buttonOpenExpense.Binding.AddBinding(ViewModel, e => e.CanOpenExpense, w => w.Sensitive).InitializeFromSource(); spinFuelPrice.Binding.AddBinding(ViewModel, e => e.FuelInMoney, w => w.Sensitive).InitializeFromSource(); ydatepicker.Binding.AddBinding(ViewModel, e => e.CanChangeDate, w => w.Sensitive).InitializeFromSource(); yspinFuelTicketLiters.Binding.AddBinding(ViewModel, e => e.IsNewEditable, w => w.Sensitive).InitializeFromSource(); yenumcomboboxPaymentType.Binding.AddBinding(ViewModel, e => e.IsNewEditable, w => w.Sensitive).InitializeFromSource(); spinFuelPrice.Binding.AddBinding(ViewModel.FuelDocument, e => e.LiterCost, w => w.ValueAsDecimal).InitializeFromSource(); if (ViewModel?.FuelDocument?.FuelOperation?.PayedLiters > 0m) { disablespinMoney.Active = true; // Перенести в VM } disablespinMoney.Binding.AddBinding(ViewModel, e => e.IsNewEditable, w => w.Sensitive).InitializeFromSource(); }
public static AllSalesModel BALGetChitFuelSalesDetails(int pumpid) { var data = FuelRepository.GetChitFuelSalesDetails(pumpid).ToList(); List <ChitFuelSale> _temp = new List <ChitFuelSale>(); var d = data.ToList();//.ToArray() var obj = new AllSalesModel(); foreach (var item in d) { if (item.Fueltype == 1) { obj.PetrolQuantity = item.PetrolQuantity; obj.PetrolAmount = item.PetrolAmount; obj.DeiselQuantity = item.DeiselQuantity; obj.DeiselAmount = item.DeiselAmount; obj.LubricantQuantity = item.LubricantQuantity; obj.LubricantAmount = item.LubricantAmount; } if (item.Fueltype == 2) { obj.OPetrolQuantity = item.PetrolQuantity; obj.OPetrolAmount = item.PetrolAmount; obj.ODeiselQuantity = item.DeiselQuantity; obj.ODeiselAmount = item.DeiselAmount; obj.OLubricantQuantity = item.LubricantQuantity; obj.OLubricantAmount = item.LubricantAmount; } if (item.Fueltype == 3) { obj.SPetrolQuantity = item.PetrolQuantity; obj.SPetrolAmount = item.PetrolAmount; obj.SDeiselQuantity = item.DeiselQuantity; obj.SDeiselAmount = item.DeiselAmount; obj.SLubricantQuantity = item.LubricantQuantity; obj.SLubricantAmount = item.LubricantAmount; } } return(obj); }
public void DeleteFuel_With_FuelTO_Parameter() { //ARRANGE var options = new DbContextOptionsBuilder <FleetManagmentContext>() .UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name) .Options; using var context = new FleetManagmentContext(options); IFuelRepository fuelRepository = new FuelRepository(context); FuelTO fuel = new FuelTO { Name = "diesel", }; FuelTO fuel2 = new FuelTO { Name = "essence", }; var addedFuel = fuelRepository.Insert(fuel); var addedFuel2 = fuelRepository.Insert(fuel2); context.SaveChanges(); //List<FuelTO> fuels = new List<FuelTO>(); var fuels = fuelRepository.GetAll().ToList(); //ACT fuelRepository.Remove(addedFuel); context.SaveChanges(); fuels = fuelRepository.GetAll().ToList(); //ASSERT Assert.IsNotNull(addedFuel); Assert.IsNotNull(addedFuel2); Assert.AreNotEqual(0, addedFuel.Id); Assert.AreNotEqual(0, addedFuel2.Id); Assert.AreEqual("diesel", addedFuel.Name); Assert.AreEqual("essence", addedFuel2.Name); Assert.AreEqual(1, fuels.Count); }
public static bool BALInsertDailySummary(FinalSummary model) { tbl_finalStock obj = new tbl_finalStock() { pumpid = model.pumpid, smeter_petrol = model.smeter_petrol, emeter_petrol = model.emeter_petrol, ownersale_petrol = model.ownersale_petrol, cashsale_petrol = model.cashsale_petrol, staffsale_petrol = model.staffsale_petrol, othersale_petrol = model.othersale_petrol, ownerquanity_petrol = model.ownerquanity_petrol, cashquanity_petrol = model.cashquanity_petrol, staffquanity_petrol = model.staffquanity_petrol, otherquanity_petrol = model.otherquanity_petrol, smeter_diesel = model.smeter_diesel, emeter_diesel = model.emeter_diesel, ownersale_diesel = model.ownersale_diesel, cashsale_diesel = model.cashsale_diesel, staffsale_diesel = model.staffsale_diesel, othersale_diesel = model.othersale_diesel, ownerquanity_diesel = model.ownerquanity_diesel, cashquanity_diesel = model.cashquanity_diesel, staffquanity_diesel = model.staffquanity_diesel, otherquanity_diesel = model.otherquanity_diesel, ownersale_lub = model.ownersale_lub, cashsale_lub = model.cashsale_lub, staffsale_lub = model.staffsale_lub, othersale_lub = model.othersale_lub, ownerquanity_lub = model.ownerquanity_lub, cashquanity_lub = model.cashquanity_lub, staffquanity_lub = model.staffquanity_lub, otherquanity_lub = model.otherquanity_lub, summary_date = model.summary_date, inserted_by = model.inserted_by, }; return(FuelRepository.DALInsertDailySummary(obj)); }
public void Init(FuelRepository repo, FuelController controller) { base.Init(repo.Model); _controller = controller; }
public static DeliveryPriceNode Calculate(decimal?latitude, decimal?longitude, int?bottlesCount) { IList <District> districts; DeliveryPriceNode result = new DeliveryPriceNode(); //Топливо using (var uow = UnitOfWorkFactory.CreateWithoutRoot("Расчет стоимости доставки")) { var fuel = FuelRepository.GetDefaultFuel(uow); if (fuel == null) { result.ErrorMessage = string.Format("Топливо по умолчанию «АИ-92» не найдено в справочке."); return(result); } fuelCost = (double)fuel.Cost; //Районы districts = ScheduleRestrictionRepository.GetDistrictsWithBorder(uow); result.WageDistrict = deliveryPoint?.District?.WageDistrict?.Name ?? "Неизвестно"; //Координаты if (!latitude.HasValue || !longitude.HasValue) { result.ErrorMessage = string.Format("Не указаны координаты. Невозможно расчитать расстояние."); return(result); } //Расчет растояния if (deliveryPoint == null) { var gg = GeographicGroupRepository.GeographicGroupByCoordinates((double)latitude.Value, (double)longitude.Value, districts); var route = new List <PointOnEarth>(2); if (gg != null && gg.BaseCoordinatesExist) { route.Add(new PointOnEarth((double)gg.BaseLatitude, (double)gg.BaseLongitude)); } else if (gg == null) { //если не найдена часть города, то расстояние считается до его центра route.Add(new PointOnEarth(Constants.CenterOfCityLatitude, Constants.CenterOfCityLongitude)); } else { result.ErrorMessage = "В подобранной части города не указаны координаты базы"; return(result); } route.Add(new PointOnEarth(latitude.Value, longitude.Value)); var osrmResult = OsrmMain.GetRoute(route, false, GeometryOverview.False); if (osrmResult == null) { result.ErrorMessage = "Ошибка на сервере расчета расстояний, невозможно расчитать расстояние."; return(result); } if (osrmResult.Code != "Ok") { result.ErrorMessage = $"Сервер расчета расстояний вернул следующее сообщение: {osrmResult.StatusMessageRus}"; return(result); } distance = osrmResult.Routes[0].TotalDistance / 1000d; } else { distance = (deliveryPoint.DistanceFromBaseMeters ?? 0) / 1000d; } result.Distance = distance.ToString("N1") + " км"; result.Prices = Enumerable.Range(1, 100) .Select( x => new DeliveryPriceRow { Amount = x, Price = PriceByDistance(x).ToString("C2") } ).ToList(); //Расчет цены var point = new Point((double)latitude, (double)longitude); var district = districts.FirstOrDefault(x => x.DistrictBorder.Contains(point)); result.DistrictName = district?.DistrictName ?? string.Empty; result.GeographicGroups = district?.GeographicGroup != null ? district.GeographicGroup.Name : "Неизвестно"; result.ByDistance = district == null || district.PriceType == DistrictWaterPrice.ByDistance; result.WithPrice = (district != null && district.PriceType != DistrictWaterPrice.ByDistance) || (result.ByDistance && bottlesCount.HasValue); if (result.ByDistance) { if (bottlesCount.HasValue) { result.Price = PriceByDistance(bottlesCount.Value).ToString("C2"); } } else if (district?.PriceType == DistrictWaterPrice.FixForDistrict) { result.Price = district.WaterPrice.ToString("C2"); } else if (district?.PriceType == DistrictWaterPrice.Standart) { result.Price = "прайс"; } result.MinBottles = district?.MinBottles.ToString(); result.Schedule = district != null && district.HaveRestrictions ? string.Join(", ", district.GetSchedulesString(true)) : "любой день"; } return(result); }
public static FuelChashModel BALGetCashFuelSalesDetails(CashFuleSale model) { return(FuelRepository.GetCashFuelSalesDetails(model)); }
public void Init(FuelRepository repo) { _model = repo.Model; }
public FuelController(FuelRepository repo) { _model = repo.Model; }
//return FuelRepository.InsertOtherFule(model); public static List <RecieveFuleModel> BALGetRecievingFuelDetails(int pumpid) { return(FuelRepository.GetRecievingFuelDetails(pumpid).ToList()); }
public static List <FuelOtherModel> BALGetOtherFuelDetails(int userid) { return(FuelRepository.GetOtherFuelDetails(userid).ToList()); }
public MainForm() { InitializeComponent(); _fuelRepository = new FuelRepository(); }
public static SaleReportFinal BALGetOtherStocksDetailsSummary(int pumpid) { var data = FuelRepository.DALGetOtherStocksDetailsSummary(pumpid); return(SalesReportCreation(data)); }
public static List <FuelStockReport> BALGetFuelFinalSumamry() { return(FuelRepository.GetStocksReport(1).ToList()); }