//[001] code end /// <summary> /// Get /// Calls [usp_select_Contact] /// </summary> public static Contact Get(System.Int32?contactId) { Rebound.GlobalTrader.DAL.ContactDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Contact.Get(contactId); if (objDetails == null) { return(null); } else { Contact obj = new Contact(); obj.ContactId = objDetails.ContactId; obj.ContactName = objDetails.ContactName; obj.Salutation = objDetails.Salutation; obj.FirstName = objDetails.FirstName; obj.LastName = objDetails.LastName; obj.Telephone = objDetails.Telephone; obj.Extension = objDetails.Extension; obj.Fax = objDetails.Fax; obj.Title = objDetails.Title; obj.EMail = objDetails.EMail; obj.HomeTelephone = objDetails.HomeTelephone; obj.MobileTelephone = objDetails.MobileTelephone; obj.CompanyNo = objDetails.CompanyNo; obj.Notes = objDetails.Notes; obj.AddressNo = objDetails.AddressNo; obj.ContactPositionNo = objDetails.ContactPositionNo; obj.TextOnlyEmail = objDetails.TextOnlyEmail; obj.Inactive = objDetails.Inactive; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.CompanyName = objDetails.CompanyName; obj.FullName = objDetails.FullName; obj.ClientNo = objDetails.ClientNo; obj.Salesman = objDetails.Salesman; obj.DefaultPOContactNo = objDetails.DefaultPOContactNo; obj.DefaultSOContactNo = objDetails.DefaultSOContactNo; obj.SalesmanName = objDetails.SalesmanName; obj.TeamNo = objDetails.TeamNo; obj.DivisionNo = objDetails.DivisionNo; obj.HasSupplementalData = objDetails.HasSupplementalData; obj.HasUserDefinedData = objDetails.HasUserDefinedData; //[001] code start obj.FinanceContact = objDetails.FinanceContact; //[001] code end objDetails = null; return(obj); } }
//[001] code end #endregion /// <summary> /// Returns a new ContactDetails instance filled with the DataReader's current record data /// </summary> protected virtual ContactDetails GetContactFromReader(DbDataReader reader) { ContactDetails contact = new ContactDetails(); if (reader.HasRows) { contact.ContactId = GetReaderValue_Int32(reader, "ContactId", 0); //From: [Table] contact.ContactName = GetReaderValue_String(reader, "ContactName", ""); //From: [Table] contact.Salutation = GetReaderValue_String(reader, "Salutation", ""); //From: [Table] contact.FirstName = GetReaderValue_String(reader, "FirstName", ""); //From: [Table] contact.LastName = GetReaderValue_String(reader, "LastName", ""); //From: [Table] contact.Telephone = GetReaderValue_String(reader, "Telephone", ""); //From: [Table] contact.Extension = GetReaderValue_String(reader, "Extension", ""); //From: [Table] contact.Fax = GetReaderValue_String(reader, "Fax", ""); //From: [Table] contact.Title = GetReaderValue_String(reader, "Title", ""); //From: [Table] contact.EMail = GetReaderValue_String(reader, "EMail", ""); //From: [Table] contact.HomeTelephone = GetReaderValue_String(reader, "HomeTelephone", ""); //From: [Table] contact.MobileTelephone = GetReaderValue_String(reader, "MobileTelephone", ""); //From: [Table] contact.CompanyNo = GetReaderValue_NullableInt32(reader, "CompanyNo", null); //From: [Table] contact.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [Table] contact.AddressNo = GetReaderValue_NullableInt32(reader, "AddressNo", null); //From: [Table] contact.ContactPositionNo = GetReaderValue_NullableInt32(reader, "ContactPositionNo", null); //From: [Table] contact.TextOnlyEmail = GetReaderValue_NullableBoolean(reader, "TextOnlyEmail", null); //From: [Table] contact.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table] contact.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] contact.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] contact.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_datalistnugget_Contact] contact.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); //From: [usp_datalistnugget_Contact] contact.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); //From: [usp_datalistnugget_Contact] contact.FullName = GetReaderValue_String(reader, "FullName", ""); //From: [usp_select_Contact] contact.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [usp_select_Contact] contact.Salesman = GetReaderValue_NullableInt32(reader, "Salesman", null); //From: [usp_select_Contact] contact.DefaultPOContactNo = GetReaderValue_NullableInt32(reader, "DefaultPOContactNo", null); //From: [usp_select_Contact] contact.DefaultSOContactNo = GetReaderValue_NullableInt32(reader, "DefaultSOContactNo", null); //From: [usp_select_Contact] contact.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null); //From: [usp_select_Contact] contact.DivisionNo = GetReaderValue_NullableInt32(reader, "DivisionNo", null); //From: [usp_select_Contact] contact.HasSupplementalData = GetReaderValue_Int32(reader, "HasSupplementalData", 0); //From: [usp_select_Contact] contact.HasUserDefinedData = GetReaderValue_Int32(reader, "HasUserDefinedData", 0); //From: [usp_select_Contact] contact.DefaultPO = GetReaderValue_NullableBoolean(reader, "DefaultPO", null); //From: [usp_selectAll_Contact_for_Company] contact.DefaultSO = GetReaderValue_NullableBoolean(reader, "DefaultSO", null); //From: [usp_selectAll_Contact_for_Company] } return(contact); }
/// <summary> /// GetForPage /// Calls [usp_select_Contact_for_Page] /// </summary> public static Contact GetForPage(System.Int32?contactId) { Rebound.GlobalTrader.DAL.ContactDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Contact.GetForPage(contactId); if (objDetails == null) { return(null); } else { Contact obj = new Contact(); obj.ContactId = objDetails.ContactId; obj.ContactName = objDetails.ContactName; obj.Inactive = objDetails.Inactive; obj.CompanyNo = objDetails.CompanyNo; obj.TeamNo = objDetails.TeamNo; obj.DivisionNo = objDetails.DivisionNo; obj.Salesman = objDetails.Salesman; obj.ClientNo = objDetails.ClientNo; objDetails = null; return(obj); } }