public bool SpecialOfferUpdate(SpecialOffer specialoffer)
        {
            return Execute<bool>(dal =>
            {
                SpecialOffer specialofferUpdate = dal.SpecialOffer.Where(x => x.SpecialOfferID == specialoffer.SpecialOfferID).FirstOrDefault();
                if (specialofferUpdate != null)
                {
                    specialofferUpdate.SpecialOfferID = specialoffer.SpecialOfferID;
                    specialofferUpdate.Description = specialoffer.Description;
                    specialofferUpdate.DiscountPct = specialoffer.DiscountPct;
                    specialofferUpdate.Type = specialoffer.Type;
                    specialofferUpdate.Category = specialoffer.Category;
                    specialofferUpdate.StartDate = specialoffer.StartDate;
                    specialofferUpdate.EndDate = specialoffer.EndDate;
                    specialofferUpdate.MinQty = specialoffer.MinQty;
                    specialofferUpdate.MaxQty = specialoffer.MaxQty;
                    specialofferUpdate.rowguid = specialoffer.rowguid;
                    specialofferUpdate.ModifiedDate = specialoffer.ModifiedDate;

                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool SpecialOfferDelete(SpecialOffer specialoffer)
        {
            return Execute<bool>(dal =>
            {
                SpecialOffer specialofferDelete = dal.SpecialOffer.Where(x => x.SpecialOfferID == specialoffer.SpecialOfferID).FirstOrDefault();
                if (specialofferDelete != null)
                {
                    dal.SpecialOffer.DeleteOnSubmit(specialofferDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
 partial void DeleteSpecialOffer(SpecialOffer instance);
 partial void UpdateSpecialOffer(SpecialOffer instance);
 partial void InsertSpecialOffer(SpecialOffer instance);
 public void SpecialOfferUpdate(SpecialOffer specialoffer)
 {
     adventureWorks_BC.SpecialOfferUpdate(specialoffer);
 }
 public void SpecialOfferAdd(SpecialOffer specialoffer)
 {
     adventureWorks_BC.SpecialOfferAdd(specialoffer);
 }