protected void btnSaveButton_Click(object sender, EventArgs e) { bool bAdd = false; using (CalendarDataContext db = CalendarDataContext.GetDataContext()) { var itm = (from c in db.carrot_CalendarEventCategories where c.CalendarEventCategoryID == ItemGuid select c).FirstOrDefault(); if (itm == null) { bAdd = true; ItemGuid = Guid.NewGuid(); itm = new carrot_CalendarEventCategory(); itm.CalendarEventCategoryID = ItemGuid; itm.SiteID = SiteID; } itm.CategoryName = txtCategoryName.Text; itm.CategoryFGColor = ddlFGColor.SelectedValue; itm.CategoryBGColor = ddlBGColor.SelectedValue; if (bAdd) { db.carrot_CalendarEventCategories.InsertOnSubmit(itm); } db.SubmitChanges(); } Response.Redirect(CreateLink(ModuleName, String.Format("id={0}", ItemGuid))); }
public static List<carrot_CalendarEventCategory> GetCalendarCategories(Guid siteID) { using (CalendarDataContext db = CalendarDataContext.GetDataContext()) { if (!db.carrot_CalendarEventCategories.Where(x => x.SiteID == siteID).Any()) { carrot_CalendarEventCategory itm = new carrot_CalendarEventCategory(); itm = new carrot_CalendarEventCategory(); itm.CalendarEventCategoryID = Guid.NewGuid(); itm.SiteID = siteID; itm.CategoryName = "Default"; itm.CategoryFGColor = HEX_Black; itm.CategoryBGColor = HEX_White; db.carrot_CalendarEventCategories.InsertOnSubmit(itm); db.SubmitChanges(); } return (from c in db.carrot_CalendarEventCategories orderby c.CategoryName where c.SiteID == siteID select c).ToList(); } }
partial void Deletecarrot_CalendarEventCategory(carrot_CalendarEventCategory instance);
partial void Insertcarrot_CalendarEventCategory(carrot_CalendarEventCategory instance);