public IHttpActionResult PutContact(ContactViewModel contact)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new ContactDatabaseEntities())
{
var existingContact = ctx.Tables.Where(s => s.ContactID == contact.ContactID)
.FirstOrDefault <Table>();
if (existingContact != null)
{
existingContact.FirstName = contact.FirstName;
existingContact.LastName = contact.LastName;
existingContact.Status = contact.Status;
existingContact.Email = contact.Email;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public IHttpActionResult DeleteContact(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid student id"));
}
using (var ctx = new ContactDatabaseEntities())
{
var contact = ctx.Tables
.Where(s => s.ContactID == id)
.FirstOrDefault();
ctx.Entry(contact).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostContact(ContactViewModel contact)
{
if (!ModelState.IsValid)
{
return(BadRequest("Data not formated"));
}
using (var cnt = new ContactDatabaseEntities())
{
cnt.Tables.Add(new Table()
{
FirstName = contact.FirstName,
LastName = contact.LastName,
Status = contact.Status,
PhoneNumber = contact.PhoneNumber,
Email = contact.Email,
});
cnt.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetContactByID(int id)
{
ContactViewModel contact = null;
using (var cont = new ContactDatabaseEntities())
{
contact = cont.Tables.Select(a => new ContactViewModel()
{
ContactID = a.ContactID,
FirstName = a.FirstName,
LastName = a.LastName,
Email = a.Email,
PhoneNumber = a.PhoneNumber,
Status = a.Status
}).Where(a => a.ContactID == id).FirstOrDefault <ContactViewModel>();
if (contact == null)
{
return(NotFound());
}
return(Ok(contact));
}
}
public IHttpActionResult GetAllContact()
{
IList <ContactViewModel> contacts = null;
using (var cont = new ContactDatabaseEntities())
{
contacts = cont.Tables.Select(a => new ContactViewModel()
{
ContactID = a.ContactID,
FirstName = a.FirstName,
LastName = a.LastName,
Email = a.Email,
PhoneNumber = a.PhoneNumber,
Status = a.Status
}).ToList <ContactViewModel>();
if (contacts.Count == 0)
{
return(NotFound());
}
return(Ok(contacts));
}
}
