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