/// <summary>
/// GetForPage
/// Calls [usp_select_Debit_for_Page]
/// </summary>
public static Debit GetForPage(System.Int32?debitId)
{
Rebound.GlobalTrader.DAL.DebitDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Debit.GetForPage(debitId);
if (objDetails == null)
{
return(null);
}
else
{
Debit obj = new Debit();
obj.DebitId = objDetails.DebitId;
obj.ClientNo = objDetails.ClientNo;
obj.DebitNumber = objDetails.DebitNumber;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.TeamNo = objDetails.TeamNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.Buyer = objDetails.Buyer;
obj.POHubCompanyNo = objDetails.POHubCompanyNo;
obj.POHubCompanyName = objDetails.POHubCompanyName;
obj.InternalPurchaseOrderNo = objDetails.InternalPurchaseOrderNo;
obj.ClientName = objDetails.ClientName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetForPrint
/// Calls [usp_select_Debit_for_Print]
/// </summary>
public static Debit GetForPrint(System.Int32?debitNo, bool IsHUBdebitNo)
{
Rebound.GlobalTrader.DAL.DebitDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Debit.GetForPrint(debitNo, IsHUBdebitNo);
if (objDetails == null)
{
return(null);
}
else
{
Debit obj = new Debit();
obj.DebitId = objDetails.DebitId;
obj.DebitNumber = objDetails.DebitNumber;
obj.ClientNo = objDetails.ClientNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.DebitDate = objDetails.DebitDate;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.RaisedBy = objDetails.RaisedBy;
obj.Buyer = objDetails.Buyer;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.Freight = objDetails.Freight;
obj.DivisionNo = objDetails.DivisionNo;
obj.TaxNo = objDetails.TaxNo;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.SupplierRMANo = objDetails.SupplierRMANo;
obj.ReferenceDate = objDetails.ReferenceDate;
obj.SupplierInvoice = objDetails.SupplierInvoice;
obj.SupplierRMA = objDetails.SupplierRMA;
obj.SupplierCredit = objDetails.SupplierCredit;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CompanyName = objDetails.CompanyName;
obj.ContactName = objDetails.ContactName;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.RaiserName = objDetails.RaiserName;
obj.BuyerName = objDetails.BuyerName;
obj.TeamNo = objDetails.TeamNo;
obj.DivisionName = objDetails.DivisionName;
obj.TaxName = objDetails.TaxName;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.PurchaseOrderDate = objDetails.PurchaseOrderDate;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.DebitValue = objDetails.DebitValue;
obj.TaxRate = objDetails.TaxRate;
obj.CompanyTelephone = objDetails.CompanyTelephone;
obj.CompanyFax = objDetails.CompanyFax;
obj.ContactEmail = objDetails.ContactEmail;
obj.VATNO = objDetails.VATNO;
obj.SupplierCode = objDetails.SupplierCode;
obj.POHubCompanyNo = objDetails.POHubCompanyNo;
obj.POHubCompanyName = objDetails.POHubCompanyName;
obj.ClientRefNo = objDetails.ClientRefNo;
objDetails = null;
return(obj);
}
}
// [003] end
/// <summary>
/// GetNextNumber
/// Calls [usp_select_Debit_NextNumber]
/// </summary>
public static Debit GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
Rebound.GlobalTrader.DAL.DebitDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Debit.GetNextNumber(clientNo, updatedBy);
if (objDetails == null)
{
return(null);
}
else
{
Debit obj = new Debit();
obj.DebitNumber = objDetails.DebitNumber;
objDetails = null;
return(obj);
}
}
//[001] code end
#endregion
/// <summary>
/// Returns a new DebitDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual DebitDetails GetDebitFromReader(DbDataReader reader) {
DebitDetails debit = new DebitDetails();
if (reader.HasRows) {
debit.DebitId = GetReaderValue_Int32(reader, "DebitId", 0); //From: [Table]
debit.DebitNumber = GetReaderValue_Int32(reader, "DebitNumber", 0); //From: [Table]
debit.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table]
debit.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table]
debit.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0); //From: [Table]
debit.DebitDate = GetReaderValue_DateTime(reader, "DebitDate", DateTime.MinValue); //From: [Table]
debit.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0); //From: [Table]
debit.RaisedBy = GetReaderValue_NullableInt32(reader, "RaisedBy", null); //From: [Table]
debit.Buyer = GetReaderValue_Int32(reader, "Buyer", 0); //From: [Table]
debit.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [Table]
debit.Instructions = GetReaderValue_String(reader, "Instructions", ""); //From: [Table]
debit.Freight = GetReaderValue_NullableDouble(reader, "Freight", null); //From: [Table]
debit.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0); //From: [Table]
debit.TaxNo = GetReaderValue_NullableInt32(reader, "TaxNo", null); //From: [Table]
debit.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null); //From: [Table]
debit.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null); //From: [Table]
debit.ReferenceDate = GetReaderValue_DateTime(reader, "ReferenceDate", DateTime.MinValue); //From: [Table]
debit.SupplierInvoice = GetReaderValue_String(reader, "SupplierInvoice", ""); //From: [Table]
debit.SupplierRMA = GetReaderValue_String(reader, "SupplierRMA", ""); //From: [Table]
debit.SupplierCredit = GetReaderValue_String(reader, "SupplierCredit", ""); //From: [Table]
debit.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
debit.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
debit.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_itemsearch_Debit]
debit.ContactName = GetReaderValue_String(reader, "ContactName", ""); //From: [usp_itemsearch_Debit]
debit.RaiserName = GetReaderValue_String(reader, "RaiserName", ""); //From: [usp_itemsearch_Debit]
debit.PurchaseOrderNumber = GetReaderValue_Int32(reader, "PurchaseOrderNumber", 0); //From: [usp_itemsearch_Debit]
debit.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null); //From: [usp_itemsearch_Debit]
debit.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); //From: [usp_itemsearch_Debit]
debit.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_select_Debit]
debit.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_Debit]
debit.BuyerName = GetReaderValue_String(reader, "BuyerName", ""); //From: [usp_select_Debit]
debit.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null); //From: [usp_select_Debit]
debit.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); //From: [usp_select_Debit]
debit.TaxName = GetReaderValue_String(reader, "TaxName", ""); //From: [usp_select_Debit]
debit.PurchaseOrderDate = GetReaderValue_DateTime(reader, "PurchaseOrderDate", DateTime.MinValue); //From: [usp_select_Debit]
debit.DebitValue = GetReaderValue_NullableDouble(reader, "DebitValue", null); //From: [usp_select_Debit]
debit.TaxRate = GetReaderValue_NullableDouble(reader, "TaxRate", null); //From: [usp_select_Debit]
debit.CompanyTelephone = GetReaderValue_String(reader, "CompanyTelephone", ""); //From: [usp_select_Debit_for_Print]
debit.CompanyFax = GetReaderValue_String(reader, "CompanyFax", ""); //From: [usp_select_Debit_for_Print]
debit.ContactEmail = GetReaderValue_String(reader, "ContactEmail", ""); //From: [usp_select_Debit_for_Print]
debit.VATNO = GetReaderValue_String(reader, "VATNo", "");
debit.SupplierCode = GetReaderValue_String(reader, "SupplierCode", "");
}
return debit;
}
/// <summary>
/// Get
/// Calls [usp_select_Debit]
/// </summary>
public static Debit Get(System.Int32?debitId)
{
Rebound.GlobalTrader.DAL.DebitDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Debit.Get(debitId);
if (objDetails == null)
{
return(null);
}
else
{
Debit obj = new Debit();
obj.DebitId = objDetails.DebitId;
obj.DebitNumber = objDetails.DebitNumber;
obj.ClientNo = objDetails.ClientNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.ContactNo = objDetails.ContactNo;
obj.DebitDate = objDetails.DebitDate;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.RaisedBy = objDetails.RaisedBy;
obj.Buyer = objDetails.Buyer;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.Freight = objDetails.Freight;
obj.DivisionNo = objDetails.DivisionNo;
obj.TaxNo = objDetails.TaxNo;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.SupplierRMANo = objDetails.SupplierRMANo;
obj.ReferenceDate = objDetails.ReferenceDate;
obj.SupplierInvoice = objDetails.SupplierInvoice;
obj.SupplierRMA = objDetails.SupplierRMA;
obj.SupplierCredit = objDetails.SupplierCredit;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CompanyName = objDetails.CompanyName;
obj.ContactName = objDetails.ContactName;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.RaiserName = objDetails.RaiserName;
obj.BuyerName = objDetails.BuyerName;
obj.TeamNo = objDetails.TeamNo;
obj.DivisionName = objDetails.DivisionName;
obj.TaxName = objDetails.TaxName;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.PurchaseOrderDate = objDetails.PurchaseOrderDate;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.DebitValue = objDetails.DebitValue;
obj.TaxRate = objDetails.TaxRate;
//[001] code start
obj.IncotermsNo = objDetails.IncotermsNo;
obj.IncotermsName = objDetails.IncotermsName;
obj.InternalPurchaseOrderNo = objDetails.InternalPurchaseOrderNo;
obj.InternalPurchaseOrderNumber = objDetails.InternalPurchaseOrderNumber;
obj.POHubCompanyNo = objDetails.POHubCompanyNo;
obj.POHubCompanyName = objDetails.POHubCompanyName;
obj.RefNumber = objDetails.RefNumber;
//[001] code end
//[002] Start Here
obj.DebitParentId = objDetails.DebitParentId;
obj.ishublocked = objDetails.ishublocked;
//[001] End Here
objDetails = null;
return(obj);
}
}