public List <Contact> GetList()
{
using (Data.DBContext db = new Data.DBContext())
{
return((from x in db.Contacts select x).ToList());
}
}
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());
}
}
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);
}
}
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);
}
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);
}
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);
}