/// <summary>
        /// Adds the specified site event template activity.
        /// </summary>
        /// <param name="siteEventTemplateActivity">The site event template activity.</param>
        /// <returns></returns>
        public tbl_SiteEventTemplateActivity Add(tbl_SiteEventTemplateActivity siteEventTemplateActivity)
        {
            siteEventTemplateActivity.ID = Guid.NewGuid();
            _dataContext.tbl_SiteEventTemplateActivity.AddObject(siteEventTemplateActivity);
            _dataContext.SaveChanges();

            return(siteEventTemplateActivity);
        }
        /// <summary>
        /// Updates the specified site event template activity.
        /// </summary>
        /// <param name="siteEventTemplateActivity">The site event template activity.</param>
        public void Update(tbl_SiteEventTemplateActivity siteEventTemplateActivity)
        {
            var updateSiteEventTemplateActivity = SelectById(siteEventTemplateActivity.SiteID, siteEventTemplateActivity.ID);

            updateSiteEventTemplateActivity.SiteEventTemplateID = siteEventTemplateActivity.SiteEventTemplateID;
            updateSiteEventTemplateActivity.EventCategoryID     = siteEventTemplateActivity.EventCategoryID;
            updateSiteEventTemplateActivity.ActivityTypeID      = siteEventTemplateActivity.ActivityTypeID;
            updateSiteEventTemplateActivity.ActivityCode        = siteEventTemplateActivity.ActivityCode;
            updateSiteEventTemplateActivity.ActualPeriod        = siteEventTemplateActivity.ActualPeriod;
            updateSiteEventTemplateActivity.Option    = siteEventTemplateActivity.Option;
            updateSiteEventTemplateActivity.FormulaID = siteEventTemplateActivity.FormulaID;
            updateSiteEventTemplateActivity.Value     = siteEventTemplateActivity.Value;
            _dataContext.SaveChanges();
        }
 /// <summary>
 /// Deletes the specified site event template activity.
 /// </summary>
 /// <param name="siteEventTemplateActivity">The site event template activity.</param>
 public void Delete(tbl_SiteEventTemplateActivity siteEventTemplateActivity)
 {
     _dataContext.DeleteObject(siteEventTemplateActivity);
     _dataContext.SaveChanges();
 }