public carrot_FaqItem FaqItemGetByID(Guid faqItemID)
{
carrot_FaqItem ff = (from f in db.carrot_FaqItems
where f.FaqItemID == faqItemID
select f).FirstOrDefault();
return(ff);
}
public carrot_FaqItem Save(carrot_FaqItem item)
{
if (item.FaqItemID == Guid.Empty)
{
item.FaqItemID = Guid.NewGuid();
}
if (!db.carrot_FaqItems.Where(x => x.FaqItemID == item.FaqItemID).Any())
{
db.carrot_FaqItems.InsertOnSubmit(item);
}
db.SubmitChanges();
return(item);
}
public carrot_FaqItem FaqItemListPublicRandGetByFaqCategoryID(Guid faqCategoryID, Guid siteID)
{
Random rand = new Random();
int toSkip = rand.Next(0, (from f in db.carrot_FaqItems
join fc in db.carrot_FaqCategories on f.FaqCategoryID equals fc.FaqCategoryID
where f.FaqCategoryID == faqCategoryID &&
f.IsActive == true && fc.SiteID == siteID
orderby f.ItemOrder
select f).Count());
carrot_FaqItem ff = (from f in db.carrot_FaqItems
join fc in db.carrot_FaqCategories on f.FaqCategoryID equals fc.FaqCategoryID
where f.FaqCategoryID == faqCategoryID &&
f.IsActive == true && fc.SiteID == siteID
orderby f.ItemOrder
select f).Skip(toSkip).FirstOrDefault();
return(ff);
}
private void detach_carrot_FaqItems(carrot_FaqItem entity)
{
this.SendPropertyChanging();
entity.carrot_FaqCategory = null;
}
partial void Deletecarrot_FaqItem(carrot_FaqItem instance);
partial void Updatecarrot_FaqItem(carrot_FaqItem instance);
partial void Insertcarrot_FaqItem(carrot_FaqItem instance);