public async Task <ChangePlaneBrigadeTrain> Update(ChangePlaneBrigadeTrain input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
await conn.ExecuteAsync(_sql.Update(input));
return(await ById(input.Id));
}
}
public async Task <ChangePlaneBrigadeTrain> Add(ChangePlaneBrigadeTrain input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var id = await conn.QueryFirstOrDefaultAsync <int>(_sql.Add(input));
return(await ById(id));
}
}
public string Add(ChangePlaneBrigadeTrain input)
{
return($@"
insert into {Table}
(ChangeDate, ChangeUserId, Droped, PlaneBrigadeTrainId, StantionEndId, StantionStartId, UserId)
values
('{input.ChangeDate}', '{input.ChangeUserId}', '{input.Droped}', '{input.PlaneBrigadeTrainId}', '{input.StantionEndId}', '{input.StantionStartId}', '{input.UserId}')
SELECT SCOPE_IDENTITY()
");
}
public async Task <JsonResult> AddOrUpdate([FromBody] ChangePlaneBrigadeTrain input)
{
await CheckPermission();
var sqlR = new ChangePlaneBrigadeTrainsRepository(_logger);
if (input.Id == 0)
{
return(Json(await sqlR.Add(input)));
}
return(Json(await sqlR.Update(input)));
}
public ChangePlaneBrigadeTrainDto ToDto(ChangePlaneBrigadeTrain input)
{
var dto = new ChangePlaneBrigadeTrainDto
{
Id = input.Id,
StartId = input.StantionStartId,
EndId = input.StantionEndId,
UserId = input.UserId,
PlaneBrigadeTrainId = input.PlaneBrigadeTrainId,
Canseled = input.Droped
};
return(dto);
}
public ChangePlaneBrigadeTrain ToEntity(ChangePlaneBrigadeTrainDto input)
{
var entity = new ChangePlaneBrigadeTrain
{
Id = input.Id,
StantionStartId = input.StartId,
StantionEndId = input.EndId,
UserId = input.UserId,
PlaneBrigadeTrainId = input.PlaneBrigadeTrainId,
Droped = input.Canseled
};
return(entity);
}
public string Update(ChangePlaneBrigadeTrain input)
{
return($@"
update {Table} set
ChangeDate = '{input.ChangeDate}',
ChangeUserId = '{input.ChangeUserId}',
Droped = '{input.Droped}' ,
PlaneBrigadeTrainId = {input.PlaneBrigadeTrainId} ,
StantionEndId = {input.StantionEndId},
StantionStartId = {input.StantionStartId},
UserId = {input.UserId},
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}
// ";
}
