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