public ActionResult Edit(int id) { var siteCoID = siteusercompanyid; ViewBag.ContactCo = new SelectList(db.GetContactCompaniesBySiteCoID(siteCoID), "ViewID", "Company", siteCoID); ViewBag.Country = new SelectList(new CommonRepository().GetCountries(), "CountryID", "Country"); ViewBag.ContactType = new SelectList(db.GetPeopleTypesBySiteCoID(siteCoID), "ViewID", "Name", siteCoID); ViewBag.ContactSubType = new SelectList(db.GetContactSubTypesBySiteCoID(siteCoID), "ViewID", "Type", siteCoID); ViewBag.ContactStatus = new SelectList(db.SiteContactStatus.OrderBy(p => p.StatusOrder), "StatusID", "Status"); ViewBag.Owner = new SelectList(db.GetCoUsersBySiteCoID(siteCoID), "UserID", "User", siteCoID); ViewBag.ContactCustoms = db.GetContactCustomFieldsBySiteCoID(siteCoID).FirstOrDefault(); ViewBag.siteuserid = siteuserid; GetContactInfoByContactID_Result Model = new GetContactInfoByContactID_Result(); CoContacts contact = db.CoContacts .Include(p => p.CoContactAddresses) .Include(p => p.CoContactEmails) .Where(p => p.ContactID == id).FirstOrDefault(); CoContactAddresses address = contact.CoContactAddresses.Where(p => p.ContactID == id).FirstOrDefault() ?? new CoContactAddresses(); if (contact != null) { Model = new GetContactInfoByContactID_Result() { ContactAddress1 = address.Address1, ContactAddress2 = address.Address2, ContactCity = address.City, CountryID = address.CountryID, ContactState = address.State, ContactZip = address.Zip, ContactCompany = contact.CoContactCompanies != null ? contact.CoContactCompanies.ContactCoName : "", ViewID = contact.ContactID, ContactEmail = contact.CoContactEmails.Any() ? contact.CoContactEmails.Select(p => p.EmailAddress).FirstOrDefault() : "", ContactFirst = contact.ContactFirstName, ContactLast = contact.ContactLastName, Mobile = contact.CoContactPhones.Any() ? contact.CoContactPhones.Where(p => p.PhoneTypeID == 2).Select(p => p.Phone).FirstOrDefault() : "", Phone = contact.CoContactPhones.Any() ? contact.CoContactPhones.Where(p => p.PhoneTypeID == 1).Select(p => p.Phone).FirstOrDefault() : "", ContactStatusID = contact.ContactStatusID, ContactTypeID = contact.ContactTypeID, ContactOwnerID = contact.ContactManager, ContactSubtypeID = contact.ContactSubtypeID, FaceBook = contact.FaceBook, LinkedIn = contact.LinkedIn, Skype = contact.Skype, Custom1 = contact.Custom1, Custom2 = contact.Custom2, Custom3 = contact.Custom3, Custom4 = contact.Custom4 }; } return(View("_Edit", Model)); }
public ActionResult Edit(int id) { ViewBag.ContactCo = new SelectList(db.CoContactCompanies.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.ContactCoName), "ContactCoID", "ContactCoName"); ViewBag.Country = new SelectList(db.SiteCountries.OrderBy(p => p.Country), "CountryID", "Country"); ViewBag.ContactType = new SelectList(db.CoContactTypes.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.ContactTypeOrder), "ContactTypeID", "ContactTypeName"); ViewBag.ContactStatus = new SelectList(db.SiteContactStatus.OrderBy(p => p.StatusOrder), "StatusID", "Status"); ViewBag.Owner = new SelectList(db.SiteUsers.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.UserDisplayName), "SiteUserID", "UserDisplayName", siteuserid); ViewBag.siteuserid = siteuserid; PeopleModels.NewContact Model = new PeopleModels.NewContact(); CoContacts contact = db.CoContacts .Include(p => p.CoContactAddresses) .Include(p => p.CoContactEmails) .Where(p => p.ContactID == id).FirstOrDefault(); CoContactAddresses address = contact.CoContactAddresses.Where(p => p.ContactID == id).FirstOrDefault() ?? new CoContactAddresses(); if (contact != null) { Model = new PeopleModels.NewContact() { Address1 = address.Address1, Address2 = address.Address2, City = address.City, CountryID = address.CountryID, State = address.State, Zip = address.Zip, Company = contact.CoContactCompanies != null ? contact.CoContactCompanies.ContactCoName : "", ContactID = contact.ContactID, Email = contact.CoContactEmails.Any() ? contact.CoContactEmails.Select(p => p.EmailAddress).FirstOrDefault() : "", First = contact.ContactFirstName, Last = contact.ContactLastName, Mobile = contact.CoContactPhones.Any() ? contact.CoContactPhones.Where(p => p.PhoneTypeID == 1).Select(p => p.Phone).FirstOrDefault() : "", Phone = contact.CoContactPhones.Any() ? contact.CoContactPhones.Where(p => p.PhoneTypeID == 2).Select(p => p.Phone).FirstOrDefault() : "", StatusID = contact.ContactStatusID, TypeID = contact.ContactTypeID, OwnerID = contact.ContactManager }; } return(View("_Edit", Model)); }