/// <summary> /// Log History /// Calls [usp_GetLogHistory] /// </summary> public static List <PurchaseQuoteLine> GetLogHistory(System.Int32?ClientId) { List <POQuoteLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.POQuoteLine.GetLogHistory(ClientId); if (lstDetails == null) { return(new List <PurchaseQuoteLine>()); } else { List <PurchaseQuoteLine> lst = new List <PurchaseQuoteLine>(); foreach (POQuoteLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.PurchaseQuoteLine obj = new Rebound.GlobalTrader.BLL.PurchaseQuoteLine(); obj.Message = objDetails.Message; obj.FileName = objDetails.FileName; obj.Status = objDetails.Status; obj.LoginName = objDetails.LoginName; obj.PurchaseQuoteLineId = objDetails.PurchaseQuoteLineId; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
/// <summary> /// GetListClosedForQuote /// Calls [usp_selectAll_PurchaseRequestLine] /// </summary> public static List <PurchaseQuoteLine> GetListLines(System.Int32?poQuoteId) { List <POQuoteLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.POQuoteLine.GetListLines(poQuoteId); if (lstDetails == null) { return(new List <PurchaseQuoteLine>()); } else { List <PurchaseQuoteLine> lst = new List <PurchaseQuoteLine>(); foreach (POQuoteLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.PurchaseQuoteLine obj = new Rebound.GlobalTrader.BLL.PurchaseQuoteLine(); obj.PurchaseQuoteLineId = objDetails.PurchaseQuoteLineId; obj.PurchaseQuoteNo = objDetails.PurchaseQuoteNo; obj.CustomerRequirementNo = objDetails.CustomerRequirementNo; obj.BOMNo = objDetails.BOMNo; obj.FullPart = objDetails.FullPart; obj.Part = objDetails.Part; obj.Quantity = objDetails.Quantity; obj.TargetPrice = objDetails.TargetPrice; obj.LineNotes = objDetails.LineNotes; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; obj.CustomerRequirementNumber = objDetails.CustomerRequirementNumber; obj.BOMName = objDetails.BOMName; obj.BOMNo = objDetails.BOMNo; obj.Closed = objDetails.Closed; obj.UnitPrice = objDetails.UnitPrice; obj.PRCurrencyNo = objDetails.PRCurrencyNo; obj.PRCurencyCode = objDetails.PRCurencyCode; obj.ReqCurrencyNo = objDetails.ReqCurrencyNo; obj.ReqCurrencyCode = objDetails.ReqCurrencyCode; obj.ConvertedTargetValue = objDetails.ConvertedTargetValue; obj.PQStatus = objDetails.PQStatus; obj.PRStatus = objDetails.PRStatus; obj.IsImported = objDetails.PQStatus == (int)BLL.Enumerations.PurchaseQuoteStatus.List.Imported; obj.MSL = objDetails.MSL; obj.SPQ = objDetails.SPQ; obj.LeadTime = objDetails.LeadTime; obj.RoHSStatus = objDetails.RoHSStatus; obj.FactorySealed = objDetails.FactorySealed; obj.PHPrice = objDetails.PHPrice; obj.MSLR = objDetails.MSLR; obj.FactorySealedR = objDetails.FactorySealedR; obj.AS9120 = objDetails.AS9120; obj.IsGlobalCurrencySame = objDetails.IsGlobalCurrencySame; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
/// <summary> /// Csv Import Log /// Calls [usp_CsvUploadLog] /// </summary> public static List <PurchaseQuoteLine> GetUploadLog(System.Int32?LoginId) { List <POQuoteLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.POQuoteLine.GetUploadLog(LoginId); if (lstDetails == null) { return(new List <PurchaseQuoteLine>()); } else { List <PurchaseQuoteLine> lst = new List <PurchaseQuoteLine>(); foreach (POQuoteLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.PurchaseQuoteLine obj = new Rebound.GlobalTrader.BLL.PurchaseQuoteLine(); obj.Message = objDetails.Message; obj.DatePOQuoted = objDetails.DatePOQuoted; obj.PurchaseQuoteLineId = objDetails.PurchaseQuoteLineId; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
/// <summary> /// DataListNugget /// Calls [usp_datalistnugget_PurchaseRequetLine] /// </summary> public static List <PurchaseQuoteLine> DataListNugget(System.Int32?clientId, System.Int32?teamId, System.Int32?divisionId, System.Int32?loginId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String partSearch, System.String contactSearch, System.String cmSearch, System.Int32?salesmanSearch, System.Boolean?includeClosed, System.Int32?poQuoteNoLo, System.Int32?poQuoteNoHi, System.DateTime?dateQuotedFrom, System.DateTime?dateQuotedTo, System.Boolean?recentOnly) { List <POQuoteLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.POQuoteLine.DataListNugget(clientId, teamId, divisionId, loginId, orderBy, sortDir, pageIndex, pageSize, partSearch, contactSearch, cmSearch, salesmanSearch, includeClosed, poQuoteNoLo, poQuoteNoHi, dateQuotedFrom, dateQuotedTo, recentOnly); if (lstDetails == null) { return(new List <PurchaseQuoteLine>()); } else { List <PurchaseQuoteLine> lst = new List <PurchaseQuoteLine>(); foreach (POQuoteLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.PurchaseQuoteLine obj = new Rebound.GlobalTrader.BLL.PurchaseQuoteLine(); obj.PurchaseQuoteLineId = objDetails.PurchaseQuoteLineId; obj.PurchaseQuoteNumber = objDetails.PurchaseQuoteNumber; obj.PurchaseQuoteNo = objDetails.PurchaseQuoteNo; obj.Part = objDetails.Part; // obj.UnitPrice = objDetails.UnitPrice; // obj.CurrencyCode = objDetails.CurrencyCode; obj.Quantity = objDetails.Quantity; obj.CompanyName = objDetails.CompanyName; // obj.CompanyNo = objDetails.CompanyNo; obj.BOMName = objDetails.BOMName; obj.BOMNo = objDetails.BOMNo; obj.RowNum = objDetails.RowNum; obj.RowCnt = objDetails.RowCnt; obj.DatePOQuoted = objDetails.DatePOQuoted; obj.SalesmanName = objDetails.SalesmanName; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }
/// <summary> /// Source /// Calls [usp_source_PurchaseRequestLineDetails] /// </summary> public static List <PurchaseQuoteLine> Source(System.Int32?clientId, System.String partSearch, System.Int32?index, DateTime?maxDate, out DateTime?outDate, System.Boolean?blnReferesh, bool IsServerLocal) { 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 <POQuoteLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.POQuoteLine.Source(clientId, partSearch, index, StartDate, EndDate, out outDate, IsServerLocal); if (lstDetails == null) { return(new List <PurchaseQuoteLine>()); } else { List <PurchaseQuoteLine> lst = new List <PurchaseQuoteLine>(); foreach (POQuoteLineDetails objDetails in lstDetails) { Rebound.GlobalTrader.BLL.PurchaseQuoteLine obj = new Rebound.GlobalTrader.BLL.PurchaseQuoteLine(); obj.PurchaseQuoteLineId = objDetails.PurchaseQuoteLineId; obj.PurchaseQuoteNo = objDetails.PurchaseQuoteNo; obj.PurchaseQuoteNumber = objDetails.PurchaseQuoteNumber; obj.Quantity = objDetails.Quantity; obj.Part = objDetails.Part; //obj.ROHS = objDetails.ROHS; //obj.ManufacturerNo = objDetails.ManufacturerNo; // obj.ManufacturerCode = objDetails.ManufacturerCode; obj.CompanyNo = objDetails.CompanyNo; obj.CompanyName = objDetails.CompanyName; //obj.DateCode = objDetails.DateCode; obj.DatePOQuoted = objDetails.DatePOQuoted; obj.UnitPrice = objDetails.UnitPrice; obj.CurrencyCode = objDetails.CurrencyCode; //obj.PackageName = objDetails.PackageName; //obj.ProductName = objDetails.ProductName; //obj.CustomerPart = objDetails.CustomerPart; obj.ClientNo = objDetails.ClientNo; obj.ClientName = objDetails.ClientName; //obj.ClientDataVisibleToOthers = objDetails.ClientDataVisibleToOthers; obj.Salesman = objDetails.Salesman; obj.SalesmanName = objDetails.SalesmanName; obj.MSL = objDetails.MSL; obj.SPQ = objDetails.SPQ; obj.LeadTime = objDetails.LeadTime; obj.RoHSStatus = objDetails.RoHSStatus; obj.FactorySealed = objDetails.FactorySealed; obj.SupplierType = objDetails.SupplierType; obj.PurchaseRequestLineDetailId = objDetails.PurchaseRequestLineDetailId; lst.Add(obj); obj = null; } lstDetails = null; return(lst); } }