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());
}
