/// <summary>
/// GetForPage
/// Calls [usp_select_SupplierRMA_for_Page]
/// </summary>
public static SupplierRma GetForPage(System.Int32?supplierRmaId)
{
Rebound.GlobalTrader.DAL.SupplierRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetForPage(supplierRmaId);
if (objDetails == null)
{
return(null);
}
else
{
SupplierRma obj = new SupplierRma();
obj.SupplierRMAId = objDetails.SupplierRMAId;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.ClientNo = objDetails.ClientNo;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
// [001] code start
obj.IsPDFAvailable = objDetails.IsPDFAvailable;
// [001] code end
obj.TeamNo = objDetails.TeamNo;
obj.DivisionNo = objDetails.DivisionNo;
obj.Buyer = objDetails.Buyer;
obj.IPOCompanyNo = objDetails.IPOCompanyNo;
obj.IPOCompanyName = objDetails.IPOCompanyName;
obj.InternalPurchaseOrderId = objDetails.InternalPurchaseOrderId;
obj.ClientName = objDetails.ClientName;
objDetails = null;
return(obj);
}
}
/// <summary>
/// GetForPrint
/// Calls [usp_select_SupplierRMA_for_Print]
/// </summary>
public static SupplierRma GetForPrint(System.Int32?supplierRmaId, bool IsHUBsupplierRmaId)
{
Rebound.GlobalTrader.DAL.SupplierRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetForPrint(supplierRmaId, IsHUBsupplierRmaId);
if (objDetails == null)
{
return(null);
}
else
{
SupplierRma obj = new SupplierRma();
obj.SupplierRMAId = objDetails.SupplierRMAId;
obj.ClientNo = objDetails.ClientNo;
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
obj.PurchaseOrderNo = objDetails.PurchaseOrderNo;
obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
obj.AuthorisedBy = objDetails.AuthorisedBy;
obj.AuthoriserName = objDetails.AuthoriserName;
obj.SupplierRMADate = objDetails.SupplierRMADate;
obj.Notes = objDetails.Notes;
obj.Instructions = objDetails.Instructions;
obj.ShipViaNo = objDetails.ShipViaNo;
obj.ShipViaName = objDetails.ShipViaName;
obj.Account = objDetails.Account;
obj.ShipToAddressNo = objDetails.ShipToAddressNo;
obj.Reference = objDetails.Reference;
obj.CompanyNo = objDetails.CompanyNo;
obj.CompanyName = objDetails.CompanyName;
obj.FullCompanyName = objDetails.FullCompanyName;
obj.ContactNo = objDetails.ContactNo;
obj.ContactName = objDetails.ContactName;
obj.DivisionNo = objDetails.DivisionNo;
obj.DivisionName = objDetails.DivisionName;
obj.UpdatedBy = objDetails.UpdatedBy;
obj.DLUP = objDetails.DLUP;
obj.CurrencyNo = objDetails.CurrencyNo;
obj.CurrencyCode = objDetails.CurrencyCode;
obj.CurrencyDescription = objDetails.CurrencyDescription;
obj.TeamNo = objDetails.TeamNo;
obj.CustomerCode = objDetails.CustomerCode;
obj.TaxNo = objDetails.TaxNo;
obj.TaxName = objDetails.TaxName;
obj.Buyer = objDetails.Buyer;
obj.Quantity = objDetails.Quantity;
obj.QuantityShipped = objDetails.QuantityShipped;
obj.IncotermNo = objDetails.IncotermNo;
obj.IncotermName = objDetails.IncotermName;
obj.CompanyTelephone = objDetails.CompanyTelephone;
obj.CompanyFax = objDetails.CompanyFax;
obj.TermsName = objDetails.TermsName;
obj.ShipViaName = objDetails.ShipViaName;
obj.ContactEmail = objDetails.ContactEmail;
obj.IncotermName = objDetails.IncotermName;
obj.POHubCompanyNo = objDetails.POHubCompanyNo;
obj.POHubCompanyName = objDetails.POHubCompanyName;
obj.ClientRefNo = objDetails.ClientRefNo;
obj.HubShipToAddressNo = objDetails.HubShipToAddressNo;
objDetails = null;
return(obj);
}
}
//[003] end
#endregion
/// <summary>
/// Returns a new SupplierRmaDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual SupplierRmaDetails GetSupplierRmaFromReader(DbDataReader reader)
{
SupplierRmaDetails supplierRma = new SupplierRmaDetails();
if (reader.HasRows)
{
supplierRma.SupplierRMAId = GetReaderValue_Int32(reader, "SupplierRMAId", 0); //From: [Table]
supplierRma.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table]
supplierRma.SupplierRMANumber = GetReaderValue_Int32(reader, "SupplierRMANumber", 0); //From: [usp_selectAll_SalesOrder_shipped_recently_for_Login]
supplierRma.PurchaseOrderNo = GetReaderValue_Int32(reader, "PurchaseOrderNo", 0); //From: [Table]
supplierRma.AuthorisedBy = GetReaderValue_Int32(reader, "AuthorisedBy", 0); //From: [Table]
supplierRma.SupplierRMADate = GetReaderValue_DateTime(reader, "SupplierRMADate", DateTime.MinValue); //From: [Table]
supplierRma.Notes = GetReaderValue_String(reader, "Notes", ""); //From: [Table]
supplierRma.Instructions = GetReaderValue_String(reader, "Instructions", ""); //From: [Table]
supplierRma.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null); //From: [Table]
supplierRma.Account = GetReaderValue_String(reader, "Account", ""); //From: [Table]
supplierRma.ShipToAddressNo = GetReaderValue_Int32(reader, "ShipToAddressNo", 0); //From: [Table]
supplierRma.Reference = GetReaderValue_String(reader, "Reference", ""); //From: [Table]
supplierRma.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table]
supplierRma.ContactNo = GetReaderValue_NullableInt32(reader, "ContactNo", null); //From: [Table]
supplierRma.DivisionNo = GetReaderValue_Int32(reader, "DivisionNo", 0); //From: [Table]
supplierRma.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
supplierRma.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
supplierRma.IncotermNo = GetReaderValue_NullableInt32(reader, "IncotermNo", null); //From: [Table]
supplierRma.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_itemsearch_PurchaseOrder]
supplierRma.BuyerName = GetReaderValue_String(reader, "BuyerName", ""); //From: [usp_itemsearch_PurchaseOrder]
supplierRma.PurchaseOrderNumber = GetReaderValue_Int32(reader, "PurchaseOrderNumber", 0); //From: [Table]
supplierRma.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); //From: [usp_itemsearch_PurchaseOrder]
supplierRma.AuthoriserName = GetReaderValue_String(reader, "AuthoriserName", ""); //From: [usp_select_SupplierRMA]
supplierRma.ShipViaName = GetReaderValue_String(reader, "ShipViaName", ""); //From: [usp_select_PurchaseOrder]
supplierRma.FullCompanyName = GetReaderValue_String(reader, "FullCompanyName", ""); //From: [usp_selectAll_SalesOrder_shipped_recently_for_Login]
supplierRma.ContactName = GetReaderValue_String(reader, "ContactName", ""); //From: [usp_itemsearch_PurchaseOrder]
supplierRma.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); //From: [usp_select_PurchaseOrder]
supplierRma.CurrencyNo = GetReaderValue_Int32(reader, "CurrencyNo", 0); //From: [Table]
supplierRma.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_select_PurchaseOrder]
supplierRma.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_PurchaseOrder]
supplierRma.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null); //From: [usp_select_SalesOrder]
supplierRma.CustomerCode = GetReaderValue_String(reader, "CustomerCode", ""); //From: [usp_select_SalesOrder]
supplierRma.TaxNo = GetReaderValue_Int32(reader, "TaxNo", 0); //From: [Table]
supplierRma.TaxName = GetReaderValue_String(reader, "TaxName", ""); //From: [usp_select_PurchaseOrder]
supplierRma.Buyer = GetReaderValue_Int32(reader, "Buyer", 0); //From: [Table]
supplierRma.Quantity = GetReaderValue_NullableInt32(reader, "Quantity", null); //From: [usp_selectAll_SalesOrder_open_for_Login]
supplierRma.QuantityShipped = GetReaderValue_NullableInt32(reader, "QuantityShipped", null); //From: [usp_select_SupplierRMA]
supplierRma.IncotermName = GetReaderValue_String(reader, "IncotermName", ""); //From: [usp_select_PurchaseOrder]
supplierRma.CompanyTelephone = GetReaderValue_String(reader, "CompanyTelephone", ""); //From: [usp_select_PurchaseOrder_for_Print]
supplierRma.CompanyFax = GetReaderValue_String(reader, "CompanyFax", ""); //From: [usp_select_PurchaseOrder_for_Print]
supplierRma.TermsName = GetReaderValue_String(reader, "TermsName", ""); //From: [usp_select_PurchaseOrder]
supplierRma.ContactEmail = GetReaderValue_String(reader, "ContactEmail", ""); //From: [usp_select_PurchaseOrder_for_Print]
}
return(supplierRma);
}
/// <summary>
/// GetNextNumber
/// Calls [usp_select_SupplierRMA_NextNumber]
/// </summary>
public static SupplierRma GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy)
{
Rebound.GlobalTrader.DAL.SupplierRmaDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierRma.GetNextNumber(clientNo, updatedBy);
if (objDetails == null)
{
return(null);
}
else
{
SupplierRma obj = new SupplierRma();
obj.SupplierRMANumber = objDetails.SupplierRMANumber;
objDetails = null;
return(obj);
}
}
