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