/// <summary>
/// Method to Delete Record
/// </summary>
/// <returns></returns>
public Boolean Delete()
{
using (SGGSEntities context = new SGGSEntities())
{
SGGS_GROUP group = context.SGGS_GROUP.Where(x => x.GROUP_ID == GROUP_ID).FirstOrDefault();
context.SGGS_GROUP.DeleteObject(group);
context.SaveChanges();
return(true);
}
}
/// <summary>
/// Static method to get GroupCode for a specified groupID
/// </summary>
/// <param name="db"></param>
/// <param name="groupCode"></param>
/// <returns></returns>
public static string GetGroupCode(long groupID)
{
using (SGGSEntities context = new SGGSEntities())
{
SGGS_GROUP publisher = context.SGGS_GROUP.Where(x => x.GROUP_ID == groupID).FirstOrDefault();
if (publisher != null)
{
return(publisher.GROUP_CODE);
}
return(string.Empty);
}
}
/// <summary>
/// Method to update a record
/// </summary>
/// <returns></returns>
public Boolean Save()
{
using (SGGSEntities context = new SGGSEntities())
{
SGGS_GROUP group = context.SGGS_GROUP.Where(x => x.GROUP_ID == GROUP_ID).FirstOrDefault();
group.DATE_UPDATED = DateTime.Now;
group.DEFAULT_PUBLISHER_NUMBER = DEFAULT_PUBLISHER_NUMBER;
group.GROUP_CODE = GROUP_CODE;
group.GROUP_DESCRIPTION = GROUP_DESCRIPTION;
group.GROUP_NAME = GROUP_NAME;
context.SaveChanges();
return(true);
}
}
/// <summary>
/// Update a group publisher
/// </summary>
/// <param name="publisherNumber"></param>
/// <param name="billToPublisherNumber"></param>
/// <returns></returns>
public bool UpdateGroupPublishers(string publisherNumber, string billToPublisherNumber)
{
using (SGGSEntities context = new SGGSEntities())
{
SGGS_GROUP group = context.SGGS_GROUP.Where(x => x.GROUP_ID == this.GROUP_ID).FirstOrDefault();
if (group != null)
{
group.DEFAULT_PUBLISHER_NUMBER = publisherNumber;
group.DEFAULT_BILL_TO_PUBLISHER_NUMBER = billToPublisherNumber;
context.SaveChanges();
return(true);
}
return(false);
}
}
/// <summary>
/// Method to insert record in Group Table
/// </summary>
/// <returns></returns>
public Boolean Add()
{
using (SGGSEntities context = new SGGSEntities())
{
SGGS_GROUP group = new SGGS_GROUP();
group.DATE_ADDED = DateTime.Now;
group.DATE_UPDATED = DateTime.Now;
group.DEFAULT_PUBLISHER_NUMBER = DEFAULT_PUBLISHER_NUMBER;
group.GROUP_CODE = GROUP_CODE;
group.GROUP_DESCRIPTION = GROUP_DESCRIPTION;
group.GROUP_NAME = GROUP_NAME;
context.SGGS_GROUP.AddObject(group);
context.SaveChanges();
GROUP_ID = group.GROUP_ID;
return(true);
}
}
