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