/// <summary> /// Get /// Calls [usp_select_Service] /// </summary> public static Service Get(System.Int32?serviceId) { Rebound.GlobalTrader.DAL.ServiceDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Service.Get(serviceId); if (objDetails == null) { return(null); } else { Service obj = new Service(); obj.ServiceId = objDetails.ServiceId; obj.ClientNo = objDetails.ClientNo; obj.ServiceName = objDetails.ServiceName; obj.ServiceDescription = objDetails.ServiceDescription; obj.Price = objDetails.Price; obj.Cost = objDetails.Cost; obj.Notes = objDetails.Notes; obj.LotNo = objDetails.LotNo; obj.Inactive = objDetails.Inactive; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.LotName = objDetails.LotName; obj.Allocations = objDetails.Allocations; objDetails = null; return(obj); } }
/// <summary> /// GetForPage /// Calls [usp_select_Service_for_Page] /// </summary> public static Service GetForPage(System.Int32?serviceId) { Rebound.GlobalTrader.DAL.ServiceDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Service.GetForPage(serviceId); if (objDetails == null) { return(null); } else { Service obj = new Service(); obj.ServiceId = objDetails.ServiceId; obj.ServiceName = objDetails.ServiceName; obj.ClientNo = objDetails.ClientNo; obj.Inactive = objDetails.Inactive; objDetails = null; return(obj); } }
/// <summary> /// Returns a new ServiceDetails instance filled with the DataReader's current record data /// </summary> protected virtual ServiceDetails GetServiceFromReader(DbDataReader reader) { ServiceDetails service = new ServiceDetails(); if (reader.HasRows) { service.ServiceId = GetReaderValue_Int32(reader, "ServiceId", 0); //From: [Table] service.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table] service.ServiceName = GetReaderValue_String(reader, "ServiceName", ""); //From: [Table] service.ServiceDescription = GetReaderValue_String(reader, "ServiceDescription", ""); //From: [Table] service.Price = GetReaderValue_NullableDouble(reader, "Price", null); //From: [usp_selectAll_Allocation_for_CustomerRMALine] service.Cost = GetReaderValue_NullableDouble(reader, "Cost", null); //From: [usp_selectAll_Login_Top_Salespersons] service.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [usp_select_Address_DefaultBilling_for_Company] service.LotNo = GetReaderValue_NullableInt32(reader, "LotNo", null); //From: [Table] service.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table] service.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] service.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] service.LotName = GetReaderValue_String(reader, "LotName", ""); //From: [usp_select_GoodsInLine] service.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); //From: [usp_list_Activity_by_Client_with_filter] service.Allocations = GetReaderValue_NullableInt32(reader, "Allocations", null); //From: [usp_select_Service] } return(service); }