public async Task <ChangePlaneStantionOnTrip> Add(ChangePlaneStantionOnTrip input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var id = await conn.QueryFirstOrDefaultAsync <int>(_sql.Add(input));
return(await ById(id));
}
}
public async Task <ChangePlaneStantionOnTrip> Update(ChangePlaneStantionOnTrip input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
await conn.ExecuteAsync(_sql.Update(input));
return(await ById(input.Id));
}
}
public ChangePlaneStantionOnTrip ToEntity(ChangePlaneStantionOnTripDto input)
{
var entity = new ChangePlaneStantionOnTrip
{
TrainId = input.TrainId,
InTime = input.StartFact,
OutTime = input.EndFact,
Droped = input.Canceled,
PlaneStantionOnTripId = input.PlaneStationOnTripId
};
return(entity);
}
public ChangePlaneStantionOnTripDto ToDto(ChangePlaneStantionOnTrip input)
{
var dto = new ChangePlaneStantionOnTripDto
{
TrainId = input.TrainId,
StartFact = input.InTime,
EndFact = input.OutTime,
Canceled = input.Droped,
PlaneStationOnTripId = input.PlaneStantionOnTripId
};
return(dto);
}
public async Task <JsonResult> AddOrUpdate([FromBody] ChangePlaneStantionOnTrip input)
{
await CheckPermission();
if (input.InTime >= input.OutTime)
{
throw new ValidationException("Время начала, больше времени конца");
}
var sqlR = new ChangePlaneStantionOnTripsRepository(_logger);
if (input.Id == 0)
{
return(Json(await sqlR.Add(input)));
}
return(Json(await sqlR.Update(input)));
}
public string Add(ChangePlaneStantionOnTrip input)
{
return($@"
insert into {Table}
(ChangeUserId,
Droped,
InTime,
OutTime,
PlaneStantionOnTripId,
TrainId
)
values
('{input.ChangeUserId}',
'{input.Droped}',
'{input.InTime}',
'{input.OutTime}',
'{input.PlaneStantionOnTripId}',
'{input.TrainId}')
SELECT SCOPE_IDENTITY()
");
}
public string Update(ChangePlaneStantionOnTrip input)
{
// if (input.CheckListType == null)
return($@"
update {Table} set
ChangeUserId = '{input.ChangeUserId}',
Droped = '{input.Droped}',
InTime = '{input.InTime}' ,
OutTime = '{input.OutTime}' ,
PlaneStantionOnTripId = {input.PlaneStantionOnTripId},
TrainId = {input.TrainId},
UpdateDate = CURRENT_TIMESTAMP
where id = {input.Id}
");
//return $@"
// update {Table} set
// ChangeDate = '{input.ChangeDate}', ChangeUserId = '{input.ChangeUserId}', CheckListType = {input.CheckListType},
// Droped = {input.Droped} , End = {input.End} , PlanedInspectionRouteId = {input.PlanedInspectionRouteId}, Start = {input.Start}
// where id = {input.Id}
// ";
}
