/// <summary> /// Add a new pubisher group /// </summary> /// <param name="groupID"></param> /// <param name="PUBLISHER_ID"></param> /// <returns></returns> public bool AddGroupPublishers(long groupID, long PUBLISHER_ID) { try { using (SGGSEntities context = new SGGSEntities()) { var group = context.SGGS_GROUP_PUBLISHER.Where(x => x.GROUP_ID == groupID && x.PUBLISHER_ID == PUBLISHER_ID).FirstOrDefault(); if (group == null) { SGGS_GROUP_PUBLISHER newGroup = new SGGS_GROUP_PUBLISHER(); newGroup.PUBLISHER_ID = PUBLISHER_ID; newGroup.GROUP_ID = groupID; newGroup.DATE_ADDED = DateTime.Now; newGroup.DATE_UPDATED = DateTime.Now; context.SGGS_GROUP_PUBLISHER.AddObject(newGroup); context.SaveChanges(); return(true); } return(false); } } catch { return(false); } }
/// <summary> /// Delete a publisher group /// </summary> /// <param name="groupID"></param> /// <param name="publisherID"></param> /// <returns></returns> public bool DeleteGroupPublisher(long groupID, long publisherID) { try { using (SGGSEntities context = new SGGSEntities()) { SGGS_GROUP_PUBLISHER group = context.SGGS_GROUP_PUBLISHER.Where(x => x.GROUP_ID == groupID && x.PUBLISHER_ID == publisherID).FirstOrDefault(); context.SGGS_GROUP_PUBLISHER.DeleteObject(group); context.SaveChanges(); return(true); } } catch { return(false); } }