public static AgregCgpModel Ag_upsideo_cgpToModel(ag_upsideo_cgp cgp)
 {
     return new AgregCgpModel
     {
         IdCgp = cgp.idcgp,
         IdCrmCabinet = cgp.idcrmcabinet,
         PrenomCgp = cgp.prenomcgp,
         NomCgp = cgp.nomcgp
     };
 }
 public static void AddCgp(ag_upsideo_cgp cgp)
 {
     try
     {
         using (Data.Model.UpsilabEntities context = new UpsilabEntities())
         {
             context.ag_upsideo_cgp.AddObject(cgp);
             context.SaveChanges();
         }
     }
     catch (Exception e)
     {
         Log.Log.AppendException(e);
         throw new Exception("SavingError");
     }
 }
        public static void UpdateCgp(ag_upsideo_cgp cgp)
        {
            try
            {
                using (Data.Model.UpsilabEntities context = new UpsilabEntities())
                {
                    var cgptoupdate = context.ag_upsideo_cgp.Where(c => c.idcgp == cgp.idcgp).FirstOrDefault();
                    cgptoupdate.nomcgp = cgp.nomcgp;
                    cgptoupdate.prenomcgp = cgp.prenomcgp;

                    context.SaveChanges();
                }
            }
            catch (Exception e)
            {
                Log.Log.AppendException(e);
                throw new Exception("SavingError");
            }
        }