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