public IHttpActionResult GetFuelSale(int id)
{
try
{
FuelSale fs = this.ef_fs.Get().Where(c => c.id == id)
.ToList()
.Select(s => new FuelSale
{
id = s.id,
operator_name = s.operator_name,
smena_num = s.smena_num,
smena_datetime = s.smena_datetime,
trk_num = s.trk_num,
side = s.side,
num = s.num,
fuel_type = s.fuel_type,
tank_num = s.tank_num,
id_card = s.id_card,
dose = s.dose,
passage = s.passage,
volume = s.volume,
mass = s.mass,
start_datetime = s.start_datetime,
start_level = s.start_level,
start_volume = s.start_volume,
start_density = s.start_density,
start_mass = s.start_mass,
start_temp = s.start_temp,
start_water_level = s.start_water_level,
start_counter = s.start_counter,
stop_datetime = s.stop_datetime,
stop_level = s.stop_level,
stop_volume = s.stop_volume,
stop_density = s.stop_density,
stop_mass = s.stop_mass,
stop_temp = s.stop_temp,
stop_water_level = s.stop_water_level,
stop_counter = s.stop_counter,
close = s.close,
id_sap = s.id_sap,
})
.FirstOrDefault();
if (fs == null)
{
return(NotFound());
}
return(Ok(fs));
}
catch (Exception e)
{
String.Format("Ошибка выполнения метода API:GetFuelSale(id={0})", id).SaveError(e);
return(NotFound());
}
}
public int PutFuelSale(int id, [FromBody] FuelSale value)
{
try
{
this.ef_fs.Update(value);
return(this.ef_fs.Save());
}
catch (Exception e)
{
String.Format("Ошибка выполнения метода API:PutFuelSale(id={0}, value={1})", id, value).SaveError(e);
return(-1);
}
}
public int PostFuelSale([FromBody] FuelSale value)
{
try
{
this.ef_fs.Add(value);
this.ef_fs.Save();
this.ef_fs.Refresh(value);
return(value.id);
}
catch (Exception e)
{
String.Format("Ошибка выполнения метода API:PostFuelSale(value={0})", value).SaveError(e);
return(-1);
}
}
public IHttpActionResult GetOpenFuelSale(int num)
{
try
{
FuelSale fs = this.ef_fs.Get()
.Where(c => c.Out_Type == num & (c.Start_Date == null | c.End_Date == null))
.FirstOrDefault();
//if (fs == null)
//{
// return NotFound();
//}
return(Ok(fs));
}
catch (Exception e)
{
String.Format("Ошибка выполнения метода API:GetOpenFuelSale(num={0})", num).SaveError(e);
return(NotFound());
}
}
public IHttpActionResult GetFuelSale(int id)
{
try
{
FuelSale fs = this.ef_fs.Get()
.Where(c => c.id == id)
.FirstOrDefault();
if (fs == null)
{
return(NotFound());
}
return(Ok(fs));
}
catch (Exception e)
{
String.Format("Ошибка выполнения метода API:GetFuelSale(id={0})", id).SaveError(e);
return(NotFound());
}
}
public int GetOpenFuelSaleOfNum(int num)
{
try
{
FuelSale fs_open = null;
if (num <= 29)
{
// пистолет
fs_open = this.ef_fs.Get().Where(c => c.close == null && c.num == num && c.trk_num <= 9)
.ToList()
.Select(s => new FuelSale
{
id = s.id,
operator_name = s.operator_name,
smena_num = s.smena_num,
smena_datetime = s.smena_datetime,
trk_num = s.trk_num,
side = s.side,
num = s.num,
fuel_type = s.fuel_type,
tank_num = s.tank_num,
id_card = s.id_card,
dose = s.dose,
passage = s.passage,
volume = s.volume,
mass = s.mass,
start_datetime = s.start_datetime,
start_level = s.start_level,
start_volume = s.start_volume,
start_density = s.start_density,
start_mass = s.start_mass,
start_temp = s.start_temp,
start_water_level = s.start_water_level,
start_counter = s.start_counter,
stop_datetime = s.stop_datetime,
stop_level = s.stop_level,
stop_volume = s.stop_volume,
stop_density = s.stop_density,
stop_mass = s.stop_mass,
stop_temp = s.stop_temp,
stop_water_level = s.stop_water_level,
stop_counter = s.stop_counter,
close = s.close,
id_sap = s.id_sap,
}).FirstOrDefault();
}
if (num > 29)
{
// НС
fs_open = this.ef_fs.Get().Where(c => c.close == null && c.num == (num - 29) && c.trk_num > 9)
.ToList()
.Select(s => new FuelSale
{
id = s.id,
operator_name = s.operator_name,
smena_num = s.smena_num,
smena_datetime = s.smena_datetime,
trk_num = s.trk_num,
side = s.side,
num = s.num,
fuel_type = s.fuel_type,
tank_num = s.tank_num,
id_card = s.id_card,
dose = s.dose,
passage = s.passage,
volume = s.volume,
mass = s.mass,
start_datetime = s.start_datetime,
start_level = s.start_level,
start_volume = s.start_volume,
start_density = s.start_density,
start_mass = s.start_mass,
start_temp = s.start_temp,
start_water_level = s.start_water_level,
start_counter = s.start_counter,
stop_datetime = s.stop_datetime,
stop_level = s.stop_level,
stop_volume = s.stop_volume,
stop_density = s.stop_density,
stop_mass = s.stop_mass,
stop_temp = s.stop_temp,
stop_water_level = s.stop_water_level,
stop_counter = s.stop_counter,
close = s.close,
id_sap = s.id_sap,
}).FirstOrDefault();
}
if (fs_open == null)
{
return(0);
}
return(fs_open.id);
}
catch (Exception e)
{
String.Format("Ошибка выполнения метода API:GetOpenFuelSaleOfNum()").SaveError(e);
return(-1);
}
}
