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