/// <summary>
/// GetForPage
/// Calls [usp_select_Credit_for_Page]
/// </summary>
public static Credit GetForPage(System.Int32?creditId)
{
Rebound.GlobalTrader.DAL.CreditDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Credit.GetForPage(creditId);
if (objDetails == null)
{
return(null);
}
else
{
Credit obj = new Credit();
obj.CreditId = objDetails.CreditId;
obj.CreditNumber = objDetails.CreditNumber;
obj.ClientNo = objDetails.ClientNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.TeamNo = objDetails.TeamNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.Salesman = objDetails.Salesman;
obj.isClientInvoice = objDetails.isClientInvoice;
obj.RefClientName = objDetails.RefClientName;
obj.RefClientNo = objDetails.RefClientNo;
obj.ClientCreditNo = objDetails.ClientCreditNo;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetNextNumber
/// Calls [usp_select_Credit_NextNumber]
/// </summary>
public static Credit GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
Rebound.GlobalTrader.DAL.CreditDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Credit.GetNextNumber(clientNo, updatedBy);
if (objDetails == null)
{
return(null);
}
else
{
Credit obj = new Credit();
obj.CreditNumber = objDetails.CreditNumber;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetIdByNumber
/// Calls [usp_select_Credit_Id_by_Number]
/// </summary>
public static Credit GetIdByNumber(System.Int32?creditNumber, System.Int32?clientNo)
{
Rebound.GlobalTrader.DAL.CreditDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Credit.GetIdByNumber(creditNumber, clientNo);
if (objDetails == null)
{
return(null);
}
else
{
Credit obj = new Credit();
obj.CreditId = objDetails.CreditId;
objDetails = null;
return(obj);
}
}
/// <summary>
/// Returns a new CreditDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual CreditDetails GetCreditFromReader(DbDataReader reader)
{
CreditDetails credit = new CreditDetails();
if (reader.HasRows)
{
credit.CreditId = GetReaderValue_Int32(reader, "CreditId", 0); //From: [Table]
credit.CreditNumber = GetReaderValue_Int32(reader, "CreditNumber", 0); //From: [Table]
credit.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table]
credit.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table]
credit.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0); //From: [Table]
credit.CreditDate = GetReaderValue_DateTime(reader, "CreditDate", DateTime.MinValue); //From: [Table]
credit.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0); //From: [Table]
credit.RaisedBy = GetReaderValue_NullableInt32(reader, "RaisedBy", null); //From: [Table]
credit.Salesman = GetReaderValue_Int32(reader, "Salesman", 0); //From: [Table]
credit.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [Table]
credit.Instructions = GetReaderValue_String(reader, "Instructions", ""); //From: [Table]
credit.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null); //From: [Table]
credit.Account = GetReaderValue_String(reader, "Account", ""); //From: [Table]
credit.ShippingCost = GetReaderValue_NullableDouble(reader, "ShippingCost", null); //From: [Table]
credit.Freight = GetReaderValue_NullableDouble(reader, "Freight", null); //From: [Table]
credit.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0); //From: [Table]
credit.TaxNo = GetReaderValue_NullableInt32(reader, "TaxNo", null); //From: [Table]
credit.InvoiceNo = GetReaderValue_NullableInt32(reader, "InvoiceNo", null); //From: [Table]
credit.CustomerRMANo = GetReaderValue_NullableInt32(reader, "CustomerRMANo", null); //From: [Table]
credit.ReferenceDate = GetReaderValue_DateTime(reader, "ReferenceDate", DateTime.MinValue); //From: [Table]
credit.CustomerPO = GetReaderValue_String(reader, "CustomerPO", ""); //From: [Table]
credit.CustomerRMA = GetReaderValue_String(reader, "CustomerRMA", ""); //From: [Table]
credit.CustomerDebit = GetReaderValue_String(reader, "CustomerDebit", ""); //From: [Table]
credit.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
credit.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
credit.Salesman2 = GetReaderValue_NullableInt32(reader, "Salesman2", null); //From: [Table]
credit.Salesman2Percent = GetReaderValue_Double(reader, "Salesman2Percent", 0); //From: [Table]
credit.IncotermNo = GetReaderValue_NullableInt32(reader, "IncotermNo", null); //From: [Table]
credit.DivisionNo2 = GetReaderValue_NullableInt32(reader, "DivisionNo2", null); //From: [Table]
credit.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_select_Credit]
credit.CustomerCode = GetReaderValue_String(reader, "CustomerCode", ""); //From: [usp_select_Credit]
credit.ContactName = GetReaderValue_String(reader, "ContactName", ""); //From: [usp_select_Credit]
credit.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_select_Credit]
credit.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_Credit]
credit.RaiserName = GetReaderValue_String(reader, "RaiserName", ""); //From: [usp_select_Credit]
credit.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); //From: [usp_select_Credit]
credit.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null); //From: [usp_select_Credit]
credit.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); //From: [usp_select_Credit]
credit.Salesman2Name = GetReaderValue_String(reader, "Salesman2Name", ""); //From: [usp_select_Credit]
credit.TaxName = GetReaderValue_String(reader, "TaxName", ""); //From: [usp_select_Credit]
credit.InvoiceNumber = GetReaderValue_NullableInt32(reader, "InvoiceNumber", null); //From: [usp_select_Credit]
credit.InvoiceDate = GetReaderValue_NullableDateTime(reader, "InvoiceDate", null); //From: [usp_select_Credit]
credit.SalesOrderNo = GetReaderValue_NullableInt32(reader, "SalesOrderNo", null); //From: [usp_select_Credit]
credit.SalesOrderNumber = GetReaderValue_NullableInt32(reader, "SalesOrderNumber", null); //From: [usp_select_Credit]
credit.CustomerRMANumber = GetReaderValue_NullableInt32(reader, "CustomerRMANumber", null); //From: [usp_select_Credit]
credit.CustomerRMADate = GetReaderValue_NullableDateTime(reader, "CustomerRMADate", null); //From: [usp_select_Credit]
credit.ShipViaName = GetReaderValue_String(reader, "ShipViaName", ""); //From: [usp_select_Credit]
credit.CreditValue = GetReaderValue_NullableDouble(reader, "CreditValue", null); //From: [usp_select_Credit]
credit.CreditCost = GetReaderValue_NullableDouble(reader, "CreditCost", null); //From: [usp_select_Credit]
credit.TaxRate = GetReaderValue_NullableDouble(reader, "TaxRate", null); //From: [usp_select_Credit]
credit.IncotermName = GetReaderValue_String(reader, "IncotermName", ""); //From: [usp_select_Credit]
credit.CompanyTelephone = GetReaderValue_String(reader, "CompanyTelephone", ""); //From: [usp_select_Credit_for_Print]
credit.CompanyFax = GetReaderValue_String(reader, "CompanyFax", ""); //From: [usp_select_Credit_for_Print]
credit.ContactEmail = GetReaderValue_String(reader, "ContactEmail", ""); //From: [usp_select_Credit_for_Print]
}
return(credit);
}
/// <summary>
/// GetForPrint
/// Calls [usp_select_Credit_for_Print]
/// </summary>
public static Credit GetForPrint(System.Int32?creditId)
{
Rebound.GlobalTrader.DAL.CreditDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Credit.GetForPrint(creditId);
if (objDetails == null)
{
return(null);
}
else
{
Credit obj = new Credit();
obj.CreditId = objDetails.CreditId;
obj.CreditNumber = objDetails.CreditNumber;
obj.ClientNo = objDetails.ClientNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.CreditDate = objDetails.CreditDate;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.RaisedBy = objDetails.RaisedBy;
obj.Salesman = objDetails.Salesman;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.Account = objDetails.Account;
obj.ShippingCost = objDetails.ShippingCost;
obj.Freight = objDetails.Freight;
obj.DivisionNo = objDetails.DivisionNo;
obj.TaxNo = objDetails.TaxNo;
obj.InvoiceNo = objDetails.InvoiceNo;
obj.CustomerRMANo = objDetails.CustomerRMANo;
obj.ReferenceDate = objDetails.ReferenceDate;
obj.CustomerPO = objDetails.CustomerPO;
obj.CustomerRMA = objDetails.CustomerRMA;
obj.CustomerDebit = objDetails.CustomerDebit;
obj.Salesman2 = objDetails.Salesman2;
obj.Salesman2Percent = objDetails.Salesman2Percent;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CompanyName = objDetails.CompanyName;
obj.CustomerCode = objDetails.CustomerCode;
obj.ContactName = objDetails.ContactName;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.RaiserName = objDetails.RaiserName;
obj.SalesmanName = objDetails.SalesmanName;
obj.TeamNo = objDetails.TeamNo;
obj.DivisionName = objDetails.DivisionName;
obj.Salesman2Name = objDetails.Salesman2Name;
obj.TaxName = objDetails.TaxName;
obj.InvoiceNumber = objDetails.InvoiceNumber;
obj.InvoiceDate = objDetails.InvoiceDate;
obj.SalesOrderNo = objDetails.SalesOrderNo;
obj.SalesOrderNumber = objDetails.SalesOrderNumber;
obj.CustomerRMANumber = objDetails.CustomerRMANumber;
obj.CustomerRMADate = objDetails.CustomerRMADate;
obj.ShipViaName = objDetails.ShipViaName;
obj.CreditValue = objDetails.CreditValue;
obj.CreditCost = objDetails.CreditCost;
obj.TaxRate = objDetails.TaxRate;
obj.IncotermNo = objDetails.IncotermNo;
//[001] start code
obj.CreditNoteBankFee = objDetails.CreditNoteBankFee;
//[001] end code
obj.IncotermName = objDetails.IncotermName;
obj.CompanyTelephone = objDetails.CompanyTelephone;
obj.CompanyFax = objDetails.CompanyFax;
obj.ShipViaName = objDetails.ShipViaName;
obj.ContactEmail = objDetails.ContactEmail;
obj.IncotermName = objDetails.IncotermName;
obj.VATNO = objDetails.VATNO;
obj.ClientCreditNo = objDetails.ClientCreditNo;
obj.RefNumber = objDetails.RefNumber;
obj.isClientInvoice = objDetails.isClientInvoice;
obj.RefClientNo = objDetails.RefClientNo;
obj.RefClientName = objDetails.RefClientName;
obj.ClientInvoiceNo = objDetails.ClientInvoiceNo;
obj.ClientInvoiceNumber = objDetails.ClientInvoiceNumber;
obj.ClientShipTo = objDetails.ClientShipTo;
obj.Telephone = objDetails.Telephone;
obj.Fax = objDetails.Fax;
obj.ClientCustomerCode = objDetails.ClientCustomerCode;
obj.Email = objDetails.Email;
obj.VAT = objDetails.VAT;
obj.Tax = objDetails.Tax;
obj.ClientBillToAdr = objDetails.ClientBillToAdr;
obj.ExchangeRate = objDetails.ExchangeRate;
obj.LocalCurrencyNo = objDetails.LocalCurrencyNo;
obj.ApplyLocalCurrency = objDetails.ApplyLocalCurrency;
obj.LocalCurrencyCode = objDetails.LocalCurrencyCode;
objDetails = null;
return(obj);
}
}
