// DELETE api/values/5
public void Delete(int id)
{
using (var context = new MyFirstDBContext())
{
var associate = context.Set <Associate>().FirstOrDefault(a => a.Id == id);
context.Set <Associate>().Remove(associate);
}
}
// POST api/values
public void Post([FromBody] Associate value)
{
using (var context = new MyFirstDBContext())
{
context.Set <Associate>().Add(value);
context.SaveChanges();
}
}
// POST api/values
public void Post([FromBody] ContactInfo value)
{
using (var context = new MyFirstDBContext())
{
context.Set <ContactInfo>().Add(value);
context.SaveChanges();
}
}
// GET api/values/5
public AssociateModel Get(int id)
{
AssociateModel associateToReturn;
using (var context = new MyFirstDBContext())
{
var associate = context.Set <Associate>().FirstOrDefault(a => a.Id == id);
associateToReturn = CastAssociate(associate);
}
return(associateToReturn);
}
// GET api/values
public IEnumerable <AssociateModel> Get()
{
List <AssociateModel> associateList;
using (var context = new MyFirstDBContext())
{
associateList = context.Set <Associate>().ToList()
.ConvertAll(CastAssociate);
}
return(associateList);
}
// GET api/values/5
public ContactModel Get(int id)
{
ContactModel contactToReturn;
using (var context = new MyFirstDBContext())
{
var contact = context.Set <ContactInfo>().FirstOrDefault(c => c.Id == id);
contactToReturn = CastContactInfo(contact);
}
return(contactToReturn);
}
// GET api/values
public IEnumerable <ContactWithAssociateModel> Get()
{
List <ContactWithAssociateModel> contactList;
using (var context = new MyFirstDBContext())
{
contactList = context.Set <ContactInfo>()
.Include(ci => ci.Associate).ToList()
.ConvertAll(CastContactInfoWithAssociate);
}
return(contactList);
}