// [001] code start
#endregion
/// <summary>
/// Returns a new GoodsInDetails instance filled with the DataReader's current record data
/// </summary>
protected virtual GoodsInDetails GetGoodsInFromReader(DbDataReader reader)
{
GoodsInDetails goodsIn = new GoodsInDetails();
if (reader.HasRows)
{
goodsIn.GoodsInId = GetReaderValue_Int32(reader, "GoodsInId", 0); //From: [Table]
goodsIn.GoodsInNumber = GetReaderValue_Int32(reader, "GoodsInNumber", 0); //From: [Table]
goodsIn.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table]
goodsIn.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null); //From: [Table]
goodsIn.AirWayBill = GetReaderValue_String(reader, "AirWayBill", ""); //From: [Table]
goodsIn.Reference = GetReaderValue_String(reader, "Reference", ""); //From: [Table]
goodsIn.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); //From: [Table]
goodsIn.ReceivingNotes = GetReaderValue_String(reader, "ReceivingNotes", ""); //From: [Table]
goodsIn.DateReceived = GetReaderValue_DateTime(reader, "DateReceived", DateTime.MinValue); //From: [Table]
goodsIn.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null); //From: [Table]
goodsIn.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null); //From: [Table]
goodsIn.ReceivedBy = GetReaderValue_Int32(reader, "ReceivedBy", 0); //From: [Table]
goodsIn.WarehouseNo = GetReaderValue_Int32(reader, "WarehouseNo", 0); //From: [Table]
goodsIn.CustomerRMANo = GetReaderValue_NullableInt32(reader, "CustomerRMANo", null); //From: [Table]
goodsIn.SupplierInvoice = GetReaderValue_String(reader, "SupplierInvoice", ""); //From: [Table]
goodsIn.InvoiceDate = GetReaderValue_NullableDateTime(reader, "InvoiceDate", null); //From: [Table]
goodsIn.InvoiceAmount = GetReaderValue_NullableDouble(reader, "InvoiceAmount", null); //From: [Table]
goodsIn.BankFee = GetReaderValue_NullableDouble(reader, "BankFee", null); //From: [Table]
goodsIn.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table]
goodsIn.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table]
goodsIn.GoodsValue = GetReaderValue_NullableDouble(reader, "GoodsValue", null); //From: [Table]
goodsIn.Tax = GetReaderValue_NullableDouble(reader, "Tax", null); //From: [Table]
goodsIn.DeliveryCharge = GetReaderValue_NullableDouble(reader, "DeliveryCharge", null); //From: [Table]
goodsIn.CreditCardFee = GetReaderValue_NullableDouble(reader, "CreditCardFee", null); //From: [Table]
goodsIn.CanBeExported = GetReaderValue_Boolean(reader, "CanBeExported", false); //From: [Table]
goodsIn.Exported = GetReaderValue_Boolean(reader, "Exported", false); //From: [Table]
goodsIn.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); //From: [usp_itemsearch_Debit]
goodsIn.PurchaseOrderNumber = GetReaderValue_NullableInt32(reader, "PurchaseOrderNumber", null); //From: [usp_itemsearch_Debit]
goodsIn.CustomerRMANumber = GetReaderValue_NullableInt32(reader, "CustomerRMANumber", null); //From: [usp_itemsearch_GoodsIn]
goodsIn.ReceiverName = GetReaderValue_String(reader, "ReceiverName", ""); //From: [usp_itemsearch_GoodsIn]
goodsIn.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null); //From: [usp_itemsearch_Debit]
goodsIn.WarehouseName = GetReaderValue_String(reader, "WarehouseName", ""); //From: [usp_select_GoodsIn]
goodsIn.GoodsInValue = GetReaderValue_NullableDouble(reader, "GoodsInValue", null); //From: [usp_select_GoodsIn]
goodsIn.DivisionNo = GetReaderValue_NullableInt32(reader, "DivisionNo", null); //From: [Table]
goodsIn.TeamNo = GetReaderValue_NullableInt32(reader, "TeamNo", null); //From: [usp_select_Debit]
goodsIn.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_select_Debit]
goodsIn.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_Debit]
goodsIn.ShipViaName = GetReaderValue_String(reader, "ShipViaName", ""); //From: [usp_select_GoodsIn]
goodsIn.StatusNo = GetReaderValue_NullableInt32(reader, "StatusNo", null); //From: [usp_select_GoodsIn]
goodsIn.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null); //From: [Table]
goodsIn.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null); //From: [usp_itemsearch_Debit]
goodsIn.DivisionName = GetReaderValue_String(reader, "DivisionName", ""); //From: [usp_select_Debit]
goodsIn.Buyer = GetReaderValue_Int32(reader, "Buyer", 0); //From: [Table]
goodsIn.BuyerName = GetReaderValue_String(reader, "BuyerName", ""); //From: [usp_select_Debit]
goodsIn.ReceivedByName = GetReaderValue_String(reader, "ReceivedByName", ""); //From: [usp_select_GoodsIn_as_ReceivedPO]
goodsIn.ContactNo = GetReaderValue_Int32(reader, "ContactNo", 0); //From: [Table]
goodsIn.ContactName = GetReaderValue_String(reader, "ContactName", ""); //From: [usp_itemsearch_Debit]
goodsIn.TotalShipInCost = GetReaderValue_NullableDouble(reader, "TotalShipInCost", null); //From: [usp_select_GoodsIn_as_ReceivedPO]
goodsIn.CompanyNameForSearch = GetReaderValue_String(reader, "CompanyNameForSearch", ""); //From: [usp_select_GoodsIn_for_Page]
goodsIn.SupplierTelephone = GetReaderValue_String(reader, "SupplierTelephone", ""); //From: [usp_select_GoodsIn_for_Print]
goodsIn.SupplierFax = GetReaderValue_String(reader, "SupplierFax", ""); //From: [usp_select_GoodsIn_for_Print]
}
return(goodsIn);
}
/// <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>
/// 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);
}
}
