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