/// <summary> /// Get /// Calls [usp_select_Division] /// </summary> public static Division Get(System.Int32?divisionId) { Rebound.GlobalTrader.DAL.DivisionDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Division.Get(divisionId); if (objDetails == null) { return(null); } else { Division obj = new Division(); obj.DivisionId = objDetails.DivisionId; obj.ClientNo = objDetails.ClientNo; obj.DivisionName = objDetails.DivisionName; obj.AddressNo = objDetails.AddressNo; obj.Manager = objDetails.Manager; obj.Budget = objDetails.Budget; obj.Telephone = objDetails.Telephone; obj.Fax = objDetails.Fax; obj.EMail = objDetails.EMail; obj.Notes = objDetails.Notes; obj.URL = objDetails.URL; obj.Inactive = objDetails.Inactive; obj.HasDocumentHeaderImage = objDetails.HasDocumentHeaderImage; obj.UseCompanyHeaderForInvoice = objDetails.UseCompanyHeaderForInvoice; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.Agency = objDetails.Agency; obj.ManagerName = objDetails.ManagerName; objDetails = null; return(obj); } }
/// <summary> /// Returns a new DivisionDetails instance filled with the DataReader's current record data /// </summary> protected virtual DivisionDetails GetDivisionFromReader(DbDataReader reader) { DivisionDetails division = new DivisionDetails(); if (reader.HasRows) { division.DivisionId = GetReaderValue_Int32(reader, "DivisionId", 0); //From: [Table] division.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table] division.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); //From: [usp_select_Credit] division.AddressNo = GetReaderValue_NullableInt32(reader, "AddressNo", null); //From: [Table] division.Manager = GetReaderValue_NullableInt32(reader, "Manager", null); //From: [Table] division.Budget = GetReaderValue_NullableDouble(reader, "Budget", null); //From: [Table] division.Telephone = GetReaderValue_String(reader, "Telephone", ""); //From: [Table] division.Fax = GetReaderValue_String(reader, "Fax", ""); //From: [Table] division.EMail = GetReaderValue_String(reader, "EMail", ""); //From: [Table] division.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [usp_select_Address_DefaultBilling_for_Company] division.URL = GetReaderValue_String(reader, "URL", ""); //From: [Table] division.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table] division.HasDocumentHeaderImage = GetReaderValue_Boolean(reader, "HasDocumentHeaderImage", false); //From: [Table] division.UseCompanyHeaderForInvoice = GetReaderValue_Boolean(reader, "UseCompanyHeaderForInvoice", false); //From: [Table] division.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] division.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] division.ManagerName = GetReaderValue_String(reader, "ManagerName", ""); //From: [usp_select_Division] division.NumberOfMembers = GetReaderValue_NullableInt32(reader, "NumberOfMembers", null); //From: [usp_selectAll_Division_for_Client] } return(division); }
/// <summary> /// GetHasDocumentHeader /// Calls [usp_select_Division_HasDocumentHeader] /// </summary> public static Division GetHasDocumentHeader(System.Int32?divisionId) { Rebound.GlobalTrader.DAL.DivisionDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Division.GetHasDocumentHeader(divisionId); if (objDetails == null) { return(null); } else { Division obj = new Division(); obj.HasDocumentHeaderImage = objDetails.HasDocumentHeaderImage; obj.UseCompanyHeaderForInvoice = objDetails.UseCompanyHeaderForInvoice; objDetails = null; return(obj); } }