public string Add(Rzdppk.Model.PlaneBrigadeTrain input)
{
return($@"
insert into {Table}
(PlanedRouteTrainId, StantionEndId, StantionStartId, UserId)
values
({input.PlanedRouteTrainId}, '{input.StantionEndId}', {input.StantionStartId} , '{input.UserId}')
SELECT SCOPE_IDENTITY()
");
}
public string Update(Rzdppk.Model.PlaneBrigadeTrain input)
{
return($@"
update {Table} set
PlanedRouteTrainId = '{input.PlanedRouteTrainId}',
StantionEndId = '{input.StantionEndId}',
StantionStartId = '{input.StantionStartId}',
UserId = {input.UserId}
where id = {input.Id}
");
}