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(); }