private Contact GetContactByID(int id)
{
Contact objContact = null;
try
{
using (EvolentDBEntities entity = new EvolentDBEntities())
{
objContact = entity.tblContacts
.Where(p => p.RecordId == id)
.Select(p => new Contact
{
RecordId = p.RecordId,
FirstName = p.FirstName,
LastName = p.LastName,
Email = p.Email,
PhoneNumber = p.PhoneNumber,
Status = p.Status
}).FirstOrDefault();
}
}
catch (Exception)
{
}
return(objContact);
}
public IHttpActionResult GetContacts()
{
List <Contact> lstContacts = null;
try
{
using (EvolentDBEntities entity = new EvolentDBEntities())
{
lstContacts = entity.tblContacts
.Select(s => new Contact()
{
RecordId = s.RecordId,
FirstName = s.FirstName,
LastName = s.LastName == null ? "" : s.LastName,
Email = s.Email,
PhoneNumber = s.PhoneNumber
}).ToList <Contact>();
}
}
catch (Exception ex)
{
return(InternalServerError());
}
return(Ok(lstContacts));
}
public int Remove(int id)
{
try
{
using (EvolentDBEntities context = new EvolentDBEntities())
{
status = context.DeleteContact(id);
}
}
catch (Exception ex)
{
//TODO:
}
return(status);
}
public int Update(Contact contact)
{
try
{
using (EvolentDBEntities context = new EvolentDBEntities())
{
status = context.UpdateContact(contact.Id, contact.FirstName, contact.LastName, contact.Email, contact.Phone, contact.IsActive == true ? "true" : "false");
}
}
catch (Exception ex)
{
throw ex;
//TODO:
}
return(status);
}
public JsonResult InsertCustomer(Contact contact)
{
try
{
using (EvolentDBEntities entities = new EvolentDBEntities())
{
entities.Contacts.Add(contact);
entities.SaveChanges();
}
return(Json(contact));
}
catch (Exception ex)
{
throw ex;
}
}
public Contact Add(Contact contact)
{
try
{
using (EvolentDBEntities context = new EvolentDBEntities())
{
status = context.CreateContact(contact.FirstName, contact.LastName, contact.Email, contact.Phone, contact.IsActive == true ? "true" : "false");
}
}
catch (Exception ex)
{
throw ex;
//TODO:
//ViewBag["Error"] = ex.Message.ToString();
}
return(contact);
}
public ActionResult DeleteCustomer(int UserID)
{
try
{
using (EvolentDBEntities entities = new EvolentDBEntities())
{
Contact customer = (from c in entities.Contacts
where c.UserID == UserID
select c).FirstOrDefault();
entities.Contacts.Remove(customer);
entities.SaveChanges();
}
return(new EmptyResult());
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult AddOrUpdateContact(Contact objContact)
{
using (EvolentDBEntities entity = new EvolentDBEntities())
{
if (objContact.RecordId == 0)
{
// Add
tblContact objtblContact = new tblContact()
{
FirstName = objContact.FirstName,
LastName = objContact.LastName,
Email = objContact.Email,
PhoneNumber = objContact.PhoneNumber,
Status = objContact.Status
};
entity.tblContacts.Add(objtblContact);
entity.SaveChanges();
objContact.RecordId = objtblContact.RecordId;
}
else
{
// Update
var objContactFromDB = entity.tblContacts
.Where(p => p.RecordId == objContact.RecordId)
.FirstOrDefault();
objContactFromDB.FirstName = objContact.FirstName;
objContactFromDB.LastName = objContact.LastName;
objContactFromDB.Email = objContact.Email;
objContactFromDB.PhoneNumber = objContact.PhoneNumber;
objContactFromDB.Status = objContact.Status;
entity.SaveChanges();
}
}
return(Ok(objContact));
}
public Contact Get(int id)
{
Contact fetchedContact = null;
try
{
fetchedContact = new Contact();
using (EvolentDBEntities context = new EvolentDBEntities())
{
var contact = context.GetContact(id);
fetchedContact = BuildContact(contact.Single());
}
}
catch (Exception ex)
{
throw ex;
//Handle Ex
}
return(fetchedContact);
}
public IEnumerable <Contact> GetAll()
{
List <Contact> contacts;
try
{
contacts = new List <Contact>();
using (EvolentDBEntities context = new EvolentDBEntities())
{
var records = context.GetAllContacts().ToList();
if (records.Any())
{
contacts = records.Select(BuildContactForList).ToList();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(contacts);
}
public ActionResult UpdateCustomer(Contact customer)
{
try
{
using (EvolentDBEntities entities = new EvolentDBEntities())
{
Contact updatedCustomer = (from c in entities.Contacts
where c.UserID == customer.UserID
select c).FirstOrDefault();
updatedCustomer.FirstName = customer.FirstName;
updatedCustomer.LastName = customer.LastName;
updatedCustomer.Email = customer.Email;
updatedCustomer.PhoneNo = customer.PhoneNo;
updatedCustomer.Status = customer.Status;
entities.SaveChanges();
}
return(new EmptyResult());
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetCustomers()
{
EvolentDBEntities entities = new EvolentDBEntities();
return(Json(entities.Contacts));
}
