/// <summary> /// Get /// Calls [usp_select_Excess] /// </summary> public static Excess Get(System.Int32?excessId, bool?isPoHub) { Rebound.GlobalTrader.DAL.ExcessDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Excess.Get(excessId, isPoHub); if (objDetails == null) { return(null); } else { Excess obj = new Excess(); obj.ExcessId = objDetails.ExcessId; obj.ExcessName = objDetails.ExcessName; obj.FullPart = objDetails.FullPart; obj.Part = objDetails.Part; obj.ManufacturerNo = objDetails.ManufacturerNo; obj.DateCode = objDetails.DateCode; obj.ProductNo = objDetails.ProductNo; obj.PackageNo = objDetails.PackageNo; obj.Quantity = objDetails.Quantity; obj.Price = objDetails.Price; obj.CurrencyNo = objDetails.CurrencyNo; obj.OriginalEntryDate = objDetails.OriginalEntryDate; obj.Salesman = objDetails.Salesman; obj.CompanyNo = objDetails.CompanyNo; obj.ROHS = objDetails.ROHS; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.OfferStatusNo = objDetails.OfferStatusNo; obj.OfferStatusChangeDate = objDetails.OfferStatusChangeDate; obj.OfferStatusChangeLoginNo = objDetails.OfferStatusChangeLoginNo; obj.Notes = objDetails.Notes; obj.ManufacturerName = objDetails.ManufacturerName; obj.ProductName = objDetails.ProductName; obj.PackageName = objDetails.PackageName; obj.CompanyName = objDetails.CompanyName; obj.SPQ = objDetails.SPQ; obj.LeadTime = objDetails.LeadTime; obj.RoHSStatus = objDetails.RoHSStatus; obj.FactorySealed = objDetails.FactorySealed; obj.MSL = objDetails.MSL; obj.SupplierMOQ = objDetails.SupplierMOQ; obj.SupplierTotalQSA = objDetails.SupplierTotalQSA; obj.SupplierLTB = objDetails.SupplierLTB; obj.ProductDescription = objDetails.ProductDescription; obj.ProductInactive = objDetails.ProductInactive; obj.MSLLevelNo = objDetails.MSLLevelNo; objDetails = null; return(obj); } }
private static Excess PopulateFromDBDetailsObject(ExcessDetails obj) { Excess objNew = new Excess(); objNew.ExcessId = obj.ExcessId; objNew.ExcessName = obj.ExcessName; objNew.FullPart = obj.FullPart; objNew.Part = obj.Part; objNew.ManufacturerNo = obj.ManufacturerNo; objNew.DateCode = obj.DateCode; objNew.ProductNo = obj.ProductNo; objNew.PackageNo = obj.PackageNo; objNew.Quantity = obj.Quantity; objNew.Price = obj.Price; objNew.CurrencyNo = obj.CurrencyNo; objNew.OriginalEntryDate = obj.OriginalEntryDate; objNew.Salesman = obj.Salesman; objNew.CompanyNo = obj.CompanyNo; objNew.ROHS = obj.ROHS; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.OfferStatusNo = obj.OfferStatusNo; objNew.OfferStatusChangeDate = obj.OfferStatusChangeDate; objNew.OfferStatusChangeLoginNo = obj.OfferStatusChangeLoginNo; objNew.CompanyName = obj.CompanyName; objNew.Notes = obj.Notes; objNew.ManufacturerName = obj.ManufacturerName; objNew.ProductName = obj.ProductName; objNew.PackageName = obj.PackageName; objNew.ClientNo = obj.ClientNo; objNew.SupplierName = obj.SupplierName; objNew.SupplierEmail = obj.SupplierEmail; objNew.ManufacturerCode = obj.ManufacturerCode; objNew.CurrencyCode = obj.CurrencyCode; objNew.SalesmanName = obj.SalesmanName; objNew.OfferStatusChangeEmployeeName = obj.OfferStatusChangeEmployeeName; objNew.ClientName = obj.ClientName; objNew.ClientDataVisibleToOthers = obj.ClientDataVisibleToOthers; return(objNew); }
/// <summary> /// Source /// Calls [usp_ipobom_source_Excess] /// </summary> public static List <Excess> IPOBOMSource(System.Int32?clientId, System.String partSearch, System.Int32?index, DateTime?maxDate, out DateTime?outDate, System.Boolean?blnReferesh, bool IsServerLocal, System.Boolean?isPohub) { DateTime?StartDate = null; DateTime?EndDate = null; if (index == 2 && maxDate.HasValue) { StartDate = (!blnReferesh.Value) ? maxDate.Value.AddMonths(-6) : maxDate.Value.AddMonths(-12); EndDate = maxDate.Value; } else if (index == 3 && maxDate.HasValue) { StartDate = DateTime.Parse("1900-01-01 00:00:00.000"); EndDate = maxDate.Value; } List <ExcessDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.Excess.IPOBOMSource(clientId, partSearch, index, StartDate, EndDate, out outDate, IsServerLocal, isPohub); if (lstDetails == null) { return(new List <Excess>()); } else { List <Excess> lst = new List <Excess>(); foreach (ExcessDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.Excess obj = new Rebound.GlobalTrader.BLL.Excess(); obj.ExcessId = objDetails.ExcessId; obj.ExcessName = objDetails.ExcessName; obj.FullPart = objDetails.FullPart; obj.Part = objDetails.Part; obj.ManufacturerNo = objDetails.ManufacturerNo; obj.DateCode = objDetails.DateCode; obj.ProductNo = objDetails.ProductNo; obj.PackageNo = objDetails.PackageNo; obj.Quantity = objDetails.Quantity; obj.Price = objDetails.Price; obj.CurrencyNo = objDetails.CurrencyNo; obj.OriginalEntryDate = objDetails.OriginalEntryDate; obj.Salesman = objDetails.Salesman; obj.CompanyNo = objDetails.CompanyNo; obj.ROHS = objDetails.ROHS; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.OfferStatusNo = objDetails.OfferStatusNo; obj.OfferStatusChangeDate = objDetails.OfferStatusChangeDate; obj.OfferStatusChangeLoginNo = objDetails.OfferStatusChangeLoginNo; obj.CompanyName = objDetails.CompanyName; obj.SupplierName = objDetails.SupplierName; obj.SupplierEmail = objDetails.SupplierEmail; obj.ManufacturerName = objDetails.ManufacturerName; obj.ManufacturerCode = objDetails.ManufacturerCode; obj.ProductName = objDetails.ProductName; obj.CurrencyCode = objDetails.CurrencyCode; obj.SalesmanName = objDetails.SalesmanName; obj.OfferStatusChangeEmployeeName = objDetails.OfferStatusChangeEmployeeName; obj.PackageName = objDetails.PackageName; obj.Notes = objDetails.Notes; obj.ClientNo = objDetails.ClientNo; obj.ClientName = objDetails.ClientName; obj.ClientDataVisibleToOthers = objDetails.ClientDataVisibleToOthers; //[001] code start obj.SupplierType = objDetails.SupplierType; //[001] code end obj.ClientCode = objDetails.ClientCode; obj.MSL = objDetails.MSL; obj.SPQ = objDetails.SPQ; obj.LeadTime = objDetails.LeadTime; obj.RoHSStatus = objDetails.RoHSStatus; obj.FactorySealed = objDetails.FactorySealed; // obj.IPOBOMNo = objDetails.IPOBOMNo; obj.SupplierTotalQSA = objDetails.SupplierTotalQSA; obj.SupplierLTB = objDetails.SupplierLTB; obj.SupplierMOQ = objDetails.SupplierMOQ; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }