public Contact GetContactByID(int id)
{
using (ContactDbEntities db = new ContactDbEntities())
{
return(db.Contacts.Find(id));
}
}
public List <Contact> GetAll()
{
using (ContactDbEntities db = new ContactDbEntities())
{
return(db.Contacts.ToList());
}
}
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 IList <ContactViewModel> GetAllContactsDAL()
{
IList <ContactViewModel> contacts = null;
using (var ctx = new ContactDbEntities())
{
contacts = ctx.Contacts
.Select(s => new ContactViewModel()
{
Id = s.Id,
FirstName = s.First_Name,
LastName = s.Last_Name,
Email = s.Email,
PhoneNumber = s.Phone_Number,
Status = s.Status
}).ToList <ContactViewModel>();
}
return(contacts);
}
public ContactViewModel GetContactByIdDAL(int id)
{
ContactViewModel contact = null;
using (var ctx = new ContactDbEntities())
{
contact = ctx.Contacts
.Where(s => s.Id == id)
.Select(s => new ContactViewModel()
{
Id = s.Id,
FirstName = s.First_Name,
LastName = s.Last_Name,
Email = s.Email,
PhoneNumber = s.Phone_Number,
Status = s.Status
}).FirstOrDefault <ContactViewModel>();
}
return(contact);
}
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);
}
}
}
