public IHttpActionResult PutContact(int id, Contact contact)
{
if (id != contact.Id)
{
return(BadRequest());
}
db.Entry(contact).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ContactExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void InsertContact(Contact contact)
{
int?nextID = 0;
contact.contactid = nextID.GetValueOrDefault() + 1;
db.Contacts.Add(contact);
db.SaveChanges();
}
public ActionResult Create(Contact contact)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
public Contact Add(Contact item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
ContactDB.Contacts.Add(item);
ContactDB.SaveChanges();
return(item);
}
public HttpResponseMessage SaveContact(tblContact a_contact)
{
int result = 0;
try
{
dbContext.tblContacts.Add(a_contact);
dbContext.SaveChanges();
result = 1;
}
catch (Exception e)
{
result = 0;
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
// POST api/Contacts
public HttpResponseMessage PostContact([FromBody] Contact contact)
{
if (ModelState.IsValid)
{
try
{
using (ContactDBEntities entities = new ContactDBEntities())
{
entities.Contacts.Add(contact);
entities.SaveChanges();
}
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, contact);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = contact.Id }));
return(response);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public void UpdateContact(ContactModel contact)
{
using (ContactDBEntities db = new ContactDBEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
ContactView CT = db.ContactViews.Find(contact.ContactID);
CT.FirstName = contact.FirstName;
CT.LastName = contact.LastName;
CT.Phone = contact.Phone;
CT.Email = contact.Email;
CT.Street = contact.Street;
CT.City = contact.City;
CT.State = contact.State;
CT.PostalCode = contact.PostalCode;
CT.DisplayName = contact.DisplayName;
db.SaveChanges();
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
public void AddContact(ContactModel contact)
{
using (ContactDBEntities db = new ContactDBEntities())
{
ContactView CT = new ContactView();
CT.FirstName = contact.FirstName;
CT.LastName = contact.LastName;
CT.Phone = contact.Phone;
CT.Email = contact.Email;
CT.Street = contact.Street;
CT.City = contact.City;
CT.State = contact.State;
CT.PostalCode = contact.PostalCode;
db.ContactViews.Add(CT);
db.SaveChanges();
}
}
/// <summary>
/// Save method.
/// </summary>
public void Save()
{
try
{
_context.SaveChanges();
}
catch (DbEntityValidationException e)
{
var outputLines = new List <string>();
foreach (var eve in e.EntityValidationErrors)
{
outputLines.Add(string.Format("{0}: Entity of type \"{1}\" in state \"{2}\" has the following validation errors:", DateTime.Now, eve.Entry.Entity.GetType().Name, eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
outputLines.Add(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage));
}
}
System.IO.File.AppendAllLines(@"C:\errors.txt", outputLines);
throw e;
}
}
// DELETE api/Contacts/5
public HttpResponseMessage DeleteContact(int id)
{
Contact contact = db.Contacts.Find(id);
if (contact == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
db.Contacts.Remove(contact);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK, contact));
}
// PUT api/Contacts/5
public HttpResponseMessage PutContact(int id, Contact contact)
{
if (ModelState.IsValid && id == contact.Id)
{
try
{
using (ContactDBEntities entities = new ContactDBEntities())
{
var contactEntity = entities.Contacts.FirstOrDefault(e => e.Id == id);
if (contactEntity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id= " + id.ToString() + " not found"));
}
else
{
contactEntity.FirstName = contact.FirstName;
contactEntity.LastName = contact.LastName;
contactEntity.Email = contact.Email;
contactEntity.PhoneNumber = contact.PhoneNumber;
contactEntity.Status = contact.Status;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, contactEntity));
}
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public void DeleteUser(int contactID)
{
using (ContactDBEntities db = new ContactDBEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var CT = db.ContactViews.Where(o => o.ContactID == contactID);
if (CT.Any())
{
db.ContactViews.Remove(CT.FirstOrDefault());
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
public void Commit()
{
_db.SaveChanges();
_transaction.Complete();
}