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