public void UpdateHitcher(HitcherBase hitcher)
{
Requires.NotNull(hitcher);
Requires.NotNull(hitcher.RideId);
using (var context = DataContext.Instance())
{
var rep = context.GetRepository <HitcherBase>();
rep.Update("SET Accepted=@0, Comments=@1 WHERE RideId=@2 AND UserId=@3",
hitcher.Accepted, hitcher.Comments, hitcher.RideId, hitcher.UserId);
}
}
public void AddHitcher(HitcherBase hitcher)
{
Requires.NotNull(hitcher);
Requires.NotNull(hitcher.RideId);
using (var context = DataContext.Instance())
{
context.Execute(System.Data.CommandType.Text,
"IF NOT EXISTS (SELECT * FROM {databaseOwner}{objectQualifier}Connect_HitchARide_Hitchers " +
"WHERE RideId=@0 AND UserId=@1) " +
"INSERT INTO {databaseOwner}{objectQualifier}Connect_HitchARide_Hitchers (RideId, UserId, Accepted, Comments) " +
"SELECT @0, @1, @2, @3", hitcher.RideId, hitcher.UserId, hitcher.Accepted, hitcher.Comments);
}
}
public void DeleteHitcher(HitcherBase hitcher)
{
DeleteHitcher(hitcher.RideId, hitcher.UserId);
}
