/// <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);
}
