public static List<AdvertisementReply> GetAdvertisementReplies(int advertisementId, UmbracoDatabase db)
{
var query = new Sql().Select("*").From("JobsplusAdvertisementReply").Where("AdvertisementId = " + advertisementId);
return db.Fetch<AdvertisementReply>(query);
}
private static OrderData GetOrCreateOrderWithGuid(Guid orderId, UmbracoDatabase db)
{
var fetch = db.Fetch<OrderData>(new Sql().Select("*").From("uWebshopOrders").Where((OrderData o) => o.UniqueId == orderId)).FirstOrDefault() ?? new OrderData {CreateDate = DateTime.Now};
return fetch;
}
public static AdvertisementReply Get(int id, UmbracoDatabase db)
{
var query = new Sql().Select("*").From("JobsplusAdvertisementReply").Where("Id = " + id);
return db.Fetch<AdvertisementReply>(query).FirstOrDefault();
}