public ActionResult EditContact(Contact c)
{
if (ModelState.IsValid)
{
using (AddressBookEntities dc = new AddressBookEntities())
{
var v = dc.Contacts.Where(a => a.Id.Equals(c.Id)).FirstOrDefault();
if (v != null)
{
v.Id = c.Id;
v.FirstName = c.FirstName;
v.LastName = c.LastName;
v.PhoneNumber = c.PhoneNumber;
v.StreetName = c.StreetName;
v.City = c.City;
v.Province = c.Province;
v.PostalCode = c.PostalCode;
v.Country = c.Country;
}
dc.SaveChanges();
}
return(RedirectToAction("AddressBook"));
}
else
{
List <Contact> contact = new List <Contact>();
contact.Add(c);
ViewBag.userdetails = contact;
return(View());
}
}
public HttpResponseMessage Put(int id, [FromBody] Contact updatedcontact)
{
try
{
using (AddressBookEntities entities = new AddressBookEntities())
{
var entity = entities.Contacts.FirstOrDefault(e => e.ID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id " + id + " not found"));
}
else
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
else
{
entity.Name = updatedcontact.Name;
entity.Email = updatedcontact.Email;
entity.Phone = updatedcontact.Phone;
entity.Landline = updatedcontact.Landline;
entity.Url = updatedcontact.Url;
entity.Address = updatedcontact.Address;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
}catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public string SaveEditContact(EditModalView viewModel)
{
string contactCheck = "";
using (AddressBookEntities ab = new AddressBookEntities())
{
ContactDetail cd = ab.ContactDetails.Where(x => x.Id == viewModel.ContactID).Distinct().FirstOrDefault();
if (cd != null)
{
cd = new ContactDetail
{
Id = viewModel.ContactID,
ContactName = viewModel.ContactName,
ContactSurname = viewModel.ContactSurname,
ContactEmail = viewModel.ContactEmail,
DateCreated = DateTime.Now
};
ab.ContactDetails.AddOrUpdate(cd);
ab.SaveChanges();
}
else
{
contactCheck = "There is no such !";
}
}
return(contactCheck);
}
public string AddContact(string _contactName, string _contactSurname, string _contactEmail)
{
string contacttCheck = "";
using (AddressBookEntities ab = new AddressBookEntities())
{
ContactDetail cd = ab.ContactDetails.Where(x => x.ContactName == _contactSurname || x.ContactEmail == _contactEmail).Distinct().FirstOrDefault();
if (cd != null)
{
contacttCheck = cd.ContactName.ToString() + "Already exists !";
}
else
{
cd = new ContactDetail
{
Id = Guid.NewGuid(),
ContactName = _contactName,
ContactSurname = _contactSurname,
ContactEmail = _contactEmail,
DateCreated = DateTime.Now
};
ab.ContactDetails.AddOrUpdate(cd);
ab.SaveChanges();
contacttCheck = cd.ContactName.ToString() + "Added Succesfully";
}
}
return(contacttCheck);
}
public IEnumerable <Contact> Get()
{
using (AddressBookEntities entities = new AddressBookEntities())
{
return(entities.Contacts.ToList());
}
}
public List <personObject.DropDownListObject> GetPeopleList()
{
try
{
var people = new List <personObject.DropDownListObject>();
using (var context = new AddressBookEntities())
{
var peopleList = context.Users.ToList();
foreach (var personObject in peopleList)
{
people.Add(new personObject.DropDownListObject()
{
Name = personObject.Name + " " + personObject.Surname,
Value = personObject.Id.ToString()
});
}
return(people);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public object Get()
{
using (var dbCtx = new AddressBookEntities())
{
var results = dbCtx.phonebooks.ToList();
var ret = results.Select(x =>
{
return(new ContactResult
{
Id = x.Id,
Name = x.Name,
Entries = x.entries.Select(y =>
new EntriesResult
{
Name = y.Name,
Id = y.Id,
PhonebookId = y.PhonebookId,
PhoneNumber = y.PhoneNumber
}).ToList()
});
});
return(ret.ToList());
}
}
public object Search([FromBody] GetContactsSearch query)
{
using (var dbCtx = new AddressBookEntities())
{
var pb = (from s in dbCtx.phonebooks
where s.Name.Contains(query.Seatch)
select s).ToList();
var ret = pb.Select(x =>
{
return(new ContactResult
{
Id = x.Id,
Name = x.Name,
Entries = x.entries.Select(y =>
new EntriesResult
{
Name = y.Name,
Id = y.Id,
PhonebookId = y.PhonebookId,
PhoneNumber = y.PhoneNumber
}).ToList()
});
});
return(ret.ToList());
}
}
public ActionResult SearchTable(string searchValue)
{
ContactDetails cd = new ContactDetails();
if (!string.IsNullOrEmpty(searchValue))
{
using (AddressBookEntities ab = new AddressBookEntities())
{
var contacts = _searchContact.SearchContactDetails(searchValue).Select(x => new ContactDetail
{
Id = x.Id,
ContactName = x.ContactName,
ContactSurname = x.ContactSurname,
ContactEmail = x.ContactEmail
}).ToList();
cd = new ContactDetails
{
ContactItems = contacts,
PageNo = 1,
ItemsPerPage = 10
};
}
}
else
{
cd = ReLoad(cd);
}
return(PartialView("_ContactsList", cd));
}
public ActionResult AddContacts(Contact c)
{
if (ModelState.IsValid)
{
using (AddressBookEntities dc = new AddressBookEntities())
{
dc.Contacts.Add(c);
try
{
dc.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
}
return(RedirectToAction("AddressBook"));
}
else
{
return(RedirectToAction("AddressBook"));
}
//return View(c);
}
//for getting the data form the table
public List <Country> Getcountry()
{
AddressBookEntities context1 = new AddressBookEntities();
var qry = context1.Countries.ToList();
return(qry);
}
public List <ContactDetail> SearchContactDetails(string searchValue)
{
using (AddressBookEntities ab = new AddressBookEntities())
{
var allContacts = ab.ContactDetails.Where(m => m.ContactName.ToUpper().Contains(searchValue.ToUpper()) || m.ContactEmail.ToUpper().Contains(searchValue.ToUpper())).OrderBy(x => x.ContactName).ToList();
return(allContacts);
}
}
public List <ContactDetail> PullContacts()
{
using (AddressBookEntities ab = new AddressBookEntities())
{
var allContacts = ab.ContactDetails.Where(m => m.ContactName != null || m.ContactEmail != null).OrderBy(x => x.ContactName).ToList();
return(allContacts);
}
}
public object Search([FromBody] GetEntries query)
{
using (var dbCtx = new AddressBookEntities())
{
var pb = (from s in dbCtx.entries
where s.PhonebookId == query.PhonebookId
select s).ToList();
return(JsonConvert.DeserializeObject <EntriesResult[]>(JsonConvert.SerializeObject(pb)));
}
}
public Response Create([FromBody] CreateEntry contact)
{
if (contact.PhonebookId == null || contact.PhonebookId == Guid.Empty)
{
return(new Response
{
Status = "Error",
Message = "Record Must Link to a Contact"
});
}
if (contact.Id != null || contact.Id == Guid.Empty)
{
var ct = new entry()
{
Name = contact.Name,
PhoneNumber = contact.PhoneNumber,
PhonebookId = contact.PhonebookId,
Id = Guid.NewGuid()
};
using (var dbCtx = new AddressBookEntities())
{
dbCtx.entries.Add(ct);
dbCtx.SaveChanges();
}
return(new Response
{
Status = "Success",
Message = "Record SuccessFully Added."
});
}
else
{
using (var dbCtx = new AddressBookEntities())
{
var pb = (from s in dbCtx.entries
where s.Id == contact.Id
select s).FirstOrDefault();
pb.Name = contact.Name;
pb.PhoneNumber = contact.PhoneNumber;
dbCtx.SaveChanges();
}
return(new Response
{
Status = "Success",
Message = "Record SuccessFully Updated."
});
}
}
public List <spGetUserContactList_Result> GetUserContactInformation()
{
try
{
using (var context = new AddressBookEntities())
{
return(context.spGetUserContactList().ToList());
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <spSeachContactList_Result> SearchContact(string searchKeyWord)
{
try
{
using (var context = new AddressBookEntities())
{
return(context.spSeachContactList(searchKeyWord).ToList());
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public HttpResponseMessage Get(int id)
{
using (AddressBookEntities entities = new AddressBookEntities())
{
var contact = entities.Contacts.FirstOrDefault(e => e.ID == id);
if (contact != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, contact));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id " + id + " not found"));
}
}
}
//for getting the data from the table
public object GetState()
{
AddressBookEntities context1 = new AddressBookEntities();
var qry = context1.States.ToList();
var qry1 = context1.Countries.ToList();
var qry2 = qry.Join(qry1, e1 => e1.FKCountryId, c1 => c1.PKCountryId, (e1, c1) => new
{
e1.PKStateId,
FKCountryId = c1.PKCountryId,
c1.CountryName,
e1.StateName,
e1.IsActive
}).ToList();
return(qry2);
}
public ActionResult DeleteContact(Contact c)
{
using (AddressBookEntities dc = new AddressBookEntities())
{
var v = dc.Contacts.Where(a => a.Id.Equals(c.Id)).FirstOrDefault();
if (v != null)
{
dc.Contacts.Remove(v);
dc.SaveChanges();
return(RedirectToAction("AddressBook"));
}
else
{
return(HttpNotFound("contact not found"));
}
}
}
public ActionResult EditContactView(Guid contactId)
{
using (AddressBookEntities ab = new AddressBookEntities())
{
//Obtaining specific contact values to prepopulate the fields
ContactDetail cd = ab.ContactDetails.FirstOrDefault(x => x.Id == contactId);
EditModalView emdv = new EditModalView();
emdv = new EditModalView
{
ContactID = contactId,
ContactName = cd.ContactName,
ContactSurname = cd.ContactSurname,
ContactEmail = cd.ContactEmail
};
return(PartialView("_UpdateContact", emdv));
}
}
public string DeleteContactDetails(Guid contactId)
{
string contactCheck = "";
using (AddressBookEntities ab = new AddressBookEntities())
{
ContactDetail cd = ab.ContactDetails.Where(x => x.Id == contactId).Distinct().FirstOrDefault();
if (cd != null)
{
ab.ContactDetails.Remove(cd);
ab.SaveChanges();
contactCheck = "Contact Deleted !";
}
else
{
contactCheck = "There is no such !";
}
}
return(contactCheck);
}
public object Create([FromBody] CreatePhonebook contact)
{
if (contact.Id != null || contact.Id == Guid.Empty)
{
var ct = new phonebook();
ct.Name = contact.Name;
ct.Id = Guid.NewGuid();
using (var dbCtx = new AddressBookEntities())
{
dbCtx.phonebooks.Add(ct);
dbCtx.SaveChanges();
}
return(new Response
{
Status = "Success",
Message = "Record SuccessFully Added."
});
}
else
{
using (var dbCtx = new AddressBookEntities())
{
var pb = (from s in dbCtx.phonebooks
where s.Id == contact.Id
select s).FirstOrDefault();
pb.Name = contact.Name;
dbCtx.SaveChanges();
}
return(new Response
{
Status = "Success",
Message = "Record SuccessFully Updated."
});
}
}
public ActionResult DeleteContact(int id)
{
List <Contact> contact = new List <Contact>();
using (AddressBookEntities dc = new AddressBookEntities())
{
var v = from a in dc.Contacts
where (a.Id == id)
select new
{
Id = a.Id,
FirstName = a.FirstName,
LastName = a.LastName,
PhoneNumber = a.PhoneNumber,
StreetName = a.StreetName,
City = a.City,
Province = a.Province,
PostalCode = a.PostalCode,
Country = a.Country
};
var data = v.ToList().Select(r => new Contact
{
Id = r.Id,
FirstName = r.FirstName,
LastName = r.LastName,
PhoneNumber = r.PhoneNumber,
StreetName = r.StreetName,
City = r.City,
Province = r.Province,
PostalCode = r.PostalCode,
Country = r.Country
}).ToList();
contact = data;
ViewBag.userdetails = contact;
return(View());
}
}
public int MaintainContactDetails(personObject.Contact contact)
{
if (string.IsNullOrWhiteSpace(contact.PhoneNumber))
{
return(0);
}
try
{
using (var context = new AddressBookEntities())
{
//Update Contact
if (contact.Id > 0)
{
var contactObj = context.AddressBooks.Where(c => c.Id == contact.Id).First();
contactObj.EmailAddress = contact.EmailAddress;
contactObj.PhoneNumber = contact.PhoneNumber;
contactObj.UserId = contact.UserId;
return(context.SaveChanges());
}
//Add New Contact
context.AddressBooks.Add(new AddressBook()
{
EmailAddress = contact.EmailAddress,
PhoneNumber = contact.PhoneNumber,
UserId = contact.UserId
});
return(context.SaveChanges());
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public HttpResponseMessage Post([FromBody] Contact contact)
{
try
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
using (AddressBookEntities entities = new AddressBookEntities())
{
entities.Contacts.Add(contact);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, contact);
message.Headers.Location = new Uri(Request.RequestUri + contact.ID.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Delete(int id)
{
try
{
using (AddressBookEntities entities = new AddressBookEntities())
{
var contact = entities.Contacts.FirstOrDefault(e => e.ID == id);
if (contact == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id " + id + " not found"));
}
else
{
entities.Contacts.Remove(contact);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public int DeleteContactDetails(personObject.Contact contact)
{
if (contact.Id == 0)
{
return(0);
}
try
{
using (var context = new AddressBookEntities())
{
var contactObj = context.AddressBooks.Where(c => c.Id == contact.Id).First();
context.AddressBooks.Remove(contactObj);
return(context.SaveChanges());
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public BusinessContactRepo(AddressBookEntities context)
{
_context = context;
}
/// <summary>
/// Base Controller
/// </summary>
public BaseController()
{
addressBookEntities = new AddressBookEntities();
}
