public void Add(Contact contact)
{
dbContext.ContactDetails.Add(new ContactDetail {
firstname = contact.FirstName, lastname = contact.LastName, email = contact.Email, phone = contact.Phone, isactive = contact.IsActive
});
dbContext.SaveChanges();
}
public ActionResult Create([Bind(Include = "Name,ContactNo,ID")] Contact contact)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
public ActionResult Create([Bind(Include = "idContact,name,lastname,idCard,creationDate")] Contact contact)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
public ActionResult Create([Bind(Include = "ID,ContactName,ContactNumber,GroupName,HireDate,Birthday")] Contact contact)
{
if (ModelState.IsValid)
{
db.Contacts.Add(contact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
public ActionResult Create(Contact contact)
{
CheckCookies();
if (ModelState.IsValid)
{
contact.ContactId = Guid.NewGuid();
contact.UserId = userId;
db.Contacts.Add(contact);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
//Update email
public HttpResponseMessage Put(int id, [FromBody] Contact contact)
{
using (ContactEntities entity = new ContactEntities())
{
try
{
var query = entity.Contacts.FirstOrDefault(e => e.Id == id);
if (query != null)
{
//query.Name = contact.Name;
query.EmailAddress = contact.EmailAddress;
entity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with Id = " + id.ToString() + "was not found"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
public ActionResult Edit(int id, FormCollection collection)
{
Contact prd = _db.Contacts.FirstOrDefault(d => d.Id == id);
UpdateModel(prd);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Update(Contact obj)
{
using (ContactEntities db = new ContactEntities())
{
db.Contacts.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public Contact Insert(Contact obj)
{
using (ContactEntities db = new ContactEntities())
{
db.Contacts.Add(obj);
db.SaveChanges();
return(obj);
}
}
public void Delete(Contact obj)
{
using (ContactEntities db = new ContactEntities())
{
db.Contacts.Attach(obj);
db.Contacts.Remove(obj);
db.SaveChanges();
}
}
public IHttpActionResult PutContactDetail(int id, ContactDetail contactDetail)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
ContactDetail contactDetails = new ContactDetail();
contactDetails.Id = contactDetail.Id;
contactDetails.First_Name = contactDetail.First_Name.Replace(" ", "");
contactDetails.Last_Name = contactDetail.Last_Name.Replace(" ", "");
contactDetails.Email = contactDetail.Email.Replace(" ", "");
contactDetails.Phone_Number = contactDetail.Phone_Number.Replace(" ", "");
contactDetails.Status = contactDetail.Status;
if (id != contactDetails.Id)
{
return(BadRequest());
}
db.Entry(contactDetails).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ContactDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (contactsBindingSource.Current != null)
{
if(MessageBox.Show("Kaydı silmek istediğinize emin misiniz?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
db.Contacts.Remove(contactsBindingSource.Current as Contacts);
contactsBindingSource.RemoveCurrent();
db.SaveChanges();
}
}
}
public void CreateNewUser(UserData userData)
{
using (ContactEntities db = new ContactEntities())
{
User newUser = new User()
{
emailAddress = userData.email,
phoneNumber = userData.phoneNumber,
userName = userData.userName,
passwordHash = Security.SecurePasswordHasher.Hash(userData.password)
};
db.Users.Add(newUser);
db.SaveChanges();
}
}
public ActionResult Delete(int id, Contact contact)
{
try
{
using (var db = new ContactEntities())
{
db.Entry(db.Contacts.Find(id)).State = EntityState.Deleted;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, Contact contact)
{
try
{
using (var db = new ContactEntities())
{
contact.Text = HttpUtility.UrlDecode(contact.Text, System.Text.Encoding.Default);
db.Entry(contact).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch
{
return(View());
}
}
private void frmAddEditContact_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult == DialogResult.OK)
{
if (string.IsNullOrEmpty(txtAd.Text))
{
MessageBox.Show("Lütfen isminizi girin", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtAd.Focus();
e.Cancel = true;
return;
}
db.SaveChanges();
e.Cancel = false;
}
e.Cancel = false;
}
public ActionResult Create(Contact contact)
{
try
{
using (var db = new ContactEntities())
{
contact.Text = HttpUtility.UrlDecode(contact.Text, System.Text.Encoding.Default);
db.Contacts.Add(contact);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
//create new
public HttpResponseMessage Post([FromBody] Contact contact)
{
try
{
using (ContactEntities entity = new ContactEntities())
{
entity.Contacts.Add(contact);
entity.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, contact); //Response message status code and contact created
message.Headers.Location = new Uri(Request.RequestUri + contact.Id.ToString()); //header respond with uri and contact id
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void DeleteUserContact(Models.Contact contact, Guid userId)
{
using (ContactEntities db = new ContactEntities())
{
IQueryable <User> userQuery = db.Users.Where(users => users.id == userId);
User userData = userQuery.First();
IQueryable <ContactDAL.Contact> contactQuery = db.Contacts.Where(contactLocation => contactLocation.userId == userData.id && contactLocation.id == contact.Id);
ContactDAL.Contact contactData = contactQuery.First();
db.Addresses.RemoveRange(contactData.Addresses);
db.Emails.RemoveRange(contactData.Emails);
db.Images.RemoveRange(contactData.Images);
db.PhoneNumbers.RemoveRange(contactData.PhoneNumbers);
db.Contacts.Remove(contactData);
db.SaveChanges();
}
}
//delete by id
public HttpResponseMessage Delete(int id)
{
using (ContactEntities entity = new ContactEntities())
{
try
{
var query = entity.Contacts.FirstOrDefault(e => e.Id == id);
if (query != null)
{
entity.Contacts.Remove(query);
entity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with Id = " + id.ToString() + "was not found"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
public void Save()
{
context.SaveChanges();
}
public ActionResult AddContact(Contact model)
{
db.Contacts.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public virtual void Update(T entity)
{
dbSet.Attach(entity);
dataContext.Entry(entity).State = EntityState.Modified;
dataContext.SaveChanges();
}
public Models.Contact UpsertUserContact(Models.Contact contact, Guid userId)
{
using (ContactEntities db = new ContactEntities())
{
IQueryable <User> userQuery = db.Users.Where(user => user.id == userId);
User userData = userQuery.First();
if (contact.Id == Guid.Empty)
{
ContactDAL.Contact newContact = new ContactDAL.Contact()
{
User = userData,
userId = userData.id,
contactFirstName = contact.FirstName,
contactLastName = contact.LastName,
contactJobTitle = contact.JobTitle,
contactOrganization = contact.Organization
};
Email newEmail = new Email()
{
Contact = newContact,
primaryEmail = contact.PrimaryEmail,
secondaryEmail = contact.SecondaryEmail
};
Image newImage = new Image()
{
Contact = newContact,
contactImage = contact.Image
};
PhoneNumber newPhoneNumber = new PhoneNumber()
{
Contact = newContact,
cellNumber = contact.CellPhone,
homeNumber = contact.HomePhone,
officeNumber = contact.OfficePhone
};
ContactDAL.Address newAddress = new ContactDAL.Address()
{
Contact = newContact,
addressLine1 = contact.Address.Line1,
addressLine2 = contact.Address.Line2,
addressCity = contact.Address.City,
addressCountry = contact.Address.Country,
addressStateCounty = contact.Address.State,
addressZip = contact.Address.Zip
};
newContact.Emails.Add(newEmail);
newContact.Images.Add(newImage);
newContact.PhoneNumbers.Add(newPhoneNumber);
newContact.Addresses.Add(newAddress);
db.Contacts.Add(newContact);
db.Emails.Add(newEmail);
db.Images.Add(newImage);
db.PhoneNumbers.Add(newPhoneNumber);
db.Addresses.Add(newAddress);
db.SaveChanges();
contact.Id = Guid.Parse(newContact.id.ToString());
}
else
{
IQueryable <ContactDAL.Contact> contactQuery = db.Contacts.Where(contactLocatingData => contactLocatingData.userId == userData.id && contactLocatingData.id == contact.Id);
ContactDAL.Contact contactData = contactQuery.First();
contactData.contactFirstName = contact.FirstName;
contactData.contactLastName = contact.LastName;
contactData.contactJobTitle = contact.JobTitle;
contactData.contactOrganization = contact.Organization;
contactData.Emails.First().primaryEmail = contact.PrimaryEmail;
contactData.Emails.First().secondaryEmail = contact.SecondaryEmail;
contactData.Images.First().contactImage = contact.Image;
contactData.PhoneNumbers.First().cellNumber = contact.CellPhone;
contactData.PhoneNumbers.First().homeNumber = contact.HomePhone;
contactData.PhoneNumbers.First().officeNumber = contact.OfficePhone;
contactData.Addresses.First().addressLine1 = contact.Address.Line1;
contactData.Addresses.First().addressLine2 = contact.Address.Line2;
contactData.Addresses.First().addressCity = contact.Address.City;
contactData.Addresses.First().addressCountry = contact.Address.Country;
contactData.Addresses.First().addressStateCounty = contact.Address.State;
contactData.Addresses.First().addressZip = contact.Address.Zip;
db.SaveChanges();
}
}
return(contact);
}
