//for adding in the userdetail
public void AddUser(UserDetail userDetail)
{
using (TransactionScope trans = new TransactionScope())
{
context.UserDetails.Add(userDetail);
context.SaveChanges();
trans.Complete();
trans.Dispose();
}
}
//for adding the data in the table
public void AddAddress(Addressbook addressbook)
{
using (TransactionScope trans = new TransactionScope())
{
context.Addressbooks.Add(addressbook);
context.SaveChanges();
trans.Complete();
trans.Dispose();
}
}
//for adding the data in the table
public void AddState(State state)
{
using (TransactionScope trans = new TransactionScope())
{
context.States.Add(state);
context.SaveChanges();
trans.Complete();
trans.Dispose();
}
}
//for adding the data in the table
public void AddCountry(Country country)
{
using (TransactionScope trans = new TransactionScope())
{
context.Countries.Add(country);
context.SaveChanges();
trans.Complete();
trans.Dispose();
}
}
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 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);
}
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 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 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."
});
}
}
//Add a business contact
public void addData(DateTime date, string company, string website, string title, string fName, string lName, string address,
string city, string province, string postalCode, string email, string phone, string notes)
{
BusinessContact businessContact = new BusinessContact();
businessContact.Date_Added = date;
businessContact.Company = company;
businessContact.Website = website;
businessContact.Title = title;
businessContact.First_Name = fName;
businessContact.Last_Name = lName;
businessContact.Address = address;
businessContact.City = city;
businessContact.Province = province;
businessContact.Postal_Code = postalCode;
businessContact.Email = email;
businessContact.Phone = phone;
businessContact.Notes = notes;
_context.BusinessContacts.Add(businessContact); //Add businessContact object
_context.SaveChanges(); //Save the changes
}
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 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 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 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 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 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 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));
}
}