public List <DTO.PriceComparison.ProductOptionDetailDTO> GetComparableItemData(System.Collections.Hashtable filters, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
List <DTO.PriceComparison.ProductOptionDetailDTO> result = new List <DTO.PriceComparison.ProductOptionDetailDTO>();
//try to get data
try
{
using (ProductOverviewRptEntities context = CreateContext())
{
string Season = null;
int? FactoryID = null;
int? QuotationStatusID = null;
int? ModelID = null;
int? FactoryOrderDetailID = null;
int? MaterialID = null;
int? MaterialTypeID = null;
int? MaterialColorID = null;
int? FrameMaterialID = null;
int? FrameMaterialColorID = null;
int? SubMaterialID = null;
int? SubMaterialColorID = null;
int? BackCushionID = null;
int? SeatCushionID = null;
int? CushionColorID = null;
int? FSCTypeID = null;
int? FSCPercentID = null;
bool? UseFSCLabel = null;
int? PackagingMethodID = null;
int? ClientSpecialPackagingMethodID = null;
if (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString()))
{
Season = filters["Season"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("FactoryID") && filters["FactoryID"] != null && !string.IsNullOrEmpty(filters["FactoryID"].ToString()))
{
FactoryID = Convert.ToInt32(filters["FactoryID"].ToString());
}
if (filters.ContainsKey("QuotationStatusID") && filters["QuotationStatusID"] != null && !string.IsNullOrEmpty(filters["QuotationStatusID"].ToString()))
{
QuotationStatusID = Convert.ToInt32(filters["QuotationStatusID"].ToString());
}
if (filters.ContainsKey("ModelID") && filters["ModelID"] != null && !string.IsNullOrEmpty(filters["ModelID"].ToString()))
{
ModelID = Convert.ToInt32(filters["ModelID"].ToString());
}
if (filters.ContainsKey("FactoryOrderDetailID") && filters["FactoryOrderDetailID"] != null && !string.IsNullOrEmpty(filters["FactoryOrderDetailID"].ToString()))
{
FactoryOrderDetailID = Convert.ToInt32(filters["FactoryOrderDetailID"].ToString());
}
if (filters.ContainsKey("MaterialID") && filters["MaterialID"] != null && !string.IsNullOrEmpty(filters["MaterialID"].ToString()))
{
MaterialID = Convert.ToInt32(filters["MaterialID"].ToString());
}
if (filters.ContainsKey("MaterialTypeID") && filters["MaterialTypeID"] != null && !string.IsNullOrEmpty(filters["MaterialTypeID"].ToString()))
{
MaterialTypeID = Convert.ToInt32(filters["MaterialTypeID"].ToString());
}
if (filters.ContainsKey("MaterialColorID") && filters["MaterialColorID"] != null && !string.IsNullOrEmpty(filters["MaterialColorID"].ToString()))
{
MaterialColorID = Convert.ToInt32(filters["MaterialColorID"].ToString());
}
if (filters.ContainsKey("FrameMaterialID") && filters["FrameMaterialID"] != null && !string.IsNullOrEmpty(filters["FrameMaterialID"].ToString()))
{
FrameMaterialID = Convert.ToInt32(filters["FrameMaterialID"].ToString());
}
if (filters.ContainsKey("FrameMaterialColorID") && filters["FrameMaterialColorID"] != null && !string.IsNullOrEmpty(filters["FrameMaterialColorID"].ToString()))
{
FrameMaterialColorID = Convert.ToInt32(filters["FrameMaterialColorID"].ToString());
}
if (filters.ContainsKey("SubMaterialID") && filters["SubMaterialID"] != null && !string.IsNullOrEmpty(filters["SubMaterialID"].ToString()))
{
SubMaterialID = Convert.ToInt32(filters["SubMaterialID"].ToString());
}
if (filters.ContainsKey("SubMaterialColorID") && filters["SubMaterialColorID"] != null && !string.IsNullOrEmpty(filters["SubMaterialColorID"].ToString()))
{
SubMaterialColorID = Convert.ToInt32(filters["SubMaterialColorID"].ToString());
}
if (filters.ContainsKey("BackCushionID") && filters["BackCushionID"] != null && !string.IsNullOrEmpty(filters["BackCushionID"].ToString()))
{
BackCushionID = Convert.ToInt32(filters["BackCushionID"].ToString());
}
if (filters.ContainsKey("SeatCushionID") && filters["SeatCushionID"] != null && !string.IsNullOrEmpty(filters["SeatCushionID"].ToString()))
{
SeatCushionID = Convert.ToInt32(filters["SeatCushionID"].ToString());
}
if (filters.ContainsKey("CushionColorID") && filters["CushionColorID"] != null && !string.IsNullOrEmpty(filters["CushionColorID"].ToString()))
{
CushionColorID = Convert.ToInt32(filters["CushionColorID"].ToString());
}
if (filters.ContainsKey("FSCTypeID") && filters["FSCTypeID"] != null && !string.IsNullOrEmpty(filters["FSCTypeID"].ToString()))
{
FSCTypeID = Convert.ToInt32(filters["FSCTypeID"].ToString());
}
if (filters.ContainsKey("FSCPercentID") && filters["FSCPercentID"] != null && !string.IsNullOrEmpty(filters["FSCPercentID"].ToString()))
{
FSCPercentID = Convert.ToInt32(filters["FSCPercentID"].ToString());
}
if (filters.ContainsKey("UseFSCLabel") && filters["UseFSCLabel"] != null && !string.IsNullOrEmpty(filters["UseFSCLabel"].ToString()))
{
UseFSCLabel = Convert.ToBoolean(filters["UseFSCLabel"].ToString());
}
if (filters.ContainsKey("PackagingMethodID") && filters["PackagingMethodID"] != null && !string.IsNullOrEmpty(filters["PackagingMethodID"].ToString()))
{
PackagingMethodID = Convert.ToInt32(filters["PackagingMethodID"].ToString());
}
if (filters.ContainsKey("ClientSpecialPackagingMethodID") && filters["ClientSpecialPackagingMethodID"] != null && !string.IsNullOrEmpty(filters["ClientSpecialPackagingMethodID"].ToString()))
{
ClientSpecialPackagingMethodID = Convert.ToInt32(filters["ClientSpecialPackagingMethodID"].ToString());
}
result = converter.DB2DTO_PriceComparison_ProductOptionDetailList(
context.ProductOverviewRpt_function_SearchComparableItem(
Season
, FactoryID
, QuotationStatusID
, ModelID
, FactoryOrderDetailID
, MaterialID
, MaterialTypeID
, MaterialColorID
, FrameMaterialID
, FrameMaterialColorID
, SubMaterialID
, SubMaterialColorID
, BackCushionID
, SeatCushionID
, CushionColorID
, FSCTypeID
, FSCPercentID
, UseFSCLabel
, PackagingMethodID
, ClientSpecialPackagingMethodID
).ToList());
}
}
catch (Exception ex)
{
ex = Library.Helper.GetInnerException(ex);
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(result);
}
