private static ContactSupplement PopulateFromDBDetailsObject(ContactSupplementDetails obj) { ContactSupplement objNew = new ContactSupplement(); objNew.ContactNo = obj.ContactNo; objNew.Birthday = obj.Birthday; objNew.PartnerName = obj.PartnerName; objNew.PartnerBirthday = obj.PartnerBirthday; objNew.Anniversary = obj.Anniversary; objNew.NumberOfChildren = obj.NumberOfChildren; objNew.ChildName1 = obj.ChildName1; objNew.ChildBirthday1 = obj.ChildBirthday1; objNew.ChildName2 = obj.ChildName2; objNew.ChildBirthday2 = obj.ChildBirthday2; objNew.ChildName3 = obj.ChildName3; objNew.ChildBirthday3 = obj.ChildBirthday3; objNew.PersonalCellphone = obj.PersonalCellphone; objNew.FavouriteSport = obj.FavouriteSport; objNew.FavouriteTeam = obj.FavouriteTeam; objNew.Hobbies = obj.Hobbies; objNew.Inactive = obj.Inactive; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.GenderNo = obj.GenderNo; objNew.MaritalStatusNo = obj.MaritalStatusNo; objNew.ChildGenderNo1 = obj.ChildGenderNo1; objNew.ChildGenderNo2 = obj.ChildGenderNo2; objNew.ChildGenderNo3 = obj.ChildGenderNo3; objNew.MaritalStatusName = obj.MaritalStatusName; return(objNew); }
/// <summary> /// Get /// Calls [usp_select_ContactSupplement] /// </summary> public override ContactSupplementDetails Get(System.Int32?contactNo) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_ContactSupplement", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ContactNo", SqlDbType.Int).Value = contactNo; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetContactSupplementFromReader(reader); ContactSupplementDetails obj = new ContactSupplementDetails(); obj.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0); obj.Birthday = GetReaderValue_NullableDateTime(reader, "Birthday", null); obj.PartnerName = GetReaderValue_String(reader, "PartnerName", ""); obj.PartnerBirthday = GetReaderValue_NullableDateTime(reader, "PartnerBirthday", null); obj.Anniversary = GetReaderValue_NullableDateTime(reader, "Anniversary", null); obj.NumberOfChildren = GetReaderValue_NullableInt32(reader, "NumberOfChildren", null); obj.ChildName1 = GetReaderValue_String(reader, "ChildName1", ""); obj.ChildBirthday1 = GetReaderValue_NullableDateTime(reader, "ChildBirthday1", null); obj.ChildName2 = GetReaderValue_String(reader, "ChildName2", ""); obj.ChildBirthday2 = GetReaderValue_NullableDateTime(reader, "ChildBirthday2", null); obj.ChildName3 = GetReaderValue_String(reader, "ChildName3", ""); obj.ChildBirthday3 = GetReaderValue_NullableDateTime(reader, "ChildBirthday3", null); obj.PersonalCellphone = GetReaderValue_String(reader, "PersonalCellphone", ""); obj.FavouriteSport = GetReaderValue_String(reader, "FavouriteSport", ""); obj.FavouriteTeam = GetReaderValue_String(reader, "FavouriteTeam", ""); obj.Hobbies = GetReaderValue_String(reader, "Hobbies", ""); obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.GenderNo = GetReaderValue_NullableInt32(reader, "GenderNo", null); obj.MaritalStatusNo = GetReaderValue_NullableInt32(reader, "MaritalStatusNo", null); obj.ChildGenderNo1 = GetReaderValue_NullableInt32(reader, "ChildGenderNo1", null); obj.ChildGenderNo2 = GetReaderValue_NullableInt32(reader, "ChildGenderNo2", null); obj.ChildGenderNo3 = GetReaderValue_NullableInt32(reader, "ChildGenderNo3", null); obj.MaritalStatusName = GetReaderValue_String(reader, "MaritalStatusName", ""); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get ContactSupplement", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }