//[002] code end /// <summary> /// ItemSearch /// Calls [usp_itemsearch_GoodsIn] /// </summary> public static List <GoodsIn> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String airWayBillSearch, System.String cmSearch, System.Int32?receivedBySearch, System.Boolean?includeInvoiced, System.Int32?purchaseOrderNoLo, System.Int32?purchaseOrderNoHi, System.Int32?customerRmaNoLo, System.Int32?customerRmaNoHi, System.Int32?goodsInNoLo, System.Int32?goodsInNoHi, System.DateTime?dateReceivedFrom, System.DateTime?dateReceivedTo, System.Boolean IsGlobal) { List <GoodsInDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.GoodsIn.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, airWayBillSearch, cmSearch, receivedBySearch, includeInvoiced, purchaseOrderNoLo, purchaseOrderNoHi, customerRmaNoLo, customerRmaNoHi, goodsInNoLo, goodsInNoHi, dateReceivedFrom, dateReceivedTo, IsGlobal); if (lstDetails == null) { return(new List <GoodsIn>()); } else { List <GoodsIn> lst = new List <GoodsIn>(); foreach (GoodsInDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.GoodsIn obj = new Rebound.GlobalTrader.BLL.GoodsIn(); obj.GoodsInId = objDetails.GoodsInId; obj.GoodsInNumber = objDetails.GoodsInNumber; obj.CompanyNo = objDetails.CompanyNo; obj.CompanyName = objDetails.CompanyName; obj.DateReceived = objDetails.DateReceived; obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber; obj.CustomerRMANumber = objDetails.CustomerRMANumber; obj.AirWayBill = objDetails.AirWayBill; obj.ReceiverName = objDetails.ReceiverName; obj.Reference = objDetails.Reference; obj.RowNum = objDetails.RowNum; obj.RowCnt = objDetails.RowCnt; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
private static GoodsIn PopulateFromDBDetailsObject(GoodsInDetails obj) { GoodsIn objNew = new GoodsIn(); objNew.GoodsInId = obj.GoodsInId; objNew.GoodsInNumber = obj.GoodsInNumber; objNew.ClientNo = obj.ClientNo; objNew.ShipViaNo = obj.ShipViaNo; objNew.AirWayBill = obj.AirWayBill; objNew.Reference = obj.Reference; objNew.CompanyNo = obj.CompanyNo; objNew.ReceivingNotes = obj.ReceivingNotes; objNew.DateReceived = obj.DateReceived; objNew.PurchaseOrderNo = obj.PurchaseOrderNo; objNew.CurrencyNo = obj.CurrencyNo; objNew.ReceivedBy = obj.ReceivedBy; objNew.WarehouseNo = obj.WarehouseNo; objNew.CustomerRMANo = obj.CustomerRMANo; objNew.SupplierInvoice = obj.SupplierInvoice; objNew.InvoiceDate = obj.InvoiceDate; objNew.InvoiceAmount = obj.InvoiceAmount; objNew.BankFee = obj.BankFee; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.GoodsValue = obj.GoodsValue; objNew.Tax = obj.Tax; objNew.DeliveryCharge = obj.DeliveryCharge; objNew.CreditCardFee = obj.CreditCardFee; objNew.CanBeExported = obj.CanBeExported; objNew.Exported = obj.Exported; objNew.CompanyName = obj.CompanyName; objNew.PurchaseOrderNumber = obj.PurchaseOrderNumber; objNew.CustomerRMANumber = obj.CustomerRMANumber; objNew.ReceiverName = obj.ReceiverName; objNew.RowNum = obj.RowNum; objNew.RowCnt = obj.RowCnt; objNew.WarehouseName = obj.WarehouseName; objNew.GoodsInValue = obj.GoodsInValue; objNew.DivisionNo = obj.DivisionNo; objNew.TeamNo = obj.TeamNo; objNew.CurrencyCode = obj.CurrencyCode; objNew.CurrencyDescription = obj.CurrencyDescription; objNew.ShipViaName = obj.ShipViaName; objNew.StatusNo = obj.StatusNo; objNew.SupplierRMANo = obj.SupplierRMANo; objNew.SupplierRMANumber = obj.SupplierRMANumber; objNew.DivisionName = obj.DivisionName; objNew.Buyer = obj.Buyer; objNew.BuyerName = obj.BuyerName; objNew.ReceivedByName = obj.ReceivedByName; objNew.ContactNo = obj.ContactNo; objNew.ContactName = obj.ContactName; objNew.TotalShipInCost = obj.TotalShipInCost; objNew.CompanyNameForSearch = obj.CompanyNameForSearch; objNew.SupplierTelephone = obj.SupplierTelephone; objNew.SupplierFax = obj.SupplierFax; return(objNew); }
/// <summary> /// GetForPrint /// Calls [usp_select_GoodsIn_for_Print] /// </summary> public static GoodsIn GetForPrint(System.Int32?goodsInId) { Rebound.GlobalTrader.DAL.GoodsInDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.GoodsIn.GetForPrint(goodsInId); if (objDetails == null) { return(null); } else { GoodsIn obj = new GoodsIn(); obj.GoodsInId = objDetails.GoodsInId; obj.GoodsInNumber = objDetails.GoodsInNumber; obj.ClientNo = objDetails.ClientNo; obj.ShipViaNo = objDetails.ShipViaNo; obj.AirWayBill = objDetails.AirWayBill; obj.Reference = objDetails.Reference; obj.CompanyNo = objDetails.CompanyNo; obj.ReceivingNotes = objDetails.ReceivingNotes; obj.DateReceived = objDetails.DateReceived; obj.PurchaseOrderNo = objDetails.PurchaseOrderNo; obj.CurrencyNo = objDetails.CurrencyNo; obj.ReceivedBy = objDetails.ReceivedBy; obj.WarehouseNo = objDetails.WarehouseNo; obj.CustomerRMANo = objDetails.CustomerRMANo; obj.SupplierInvoice = objDetails.SupplierInvoice; obj.InvoiceDate = objDetails.InvoiceDate; obj.InvoiceAmount = objDetails.InvoiceAmount; obj.GoodsValue = objDetails.GoodsValue; obj.Tax = objDetails.Tax; obj.BankFee = objDetails.BankFee; obj.DeliveryCharge = objDetails.DeliveryCharge; obj.CreditCardFee = objDetails.CreditCardFee; obj.CanBeExported = objDetails.CanBeExported; obj.Exported = objDetails.Exported; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.CompanyName = objDetails.CompanyName; obj.ReceiverName = objDetails.ReceiverName; obj.WarehouseName = objDetails.WarehouseName; obj.GoodsInValue = objDetails.GoodsInValue; obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber; obj.DivisionNo = objDetails.DivisionNo; obj.TeamNo = objDetails.TeamNo; obj.CurrencyCode = objDetails.CurrencyCode; obj.CurrencyDescription = objDetails.CurrencyDescription; obj.CustomerRMANumber = objDetails.CustomerRMANumber; obj.ShipViaName = objDetails.ShipViaName; obj.StatusNo = objDetails.StatusNo; obj.SupplierRMANo = objDetails.SupplierRMANo; obj.SupplierRMANumber = objDetails.SupplierRMANumber; obj.DivisionName = objDetails.DivisionName; obj.ShipViaName = objDetails.ShipViaName; obj.SupplierTelephone = objDetails.SupplierTelephone; obj.SupplierFax = objDetails.SupplierFax; objDetails = null; return(obj); } }
/// <summary> /// GetNextNumber /// Calls [usp_select_GoodsIn_NextNumber] /// </summary> public static GoodsIn GetNextNumber(System.Int32?clientNo, System.Int32?updatedBy) { Rebound.GlobalTrader.DAL.GoodsInDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.GoodsIn.GetNextNumber(clientNo, updatedBy); if (objDetails == null) { return(null); } else { GoodsIn obj = new GoodsIn(); obj.GoodsInNumber = objDetails.GoodsInNumber; objDetails = null; return(obj); } }
/// <summary> /// GetIDByNumber /// Calls [usp_select_GoodsIn_ID_by_Number] /// </summary> public static List <GoodsIn> GetIDByNumber(System.Int32?goodsInNumber, System.Int32?clientNo, System.Int32?isGlobalUser) { //[005] start List <Rebound.GlobalTrader.DAL.GoodsInDetails> objDetails = Rebound.GlobalTrader.DAL.SiteProvider.GoodsIn.GetIDByNumber(goodsInNumber, clientNo, isGlobalUser); List <GoodsIn> lstGoodsIn = new List <GoodsIn>(); foreach (GoodsInDetails gi in objDetails) { GoodsIn objGI = new GoodsIn(); objGI.GoodsInId = gi.GoodsInId; objGI.GoodsInNumberDetail = gi.GoodsInNumberDetail; lstGoodsIn.Add(objGI); } return(lstGoodsIn); //[005] end }
/// <summary> /// GetForPage /// Calls [usp_select_GoodsIn_for_Page] /// </summary> public static GoodsIn GetForPage(System.Int32?goodsInId) { Rebound.GlobalTrader.DAL.GoodsInDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.GoodsIn.GetForPage(goodsInId); if (objDetails == null) { return(null); } else { GoodsIn obj = new GoodsIn(); obj.GoodsInId = objDetails.GoodsInId; obj.GoodsInNumber = objDetails.GoodsInNumber; obj.ClientNo = objDetails.ClientNo; obj.CompanyName = objDetails.CompanyName; obj.CompanyNameForSearch = objDetails.CompanyNameForSearch; obj.StatusNo = objDetails.StatusNo; // [001] code start obj.IsPDFAvailable = objDetails.IsPDFAvailable; // [001] code end //[003] code start obj.CompanyNo = objDetails.CompanyNo; obj.PurchaseOrderNo = objDetails.PurchaseOrderNo; obj.TaxNo = objDetails.TaxNo; obj.GlobalCurrencyNo = objDetails.GlobalCurrencyNo; obj.CurrencyCode = objDetails.CurrencyCode; //[003] code end obj.IPOSupplier = objDetails.IPOSupplier; obj.IPOSupplierName = objDetails.IPOSupplierName; obj.InternalPurchaseOrderId = objDetails.InternalPurchaseOrderId; obj.InternalPurchaseOrderNo = objDetails.InternalPurchaseOrderNo; obj.POClientNo = objDetails.POClientNo; obj.ClientName = objDetails.ClientName; obj.ClientBaseCurrencyCode = objDetails.ClientBaseCurrencyCode; obj.ClientBaseCurrencyID = objDetails.ClientBaseCurrencyID; objDetails = null; return(obj); } }
/// <summary> /// GetAsReceivedPO /// Calls [usp_select_GoodsIn_as_ReceivedPO] /// </summary> public static GoodsIn GetAsReceivedPO(System.Int32?purchaseOrderNo) { Rebound.GlobalTrader.DAL.GoodsInDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.GoodsIn.GetAsReceivedPO(purchaseOrderNo); if (objDetails == null) { return(null); } else { GoodsIn obj = new GoodsIn(); obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber; obj.Buyer = objDetails.Buyer; obj.BuyerName = objDetails.BuyerName; obj.WarehouseNo = objDetails.WarehouseNo; obj.WarehouseName = objDetails.WarehouseName; obj.ReceivedBy = objDetails.ReceivedBy; obj.ReceivedByName = objDetails.ReceivedByName; obj.CompanyNo = objDetails.CompanyNo; obj.CompanyName = objDetails.CompanyName; obj.ContactNo = objDetails.ContactNo; obj.ContactName = objDetails.ContactName; obj.AirWayBill = objDetails.AirWayBill; obj.Reference = objDetails.Reference; obj.TotalShipInCost = objDetails.TotalShipInCost; obj.ReceivingNotes = objDetails.ReceivingNotes; obj.SupplierInvoice = objDetails.SupplierInvoice; obj.InvoiceAmount = objDetails.InvoiceAmount; obj.BankFee = objDetails.BankFee; obj.InvoiceDate = objDetails.InvoiceDate; obj.CurrencyNo = objDetails.CurrencyNo; obj.CurrencyCode = objDetails.CurrencyCode; obj.CurrencyDescription = objDetails.CurrencyDescription; obj.DLUP = objDetails.DLUP; obj.UpdatedBy = objDetails.UpdatedBy; objDetails = null; return(obj); } }
/// <summary> /// Get /// Calls [usp_select_GoodsIn] /// </summary> public static GoodsIn Get(System.Int32?goodsInId, bool?isHub) { Rebound.GlobalTrader.DAL.GoodsInDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.GoodsIn.Get(goodsInId, isHub); if (objDetails == null) { return(null); } else { GoodsIn obj = new GoodsIn(); obj.GoodsInId = objDetails.GoodsInId; obj.GoodsInNumber = objDetails.GoodsInNumber; obj.ClientNo = objDetails.ClientNo; obj.ShipViaNo = objDetails.ShipViaNo; obj.AirWayBill = objDetails.AirWayBill; obj.Reference = objDetails.Reference; obj.CompanyNo = objDetails.CompanyNo; obj.ReceivingNotes = objDetails.ReceivingNotes; obj.DateReceived = objDetails.DateReceived; obj.PurchaseOrderNo = objDetails.PurchaseOrderNo; obj.CurrencyNo = objDetails.CurrencyNo; obj.ReceivedBy = objDetails.ReceivedBy; obj.WarehouseNo = objDetails.WarehouseNo; obj.CustomerRMANo = objDetails.CustomerRMANo; obj.SupplierInvoice = objDetails.SupplierInvoice; obj.InvoiceDate = objDetails.InvoiceDate; obj.InvoiceAmount = objDetails.InvoiceAmount; obj.GoodsValue = objDetails.GoodsValue; obj.Tax = objDetails.Tax; obj.BankFee = objDetails.BankFee; obj.DeliveryCharge = objDetails.DeliveryCharge; obj.CreditCardFee = objDetails.CreditCardFee; obj.CanBeExported = objDetails.CanBeExported; obj.Exported = objDetails.Exported; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.CompanyName = objDetails.InternalPurchaseOrderId > 0 && isHub == false ? objDetails.IPOSupplierName : objDetails.CompanyName; obj.ReceiverName = objDetails.ReceiverName; //--------------------------- obj.BuyerName = objDetails.BuyerName; //--------------------------------- obj.WarehouseName = objDetails.WarehouseName; obj.GoodsInValue = objDetails.GoodsInValue; obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber; obj.DivisionNo = objDetails.DivisionNo; obj.TeamNo = objDetails.TeamNo; obj.CurrencyCode = objDetails.CurrencyCode; obj.CurrencyDescription = objDetails.CurrencyDescription; obj.CustomerRMANumber = objDetails.CustomerRMANumber; obj.ShipViaName = objDetails.ShipViaName; obj.StatusNo = objDetails.StatusNo; obj.SupplierRMANo = objDetails.SupplierRMANo; obj.SupplierRMANumber = objDetails.SupplierRMANumber; obj.DivisionName = objDetails.DivisionName; //[002] code start obj.PurchaseCountryNo = objDetails.PurchaseCountryNo; obj.PurchaseCountryName = objDetails.PurchaseCountryName; //[002] code end obj.SupplierType = objDetails.SupplierType; //[003] code start obj.SupplierInvoiceNos = objDetails.SupplierInvoiceNos; obj.SupplierInvoiceNumbers = objDetails.SupplierInvoiceNumbers; obj.IPOSupplier = objDetails.IPOSupplier; obj.IPOSupplierName = objDetails.IPOSupplierName; obj.InternalPurchaseOrderId = objDetails.InternalPurchaseOrderId; obj.InternalPurchaseOrderNo = objDetails.InternalPurchaseOrderNo; obj.GoodsInValueForClient = objDetails.GoodsInValueForClient; obj.POClientNo = objDetails.POClientNo; obj.ClientCurrencyCode = objDetails.ClientCurrencyCode; obj.ClientCurrencyNo = objDetails.ClientCurrencyNo; //[003] code end objDetails = null; return(obj); } }