//[002] code end
/// <summary>
/// Get
/// Calls [usp_select_Quote]
/// </summary>
public static Quote Get(System.Int32?quoteId)
{
Rebound.GlobalTrader.DAL.QuoteDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Quote.Get(quoteId);
if (objDetails == null)
{
return(null);
}
else
{
Quote obj = new Quote();
obj.QuoteId = objDetails.QuoteId;
obj.ClientNo = objDetails.ClientNo;
obj.QuoteNumber = objDetails.QuoteNumber;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.DateQuoted = objDetails.DateQuoted;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.Salesman = objDetails.Salesman;
obj.TermsNo = objDetails.TermsNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.Freight = objDetails.Freight;
obj.Closed = objDetails.Closed;
obj.IncotermNo = objDetails.IncotermNo;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CompanyName = objDetails.CompanyName;
obj.CompanyOnStop = objDetails.CompanyOnStop;
obj.CompanySOApproved = objDetails.CompanySOApproved;
obj.ContactName = objDetails.ContactName;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.SalesmanName = objDetails.SalesmanName;
obj.DivisionName = objDetails.DivisionName;
obj.QuoteValue = objDetails.QuoteValue;
obj.TermsName = objDetails.TermsName;
obj.OpenLines = objDetails.OpenLines;
obj.IncotermName = objDetails.IncotermName;
//[001] code start
obj.TotalQuantityLines = objDetails.TotalQuantityLines;
//[001] code end
//[002] code start
obj.AS9120 = objDetails.AS9120;
//[002] code end
obj.GlobalCurrencyNo = objDetails.GlobalCurrencyNo;
obj.IsCurrencyInSameFaimly = objDetails.IsCurrencyInSameFaimly;
obj.IsImportant = objDetails.IsImportant;
obj.QuoteStatus = objDetails.QuoteStatus;
obj.QuoteStatusName = objDetails.QuoteStatusName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetNextNumber
/// Calls [usp_select_Quote_NextNumber]
/// </summary>
public static Quote GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
Rebound.GlobalTrader.DAL.QuoteDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Quote.GetNextNumber(clientNo, updatedBy);
if (objDetails == null)
{
return(null);
}
else
{
Quote obj = new Quote();
obj.QuoteNumber = objDetails.QuoteNumber;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetIDFromNumber
/// Calls [usp_select_Quote_ID_from_Number]
/// </summary>
public static Quote GetIDFromNumber(System.Int32?quoteNumber, System.Int32?clientNo)
{
Rebound.GlobalTrader.DAL.QuoteDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Quote.GetIDFromNumber(quoteNumber, clientNo);
if (objDetails == null)
{
return(null);
}
else
{
Quote obj = new Quote();
obj.QuoteId = objDetails.QuoteId;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetByNumber
/// Calls [usp_select_Quote_by_Number]
/// </summary>
public static Quote GetByNumber(System.Int32?quoteNumber, System.Int32?clientNo)
{
Rebound.GlobalTrader.DAL.QuoteDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Quote.GetByNumber(quoteNumber, clientNo);
if (objDetails == null)
{
return(null);
}
else
{
Quote obj = new Quote();
obj.QuoteId = objDetails.QuoteId;
obj.ClientNo = objDetails.ClientNo;
obj.QuoteNumber = objDetails.QuoteNumber;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.DateQuoted = objDetails.DateQuoted;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.Salesman = objDetails.Salesman;
obj.TermsNo = objDetails.TermsNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.Freight = objDetails.Freight;
obj.Closed = objDetails.Closed;
obj.IncotermNo = objDetails.IncotermNo;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CompanyName = objDetails.CompanyName;
obj.CompanyOnStop = objDetails.CompanyOnStop;
obj.CompanySOApproved = objDetails.CompanySOApproved;
obj.ContactName = objDetails.ContactName;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.SalesmanName = objDetails.SalesmanName;
obj.DivisionName = objDetails.DivisionName;
obj.QuoteValue = objDetails.QuoteValue;
obj.TermsName = objDetails.TermsName;
obj.OpenLines = objDetails.OpenLines;
obj.IncotermName = objDetails.IncotermName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Returns a new QuoteDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual QuoteDetails GetQuoteFromReader(DbDataReader reader)
{
QuoteDetails quote = new QuoteDetails();
if (reader.HasRows)
{
quote.QuoteId = GetReaderValue_Int32(reader, "QuoteId", 0); //From: [Table]
quote.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table]
quote.QuoteNumber = GetReaderValue_Int32(reader, "QuoteNumber", 0); //From: [Table]
quote.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [Table]
quote.Instructions = GetReaderValue_String(reader, "Instructions", ""); //From: [Table]
quote.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table]
quote.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0); //From: [Table]
quote.DateQuoted = GetReaderValue_DateTime(reader, "DateQuoted", DateTime.MinValue); //From: [Table]
quote.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0); //From: [Table]
quote.Salesman = GetReaderValue_Int32(reader, "Salesman", 0); //From: [Table]
quote.TermsNo = GetReaderValue_NullableInt32(reader, "TermsNo", null); //From: [Table]
quote.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0); //From: [Table]
quote.Freight = GetReaderValue_NullableDouble(reader, "Freight", null); //From: [Table]
quote.Closed = GetReaderValue_NullableBoolean(reader, "Closed", null); //From: [Table]
quote.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
quote.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
quote.IncotermNo = GetReaderValue_NullableInt32(reader, "IncotermNo", null); //From: [Table]
quote.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_itemsearch_PurchaseOrder]
quote.CompanyOnStop = GetReaderValue_NullableBoolean(reader, "CompanyOnStop", null); //From: [usp_select_Quote]
quote.CompanySOApproved = GetReaderValue_NullableBoolean(reader, "CompanySOApproved", null); //From: [usp_select_Quote]
quote.ContactName = GetReaderValue_String(reader, "ContactName", ""); //From: [usp_itemsearch_PurchaseOrder]
quote.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_select_PurchaseOrder]
quote.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_PurchaseOrder]
quote.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); //From: [usp_select_Quote]
quote.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); //From: [usp_select_PurchaseOrder]
quote.QuoteValue = GetReaderValue_NullableDouble(reader, "QuoteValue", null); //From: [usp_select_Quote]
quote.TermsName = GetReaderValue_String(reader, "TermsName", ""); //From: [usp_select_PurchaseOrder]
quote.OpenLines = GetReaderValue_NullableInt32(reader, "OpenLines", null); //From: [usp_select_Quote]
quote.IncotermName = GetReaderValue_String(reader, "IncotermName", ""); //From: [usp_select_PurchaseOrder]
quote.ContactEmail = GetReaderValue_String(reader, "ContactEmail", ""); //From: [usp_select_PurchaseOrder_for_Print]
quote.CreditLimit = GetReaderValue_NullableDouble(reader, "CreditLimit", null); //From: [usp_selectAll_PurchaseOrder_due_for_Client]
quote.Balance = GetReaderValue_NullableDouble(reader, "Balance", null); //From: [usp_selectAll_PurchaseOrder_due_for_Client]
}
return(quote);
}
/// <summary>
/// GetForPage
/// Calls [usp_select_Quote_for_Page]
/// </summary>
public static Quote GetForPage(System.Int32?quoteId)
{
Rebound.GlobalTrader.DAL.QuoteDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Quote.GetForPage(quoteId);
if (objDetails == null)
{
return(null);
}
else
{
Quote obj = new Quote();
obj.QuoteId = objDetails.QuoteId;
obj.QuoteNumber = objDetails.QuoteNumber;
obj.ClientNo = objDetails.ClientNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.Closed = objDetails.Closed;
obj.TeamNo = objDetails.TeamNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.Salesman = objDetails.Salesman;
obj.QuoteStatusName = objDetails.QuoteStatusName;
objDetails = null;
return(obj);
}
}
