private static List<PhoneInfo> FillPhonCollection(IDataReader reader, out int totalRecords) { var retVal = new List<PhoneInfo>(); totalRecords = 0; try { while (reader.Read()) { //fill business object var info = new PhoneInfo(); /* info.PhoneId = ConvertHelper.ToInt32(reader["PhoneId"]); info.ContactId = ConvertHelper.ToInt32(reader["ContactId"]); info.PhoneType = ConvertHelper.ToString(reader["PhoneType"]); info.PhoneNumber = ConvertHelper.ToString(reader["PhoneNumber"]); info.IsPrimary = ConvertHelper.ToInt32(reader["IsPrimary"]); */ retVal.Add(info); } //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } catch (Exception exc) { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return retVal; }
private static void UpdatePhone(int contactId, List<string> mobiles) { if (mobiles.IsNullOrEmpty()) return; var listPhones = PhoneRepository.GetByContact(contactId) ?? new List<PhoneInfo>(); foreach (var mobile in mobiles .Where(c => !c.IsStringNullOrEmpty()) .Where(c => !listPhones.Exists(p => p.PhoneNumber.Equals(c)))) { if (!listPhones.Exists(c => c.PhoneType.ToInt32() == (int)PhoneType.HomePhone)) { var phone = new PhoneInfo { IsPrimary = 0, PhoneNumber = mobile, ContactId = contactId, PhoneType = ((int)PhoneType.HomePhone).ToString(), }; PhoneRepository.Create(phone); listPhones.Add(phone); } if (!listPhones.Exists(c => c.PhoneType.ToInt32() == (int)PhoneType.MobilePhone)) { var phone = new PhoneInfo { IsPrimary = 0, PhoneNumber = mobile, ContactId = contactId, PhoneType = ((int)PhoneType.MobilePhone).ToString(), }; PhoneRepository.Create(phone); listPhones.Add(phone); } if (!listPhones.Exists(c => c.PhoneType.ToInt32() == (int)PhoneType.Tel)) { var phone = new PhoneInfo { IsPrimary = 0, PhoneNumber = mobile, ContactId = contactId, PhoneType = ((int)PhoneType.Tel).ToString(), }; PhoneRepository.Create(phone); listPhones.Add(phone); } } }
public static void Update(PhoneInfo info) { DataProvider.Instance().Phones_Update(info.ContactId, info.PhoneType, info.PhoneNumber,info.IsPrimary); }