public ActionResult Create(contactDb contactdb)
{
if (ModelState.IsValid)
{
contactdb.ID = db.contactDbs.ToList()[db.contactDbs.ToList().Count - 1].ID + 1;
db.contactDbs.Add(contactdb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contactdb));
}
public void Update(Contact contact)
{
using (ContactDbEntities db = new ContactDbEntities())
{
db.Contacts.Attach(contact);
db.Entry(contact).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public Contact Insert(Contact contact)
{
using (ContactDbEntities db = new ContactDbEntities())
{
db.Contacts.Add(contact);
db.SaveChanges();
return(contact);
}
}
public void Delete(Contact contact)
{
using (ContactDbEntities db = new ContactDbEntities())
{
db.Contacts.Attach(contact);
db.Contacts.Remove(contact);
db.SaveChanges();
}
}
public void DeleteContactDAL(int id)
{
using (var ctx = new ContactDbEntities())
{
var contact = ctx.Contacts
.Where(s => s.Id == id)
.FirstOrDefault();
ctx.Entry(contact).State = System.Data.EntityState.Deleted;
ctx.SaveChanges();
}
}
public void AddNewContactDAL(ContactViewModel contact)
{
using (var ctx = new ContactDbEntities())
{
ctx.Contacts.Add(new Contact()
{
Id = contact.Id,
First_Name = contact.FirstName,
Last_Name = contact.LastName,
Email = contact.Email,
Phone_Number = contact.PhoneNumber,
Status = contact.Status
});
ctx.SaveChanges();
}
}
public bool UpdateContactDAL(ContactViewModel contact)
{
using (var ctx = new ContactDbEntities())
{
var existingContact = ctx.Contacts.Where(s => s.Id == contact.Id)
.FirstOrDefault <Contact>();
if (existingContact != null)
{
existingContact.First_Name = contact.FirstName;
existingContact.Last_Name = contact.LastName;
existingContact.Email = contact.Email;
existingContact.Phone_Number = contact.PhoneNumber;
existingContact.Status = contact.Status;
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
