public async Task <PersonPhone> Update(PersonPhone personPhone)
{
_context.PersonPhone.Update(personPhone);
await _context.SaveChangesAsync();
return(personPhone);
}
public async Task <PersonPhone> FindAsync(string key) => await Task.Run(() =>
{
PersonPhone personPhone = JsonConvert.DeserializeObject <PersonPhone>(key);
return(_context.PersonPhone.Include(p => p.Person).Include(p => p.PhoneNumberType).Where(o => o.BusinessEntityID == personPhone.BusinessEntityID &&
o.PhoneNumber == personPhone.PhoneNumber &&
o.PhoneNumberTypeID == personPhone.PhoneNumberTypeID).FirstOrDefault());
});
public async Task <Customer> GetByIdAsync(int id)
{
// get phone by phone number
PersonPhone phoneNumber = await phoneNumberRetrieval.GetByIdAsync(id);
// get person by id
Person person = await personRetrieval.GetByIdAsync(phoneNumber.BusinessEntityId);
// get employee by id
Employee employee = await employeeRetrieval.GetByIdAsync(phoneNumber.BusinessEntityId);
// get email address by id
EmailAddress emailAddress = await emailAddressRetrieval.GetByIdAsync(phoneNumber.BusinessEntityId);
// get address by id
Address address = await addressRetrieval.GetByIdAsync(phoneNumber.BusinessEntityId);
// form new customer object
Customer customer = new Customer()
{
BusinessEntityId = employee.BusinessEntityId,
FirstName = person.FirstName,
MiddleName = person.MiddleName,
LastName = person.LastName,
EmailAddressString = emailAddress.EmailAddress1,
PhoneNumber = phoneNumber.PhoneNumber,
Address = address.AddressLine1 + address.AddressLine2,
City = address.City,
PostalCode = address.PostalCode
};
return(customer);
}
public async Task <IActionResult> Edit(long id, [Bind("PersonPhoneId,PersonId,PhoneNumber")] PersonPhone personPhone)
{
if (id != personPhone.PersonPhoneId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(personPhone);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PersonPhoneExists(personPhone.PersonPhoneId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Details", "Clients", new { id = personPhone.PersonId }, null));
}
ViewData["PersonId"] = new SelectList(_context.Persons, "PersonId", "FirstName", personPhone.PersonId);
return(View(personPhone));
}
public int CreatePersonPhone(PersonPhone phone)
{
using (var db = new LogistoDb())
{
return(Convert.ToInt32(db.InsertWithIdentity(phone)));
}
}
public static PersonPhone Translate(DataRow row)
{
var phone = new PersonPhone();
try
{
var communicationType = row.Field <string>("communication_type");
if (communicationType != "Mobile" && !communicationType.Contains("Phone") && !communicationType.Contains("phone"))
{
return(null);
}
var householdId = row.Field <int>("household_id");
var companyAsPersonId = F1Company.GetCompanyAsPersonId(householdId);
var phoneType = communicationType.Replace("Phone", string.Empty).Replace("phone", string.Empty).Trim();
var phoneNumber = new string( row.Field <string>("communication_value").Where(c => char.IsDigit(c)).ToArray());
if (!string.IsNullOrWhiteSpace(phoneNumber))
{
phone.PersonId = companyAsPersonId;
phone.PhoneType = phoneType;
phone.PhoneNumber = phoneNumber;
return(phone);
}
}
catch
{
return(null);
}
return(null);
}
public IHttpActionResult PutPersonPhone(int id, PersonPhone personPhone)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != personPhone.Id)
{
return(BadRequest());
}
db.Entry(personPhone).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PersonPhoneExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Read(int page = 1)
{
int pageSize = 20;
List <Employee> employees_ = null;
List <Person> people = null;
List <EmailAddress> email = null;
List <PersonPhone> phones = null;
List <PersonEmployee> employees = new List <PersonEmployee>();
using (BussinessTransaction bt = new BussinessTransaction(_unitOfWork))
{
bt.Execute(() =>
{
employees_ = _dbEmp.Read().ToList();
people = _dbPer.Read().ToList();
phones = _dbPhn.Read().ToList();
email = _dbEml.Read().ToList();
});
}
for (int i = 0; i < employees_.Count(); i++)
{
PersonEmployee y = new PersonEmployee();
y.BusinessEntityID = employees_[i].BusinessEntityId;
y.BirthDate = employees_[i].BirthDate.ToShortDateString();
y.NationalIDNumber = employees_[i].NationalIdnumber;
y.JobTitle = employees_[i].JobTitle;
Person a = new Person();
a = people.Find(x => x.BusinessEntityId.Equals(y.BusinessEntityID));
y.LastName = a.LastName;
y.FirstName = a.FirstName;
EmailAddress b = new EmailAddress();
b = email.Find(x => x.BusinessEntityId.Equals(y.BusinessEntityID));
y.EmailAddress = b.EmailAddress1;
PersonPhone c = new PersonPhone();
c = new PersonPhone();
c = phones.Find(x => x.BusinessEntityId.Equals(y.BusinessEntityID));
y.PhoneNumber = c.PhoneNumber;
employees.Add(y);
}
//return View(employees);
//IEnumerable<PersonEmployee> perEmpsPerPages = employees.Skip((page - 1) * pageSize).Take(pageSize);
//PageInfo pageInfo = new PageInfo { PageNumber = page, PageSize = pageSize, TotalItems = employees.Count };
//IndexViewModel ivm = new IndexViewModel { PageInfo = pageInfo, perEmps = perEmpsPerPages };
//return View(ivm);
var count = employees.Count();
var items = employees.Skip((page - 1) * pageSize).Take(pageSize).ToList();
PersonEmployeeViewModel empViewModel = new PersonEmployeeViewModel(count, page, pageSize);
IndexPersonEmployeeViewModel viewModel = new IndexPersonEmployeeViewModel
{
PersonEmployeeViewModel = empViewModel,
PersonEmployees = items
};
return(View(viewModel));
}
public async Task <PersonPhoneResponse> AddPersonPhone(PersonPhoneDto personPhone)
{
var person = await _personService.Find(personPhone.PersonId);
var newPersonPhone = new PersonPhone
{
PhoneNumber = personPhone.PhoneNumber,
PhoneNumberType = await _phoneNumberTypeService.Find(x => x.Name == personPhone.PhoneNumberType),
Person = person
};
await _personPhoneService.Add(newPersonPhone);
var response = new PersonPhoneResponse
{
PersonPhoneObject = new PersonPhoneDto
{
BusinessEntityID = newPersonPhone.BusinessEntityID,
PersonId = newPersonPhone.Person.BusinessEntityID,
PhoneNumber = newPersonPhone.PhoneNumber,
PhoneNumberType = newPersonPhone.PhoneNumberType.Name
}
};
return(response);
}
// POST: odata/PersonPhones
public IHttpActionResult Post(PersonPhone personPhone)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_db.PersonPhones.Add(personPhone);
try
{
_db.SaveChanges();
}
catch (DbUpdateException)
{
if (PersonPhoneExists(personPhone.BusinessEntityID))
{
return(Conflict());
}
else
{
throw;
}
}
return(Created(personPhone));
}
public override Person PopulateRecord(SqlDataReader reader)
{
EmailAddress emailAddress = new EmailAddress
{
EmailAddress1 = (string)reader["EmailAddress"]
};
PersonPhone phone = new PersonPhone
{
PhoneNumber = (string)reader["PhoneNumber"],
};
return(new Person
{
BusinessEntityID = Convert.ToInt32((int)reader["BusinessEntityID"]),
FirstName = reader["FirstName"].ToString(),
MiddleName = reader["MiddleName"].ToString(),
LastName = reader["LastName"].ToString(),
Suffix = reader["Suffix"].ToString(),
PersonType = reader["PersonType"].ToString(),
NameStyle = (bool)reader["NameStyle"],
Title = reader["Title"].ToString(),
EmailPromotion = Convert.ToInt32((int)reader["EmailPromotion"]),
ModifiedDate = (DateTime)reader["ModifiedDate"],
rowguid = (Guid)reader["rowguid"],
EmailAddress = emailAddress,
PersonPhone = phone
});
}
public static PersonPhone Translate(DataRow row)
{
var phone = new PersonPhone();
phone.PersonId = row.Field <int>("IndividualId");
phone.PhoneNumber = row.Field <string>("Phone");
phone.IsUnlisted = row.Field <bool?>("Unlisted").Value;
var phoneType = row.Field <string>("Description");
switch (phoneType)
{
case "Cell":
phone.PhoneType = "Mobile";
break;
case "Home":
phone.PhoneType = "Home";
break;
case "Business":
phone.PhoneType = "Work";
break;
default:
phone.PhoneType = phoneType;
break;
}
return(phone);
}
public async Task ProccesOrderAuthenticatedAsync(IEnumerable <CartLineDTO> cart, ShippingDetailsDTO shippingDetails, string userId)
{
var person = unitOfWork.Person.GetList(i => i.UserID == userId).FirstOrDefault();
var busEntity = unitOfWork.BusinessEntity.Get(person.BusinessEntityID);
var personPhone = new PersonPhone()
{
PhoneNumber = shippingDetails.MobilePhone,
PhoneNumberTypeID = 1,
ModifiedDate = DateTime.Now
};
var emailAddress = new EmailAddress()
{
EmailAddress1 = shippingDetails.Email,
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now
};
person.EmailAddresses.Add(emailAddress);
person.PersonPhones.Add(personPhone);
var orderHeader = ProcessOrderHeader(cart, shippingDetails);
busEntity.PurchaseOrderHeaders.Add(orderHeader);
unitOfWork.Save();
await emailService.SendEmailAsync(orderHeader.PurchaseOrderID);
}
public async Task <PersonPhone> PutAsync(PersonPhone personPhone)
{
personPhone = await Task.Run(() => _context.PersonPhone.Update(personPhone).Entity);
await _context.SaveChangesAsync();
return(personPhone);
}
public void GetPhoneNumberByIDsTest()
{
var context = new Entities();
var personPhone = new PersonPhone(context);
var phoneRecord = personPhone.GetPhoneNumberByIDs(10);
Assert.AreEqual("330-555-2568", phoneRecord.PhoneNumber);
}
public async Task <IActionResult> CreateVendorContactPhone([FromBody] PersonPhone phone)
{
await _repository.Telephone.CreatePhone(phone);
return(CreatedAtRoute(nameof(GetVendorContactPhone),
new { entityID = phone.BusinessEntityID, phoneNumber = phone.PhoneNumber, phoneTypeID = phone.PhoneNumberTypeID }
, phone));
}
public ActionResult Delete(string id)
{
string[] ids = id.Split('X');
PersonPhone objPersonPhone = new PersonPhone();
objPersonPhone = _personPhone.GetPersonPhoneById(Convert.ToInt32(ids[2]), ids[1], Convert.ToInt32(ids[0]));
_personPhone.Delete(objPersonPhone);
return(RedirectToAction("Index", new { id = Convert.ToInt32(ids[0]) }));
}
public async Task <PersonPhone> PutAsync(string previosKeys, PersonPhone personPhone) => await Task.Run(() =>
{
PersonPhone previos = JsonConvert.DeserializeObject <PersonPhone>(previosKeys);
var keyValues = new object[] { previos.BusinessEntityID, previos.PhoneNumber, previos.PhoneNumberTypeID };
var entity = _context.PersonPhone.Find(keyValues);
_context.Entry <PersonPhone>(entity).State = EntityState.Deleted;
_context.PersonPhone.Add(personPhone);
_context.SaveChanges();
return(personPhone);
});
public async Task DeleteAsync(PersonPhone personPhone) => await Task.Run(() =>
{
var keyValues = new object[] { personPhone.BusinessEntityID, personPhone.PhoneNumber, personPhone.PhoneNumberTypeID };
var entity = _context.PersonPhone.Find(keyValues);
if (entity == null)
{
throw new Exception($"key not found: {personPhone.BusinessEntityID}-{personPhone.PhoneNumber}-{personPhone.PhoneNumberType}");
}
_context.PersonPhone.Remove(entity);
_context.SaveChanges();
});
public async Task <bool> RemovePersonPhone(PersonPhone personPhone)
{
var entity = _context.PersonPhone.Where(x => x.BusinessEntityID == personPhone.BusinessEntityID &&
x.PhoneNumber == personPhone.PhoneNumber &&
x.PhoneNumberTypeID == personPhone.PhoneNumberTypeID).FirstOrDefault();
_context.PersonPhone.Attach(entity);
_context.PersonPhone.Remove(entity);
return(await _context.SaveChangesAsync() > 0);
}
public IHttpActionResult GetPersonPhone(int id)
{
PersonPhone personPhone = db.Phones.Find(id);
if (personPhone == null)
{
return(NotFound());
}
return(Ok(personPhone));
}
public void Add()
{
PersonPhone personPhone = new PersonPhone()
{
CountryId = 1,
Number = "0557894561"
};
var result = _unitOfWork.Repository <PersonPhone>().Add(personPhone);
Assert.IsTrue(result.IsSuccess);
}
public async Task <IActionResult> Create([Bind("PersonPhoneId,PersonId,PhoneNumber")] PersonPhone personPhone)
{
if (ModelState.IsValid)
{
_context.Add(personPhone);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", "Clients", new { id = personPhone.PersonId }, null));
}
ViewData["PersonId"] = new SelectList(_context.Persons, "PersonId", "FirstName", personPhone.PersonId);
return(View(personPhone));
}
public bool Insert(PersonPhone personphone)
{
int autonumber = 0;
PersonPhoneDAC personphoneComponent = new PersonPhoneDAC();
bool endedSuccessfuly = personphoneComponent.InsertNewPersonPhone(ref autonumber, personphone.BusinessEntityId, personphone.PhoneNumber, personphone.PhoneNumberTypeId, DateTime.Now, personphone.PhoneVerified, personphone.PhoneVerificationCode);
if (endedSuccessfuly)
{
personphone.Id = autonumber;
}
return(endedSuccessfuly);
}
// PUT api/awbuildversion/5
public void Put(PersonPhone value)
{
var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault();
if (GetActionType.Key != null)
{
if (GetActionType.Value.ToList()[0].Equals("DELETE"))
adventureWorks_BC.PersonPhoneDelete(value);
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
adventureWorks_BC.PersonPhoneUpdate(value);
}
}
public ActionResult Edit([Bind(Include = "BusinessEntityID,PhoneNumber,PhoneNumberTypeID,ModifiedDate,isDeleted")] PersonPhone personPhone)
{
if (ModelState.IsValid)
{
db.Entry(personPhone).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BusinessEntityID = new SelectList(db.People, "BusinessEntityID", "PersonType", personPhone.BusinessEntityID);
ViewBag.PhoneNumberTypeID = new SelectList(db.PhoneNumberTypes, "PhoneNumberTypeID", "Name", personPhone.PhoneNumberTypeID);
return(View(personPhone));
}
private void SetInfo()
{
ddlState.SelectedIndex = -1;
// Load Person Values
tbFirstName.Text = person.FirstName;
tbLastName.Text = person.LastName;
PersonPhone phone = person.Phones.FindByType(SystemLookup.PhoneType_Home);
if (phone != null)
{
tbHomePhone.Text = phone.Number;
}
phone = person.Phones.FindByType(SystemLookup.PhoneType_Cell);
if (phone != null)
{
tbCellPhone.Text = phone.Number;
cbCellSMS.Checked = phone.SMSEnabled;
}
tbEmail.Text = person.Emails.FirstActive;
// Load Spouse Values
tbSpouseFirstName.Text = spouse.FirstName;
tbSpouseLastName.Text = spouse.LastName;
phone = spouse.Phones.FindByType(SystemLookup.PhoneType_Home);
if (phone != null)
{
tbSpouseHomePhone.Text = phone.Number;
}
phone = spouse.Phones.FindByType(SystemLookup.PhoneType_Cell);
if (phone != null)
{
tbSpouseCellPhone.Text = phone.Number;
cbSpouseSMS.Checked = phone.SMSEnabled;
}
tbSpouseEmail.Text = spouse.Emails.FirstActive;
if (person.PrimaryAddress != null && person.PrimaryAddress.AddressID != -1)
{
tbStreetAddress.Text = person.PrimaryAddress.StreetLine1;
tbCity.Text = person.PrimaryAddress.City;
ListItem li = ddlState.Items.FindByValue(person.PrimaryAddress.State);
if (li != null)
{
li.Selected = true;
}
tbZipCode.Text = person.PrimaryAddress.PostalCode;
}
}
private static PersonPhone PersonPhone(Person person, Guid phoneType)
{
PersonPhone personPhone = person.Phones.FindByType(phoneType);
if (personPhone == null)
{
personPhone = new PersonPhone();
personPhone.PhoneType = new Lookup(phoneType);
person.Phones.Add(personPhone);
}
return(personPhone);
}
public virtual PersonPhone MapBOToEF(
BOPersonPhone bo)
{
PersonPhone efPersonPhone = new PersonPhone();
efPersonPhone.SetProperties(
bo.BusinessEntityID,
bo.ModifiedDate,
bo.PhoneNumber,
bo.PhoneNumberTypeID);
return(efPersonPhone);
}
public virtual BOPersonPhone MapEFToBO(
PersonPhone ef)
{
var bo = new BOPersonPhone();
bo.SetProperties(
ef.BusinessEntityID,
ef.ModifiedDate,
ef.PhoneNumber,
ef.PhoneNumberTypeID);
return(bo);
}
public IHttpActionResult PostPersonPhone(PersonPhone personPhone)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Phones.Add(personPhone);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = personPhone.Id }, personPhone));
}
public void AddPhoneNumber(BusinessObjects.PersonPhone phoneNumber)
{
// Create new entity to add
var newNumber = new PersonPhone();
// Map the BO data onto this new entity
phoneNumber.MapOntoEntity(newNumber);
// Add this entity to the context
Db.PersonPhones.Add(newNumber);
// Save the changes
Db.SaveChanges();
}
// POST api/awbuildversion
public void Post(PersonPhone value)
{
adventureWorks_BC.PersonPhoneAdd(value);
}
public static void MapOntoEntity(this BusinessObjects.PersonPhone source, PersonPhone target)
{
target.BusinessEntityID = source.BusinessEntityId;
target.PhoneNumber = source.PhoneNumber;
target.PhoneNumberTypeID = (int)source.PhoneNumberType;
}
protected int GetPersonIdFromInputData()
{
string sFirstName = tbFirstName.Text;
string sLastName = tbLastName.Text;
string sEmail = tbEmail.Text;
string sAddress = tbAddress1.Text;
string sCity = tbCity.Text;
string sState = tbState.Text;
string sZip = tbZip.Text;
string sPhone = tbPhone.Text;
PersonCollection personCollection = new PersonCollection();
personCollection.LoadByEmail(sEmail);
int iFoundPersonId = -1;
foreach (Person person in personCollection)
{
PersonPhone phoneSearch = new PersonPhone(person.PersonID, FormatPhone(sPhone));
if ((phoneSearch.PersonID == person.PersonID) && (person.LastName.ToLower() == sLastName.ToLower()))
{
this.currentAddress = person.Addresses.FindByType(41);
if(this.currentAddress.Address.PostalCode.Substring(0,5) == sZip )
{
iFoundPersonId = person.PersonID;
}
}
}
if (iFoundPersonId > 0)
{
//person in the db
//easy ride...
}
else
{
//create the family for the person
Family family = new Family();
family.OrganizationID = CurrentArenaContext.Organization.OrganizationID;
family.FamilyName = sLastName + " Family";
//add person to the family
FamilyMember familyMember = new FamilyMember();
family.FamilyMembers.Add(familyMember);
//
// Ensure some of the basics are set correctly.
//
if ((familyMember.Campus == null || familyMember.Campus.CampusId == -1) && NewPersonCampusSetting != -1)
familyMember.Campus = new Campus(NewPersonCampusSetting);
if (familyMember.MemberStatus == null || familyMember.MemberStatus.LookupID == -1)
familyMember.MemberStatus = new Lookup(NewPersonStatusSetting);
if (familyMember.RecordStatus == Arena.Enums.RecordStatus.Undefined)
familyMember.RecordStatus = Arena.Enums.RecordStatus.Pending;
//add person to the db
familyMember.FirstName = sFirstName;
familyMember.FirstName = sFirstName;
familyMember.LastName = sLastName;
familyMember.FamilyRole = new Lookup(new Guid("e410e1a6-8715-4bfb-bf03-1cd18051f815"));
familyMember.Gender = Arena.Enums.Gender.Unknown;
familyMember.MaritalStatus = new Lookup(new Guid("9C000CF2-677B-4725-981E-BD555FDAFB30"));
//add email to db and person to email
PersonEmail personEmail = new PersonEmail();
personEmail.Email = sEmail;
personEmail.Active = true;
familyMember.Emails.Add(personEmail);
//add address to db and person to address
PersonAddress personAddress = new PersonAddress();
personAddress.Address.StreetLine1 = sAddress;
personAddress.Address.City = sCity;
personAddress.Address.State = sState;
personAddress.Address.PostalCode = sZip;
personAddress.AddressType = new Lookup(41);
personAddress.Address.Standardize();
this.currentAddress = personAddress;
familyMember.Addresses.Add(personAddress);
//add phone to db and person to phone
PersonPhone personPhone = new PersonPhone();
personPhone.PhoneType = new Lookup(new Guid("f2a0fba2-d5ab-421f-a5ab-0c67db6fd72e"));
familyMember.Phones.Add(personPhone);
personPhone.Number = FormatPhone(sPhone);
//Save All
family.Save(ModuleUserName);
familyMember.Save(CurrentOrganization.OrganizationID, ModuleUserName, true);
familyMember.SaveEmails(CurrentPortal.OrganizationID, ModuleUserName);
familyMember.SaveAddresses(CurrentPortal.OrganizationID, ModuleUserName);
familyMember.SavePhones(CurrentPortal.OrganizationID, ModuleUserName);
familyMember.Save(CurrentUser.Identity.Name);
iFoundPersonId = familyMember.PersonID;
}
return iFoundPersonId;
}