public int DeleteContact(int id)
{
using (EvolentTestEntities dbContext = new EvolentTestEntities())
{
int entriesAffected = 0;
var objContact = dbContext.tblContacts.SingleOrDefault(c => c.Id == id);
if (objContact != null)
{
objContact.Status = false;
entriesAffected = dbContext.SaveChanges();
}
return(entriesAffected);
}
}
public int AddContact(ContactEntity contact)
{
using (EvolentTestEntities dbContext = new EvolentTestEntities())
{
dbContext.tblContacts.Add(new tblContact()
{
Email = contact.Email,
FirstName = contact.FirstName,
LastName = contact.LastName,
PhoneNumber = contact.PhoneNumber,
Status = contact.Status
});
int entriesAffected = dbContext.SaveChanges();
return(entriesAffected);
}
}
public int UpdateContact(ContactEntity contact)
{
using (EvolentTestEntities dbContext = new EvolentTestEntities())
{
int entriesAffected = 0;
var objContact = dbContext.tblContacts.SingleOrDefault(c => c.Id == contact.Id);
if (objContact != null)
{
objContact.FirstName = contact.FirstName;
objContact.LastName = contact.LastName;
objContact.PhoneNumber = contact.PhoneNumber;
objContact.Email = contact.Email;
entriesAffected = dbContext.SaveChanges();
}
return(entriesAffected);
}
}
public IEnumerable <ContactEntity> GetAllContacts()
{
IEnumerable <ContactEntity> lstContact;
using (EvolentTestEntities dbContext = new EvolentTestEntities())
{
var contacts = dbContext.tblContacts.Where(c => c.Status == true).ToList();
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <tblContact, ContactEntity>();
});
IMapper imapper = config.CreateMapper();
lstContact = contacts.Select(imapper.Map <tblContact, ContactEntity>);
return(lstContact);
}
}
