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} // "; }