Example #1
0
 public List <Contact> GetList()
 {
     using (Data.DBContext db = new Data.DBContext())
     {
         return((from x in db.Contacts select x).ToList());
     }
 }
Example #2
0
        public AreaProfesional()
        {
            using (var context = new Data.DBContext())
            {
                //context.AreasProfesionales.Add( new Model.AreaProfesional { Codigo = "IFCD", Denominacion = "Desarrollo" } );
                //context.AreasProfesionales.Add( new Model.AreaProfesional { Codigo = "IFCM", Denominacion = "Comunicaciones" } );
                //context.AreasProfesionales.Add( new Model.AreaProfesional { Codigo = "IFCT", Denominacion = "Sistemas y telemática" } );
                //context.SaveChanges();

                this.AreasProfesionales = new ObservableCollection <Model.AreaProfesional>(context.AreasProfesionales.AsEnumerable());
            }
        }
Example #3
0
 public Contact GetById(int Id)
 {
     try
     {
         using (Data.DBContext db = new Data.DBContext())
         {
             Contact record = (from x in db.Contacts where x.Id == Id select x).FirstOrDefault();
             return(record);
         }
     }
     catch (Exception)
     {
         return(null);
     }
 }
Example #4
0
        public bool Delete(ContactViewModel cvm)
        {
            try
            {
                using (Data.DBContext db = new Data.DBContext())
                {
                    Contact record = (from x in db.Contacts where x.Id == cvm.Id select x).FirstOrDefault();
                    db.Contacts.DeleteOnSubmit(record);
                    db.SubmitChanges();
                }
            }
            catch (Exception)
            {
                return(false);
            }

            return(true);
        }
Example #5
0
        public bool Update(ContactViewModel cvm)
        {
            try
            {
                using (Data.DBContext db = new Data.DBContext())
                {
                    Contact record = (from x in db.Contacts where x.Id == cvm.Id select x).FirstOrDefault();
                    record.FirstName    = cvm.FirstName;
                    record.LastName     = cvm.LastName;
                    record.EmailAddress = cvm.EmailAddress;
                    record.Message      = cvm.Message;
                    record.LastUpdated  = DateTime.Now;
                    db.SubmitChanges();
                }
            }
            catch (Exception)
            {
                return(false);
            }

            return(true);
        }
Example #6
0
        public int?Create(ContactViewModel cvm)
        {
            int?id = null;

            using (Data.DBContext db = new Data.DBContext())
            {
                Contact record = new Contact
                {
                    FirstName    = cvm.FirstName,
                    LastName     = cvm.LastName,
                    EmailAddress = cvm.EmailAddress,
                    Message      = cvm.Message,
                    Created      = DateTime.Now,
                    LastUpdated  = null
                };

                db.Contacts.InsertOnSubmit(record);
                db.SubmitChanges();
                id = record.Id;
            }
            return(id);
        }