public List <Contact> GetAll()
{
using (ContactEntities db = new ContactEntities())
{
return(db.Contacts.ToList());
}
}
//
// GET: /Contact/
public ActionResult Index()
{
using (var db = new ContactEntities())
{
return(View(db.Contacts.ToList()));
}
}
public ActionResult Delete(int id)
{
using (var db = new ContactEntities())
{
return(View(db.Contacts.Find(id)));
}
}
//get
public IEnumerable <Contact> Get()
{
using (ContactEntities entity = new ContactEntities())
{
return(entity.Contacts.ToList());
}
}
//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 Contact GetById(int id)
{
using (ContactEntities db = new ContactEntities())
{
return(db.Contacts.Find(id));
}
}
public void Delete(Contact obj)
{
using (ContactEntities db = new ContactEntities())
{
db.Contacts.Attach(obj);
db.Contacts.Remove(obj);
db.SaveChanges();
}
}
public Contact Insert(Contact obj)
{
using (ContactEntities db = new ContactEntities())
{
db.Contacts.Add(obj);
db.SaveChanges();
return(obj);
}
}
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 ActionResult GetContacts()
{
using (var db = new ContactEntities())
{
return(View(db.Contacts
.OrderBy(contact => contact.DisplayOrder)
.ToList()));
}
}
protected void Dispose(bool disposing)
{
if (disposing)
{
if (dbContext != null)
{
dbContext.Dispose();
dbContext = null;
}
}
}
public bool CheckIfUserNameAlreadyExisits(UserData userData)
{
bool uniqueUserName = false;
using (ContactEntities db = new ContactEntities())
{
IQueryable <User> query = db.Users.Where(user => user.userName == userData.userName);
uniqueUserName = query.ToList().Count != 0;
}
return(uniqueUserName);
}
protected virtual void Dispose(bool disposing)
{
if (disposing)
{
// free managed resources
if (_dbContext != null)
{
_dbContext.Dispose();
_dbContext = null;
}
}
}
public Guid RetrieveUserId(UserData userData)
{
Guid userId = Guid.Empty;
using (ContactEntities db = new ContactEntities())
{
IQueryable <Guid> query = db.Users
.Where(user => user.userName == userData.userName)
.Select(user => user.id);
userId = query.First();
}
return(userId);
}
public bool ValidateUserInformation(UserData userData)
{
bool validUser = false;
using (ContactEntities db = new ContactEntities())
{
IQueryable <User> query = db.Users.Where(user => user.userName == userData.userName);
if (query.ToList().Count != 0)
{
validUser = Security.SecurePasswordHasher.Verify(userData.password, query.First().passwordHash);
}
}
return(validUser);
}
public frmAddEditContact(Contacts obj)
{
InitializeComponent();
db = new ContactEntities();
if (obj == null)
{
contactsBindingSource.DataSource = new Contacts();
db.Contacts.Add(contactsBindingSource.Current as Contacts);
}
else
{
contactsBindingSource.DataSource = obj;
db.Contacts.Attach(contactsBindingSource.Current as Contacts);
}
}
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();
}
}
//get by id
public HttpResponseMessage Get(int id)
{
using (ContactEntities entity = new ContactEntities())
{
var query = entity.Contacts.FirstOrDefault(e => e.Id == id);
if (query != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, query));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with Id = " + id.ToString() + "was not found"));
}
}
}
public HttpResponseMessage FindByEmail(string email = "email") // equal to set a default value, not necessary
{
using (ContactEntities entity = new ContactEntities())
{
var query = entity.Contacts.FirstOrDefault(e => e.EmailAddress.ToLower() == email.ToLower());
if (query != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, query));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with email address = " + email + "was not found"));
}
}
}
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());
}
}
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());
}
}
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();
}
}
//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));
}
}
List <Models.Contact> IContactService.RetrieveAllUserContacts(Guid userid)
{
List <Models.Contact> userContacts = new List <Models.Contact>();
using (ContactEntities db = new ContactEntities())
{
IQueryable <User> query = db.Users.Where(user => user.id == userid);
User userData = query.First();
foreach (ContactDAL.Contact contactData in userData.Contacts)
{
Models.Contact contact = new Models.Contact()
{
Id = contactData.id,
FirstName = contactData.contactFirstName,
LastName = contactData.contactLastName,
JobTitle = contactData.contactJobTitle,
Organization = contactData.contactOrganization,
CellPhone = contactData.PhoneNumbers.First().cellNumber,
HomePhone = contactData.PhoneNumbers.First().homeNumber,
OfficePhone = contactData.PhoneNumbers.First().officeNumber,
PrimaryEmail = contactData.Emails.First().primaryEmail,
SecondaryEmail = contactData.Emails.First().secondaryEmail,
Image = contactData.Images.First().contactImage,
Address = new Models.Address
{
Line1 = contactData.Addresses.First().addressLine1,
Line2 = contactData.Addresses.First().addressLine2,
City = contactData.Addresses.First().addressCity,
Country = contactData.Addresses.First().addressCountry,
State = contactData.Addresses.First().addressStateCounty,
Zip = contactData.Addresses.First().addressZip
}
};
userContacts.Add(contact);
}
}
return(userContacts);
}
//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 JsonResult CreateContact(ContactEntities ce)
{
string res = "";
try
{
int Add_By = Convert.ToInt32(Session["Emp_id"].ToString());
DateTime Add_Date = DateTime.Today;
int Deleted = 0;
res = dblayer.CreateContact(ce.First_Name, ce.Middle_Name, ce.Last_Name, ce.Email, ce.Designation, ce.Customer_Id, Add_By, Add_Date, ce.Status, Deleted);
if (res == "Success")
{
mm.SuccessMsg = ce.First_Name.ToUpper() + " " + ce.Last_Name.ToUpper() + " is successfully created.";
}
else
{
mm.ErrorMsg = res;
}
}
catch (Exception ex)
{
}
return(Json(mm, JsonRequestBehavior.AllowGet));
}
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);
}
/// <summary>
/// Initialize entity context
/// </summary>
/// <param name="context"></param>
public Repository(ContactEntities context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
private void Form1_Load(object sender, EventArgs e)
{
db = new ContactEntities();
contactsBindingSource.DataSource = db.Contacts.ToList();
}
public ContactEntities Init()
{
return(dbContext ?? (dbContext = new ContactEntities()));
}
