/// <summary>
/// Generic Delete method for the entities
/// </summary>
/// <param name="entityToDelete"></param>
public virtual void Delete(TEntity entityToDelete)
{
if (Context.Entry(entityToDelete).State == EntityState.Detached)
{
DbSet.Attach(entityToDelete);
}
DbSet.Remove(entityToDelete);
}
public IHttpActionResult PutContactsTable(int id, ContactsTable contactsTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != contactsTable.ContactsId)
{
return(BadRequest());
}
db.Entry(contactsTable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ContactsTableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public int SaveContact(int?ID, string contact)
{
JObject jContact = JObject.Parse(contact);
string Fname = (string)jContact["Fname"];
string Lname = (string)jContact["Lname"];
Contact contactModel = new Contact();
contactModel.Id = (int)ID;
contactModel.Fname = Fname;
contactModel.Lname = Lname;
using (ContactsEntities db = new ContactsEntities()) {
if (ID == 0)
{
db.Contacts.Add(contactModel);
db.SaveChanges();
}
else
{
db.Entry(contactModel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return((int)ID);
}
}
public ActionResult Edit([Bind(Include = "ID,Name,City,PostalCode")] Address address)
{
if (ModelState.IsValid)
{
db.Entry(address).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(address));
}
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,DateOfBirth,Email,PhoneNumber,AddressID")] Contact contact)
{
if (ModelState.IsValid)
{
db.Entry(contact).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AddressID = new SelectList(db.Addresses, "ID", "Name", contact.AddressID);
return(View(contact));
}
public bool DeleteContact(Person contact)
{
if (contact.Id > 0)
{
using (ContactsEntities context = new ContactsEntities())
{
context.Persons.Attach(contact);
context.Entry(contact).State = EntityState.Deleted;
context.SaveChanges();
}
return(true);
}
return(false);
}
public int SaveContact(Person contact)
{
using (ContactsEntities context = new ContactsEntities())
{
if (contact.Id > 0)
{
context.Persons.Attach(contact);
context.Entry(contact).State = EntityState.Modified;
context.SaveChanges();
}
else
{
context.Persons.Add(contact);
context.SaveChanges();
}
}
return(contact.Id);
}
