public List <DTO.PriceComparison.PriceOfferHistoryDTO> GetPriceOfferHistory(int id, out Library.DTO.Notification notification) // FactotyOrderDetailID
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
List <DTO.PriceComparison.PriceOfferHistoryDTO> result = new List <DTO.PriceComparison.PriceOfferHistoryDTO>();
//try to get data
try
{
using (ProductOverviewRptEntities context = CreateContext())
{
result = converter.DB2DTO_PriceComparison_PriceOfferHistoryList(context.ProductOverviewRpt_PriceComparison_PriceOfferHistory_View.Where(o => o.FactoryOrderDetailID == id).ToList());
}
}
catch (Exception ex)
{
ex = Library.Helper.GetInnerException(ex);
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(result);
}
public DTO.ModelDTO GetOverviewData(int id, int?offerSeasonDetailID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.ModelDTO Data = new DTO.ModelDTO();
try
{
using (ProductOverviewRptEntities context = CreateContext())
{
ProductOverviewRpt_Model_View dbItem = context.ProductOverviewRpt_Model_View
.Include("ProductOverviewRpt_PriceOverview_View")
.FirstOrDefault(o => o.ModelID == id);
if (dbItem == null)
{
throw new Exception("Model not found!");
}
DTO.ModelDTO data = converter.DB2DTO_Model(dbItem);
if (offerSeasonDetailID.HasValue)
{
var dbOfferDetail = context.ProductOverviewRpt_OfferSeasonDetail_View.Where(o => o.OfferSeasonDetailID == offerSeasonDetailID).FirstOrDefault();
if (dbOfferDetail != null)
{
data.ArticleCode = dbOfferDetail.ArticleCode;
data.Description = dbOfferDetail.Description;
data.PackagingMethodNM = dbOfferDetail.PackagingMethodNM;
data.ClientUD = dbOfferDetail.ClientUD;
data.PurchasingPrice = dbOfferDetail.PurchasingPrice;
}
}
return(data);
}
}
catch (Exception ex)
{
ex = Library.Helper.GetInnerException(ex);
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(null);
}
public DTO.PriceComparison.FormData GetItemToCompareData(int id, int?offerSeasonDetailID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.PriceComparison.FormData data = new DTO.PriceComparison.FormData();
data.Data = new DTO.PriceComparison.ProductOptionDetailDTO();
data.Factories = new List <Support.DTO.Factory>();
data.QuotationStatuses = new List <Support.DTO.QuotationStatus>();
try
{
using (ProductOverviewRptEntities context = CreateContext())
{
if (offerSeasonDetailID.HasValue && offerSeasonDetailID.Value != 0)
{
ProductOverviewRpt_OfferSeasonDetail_View dbItem = context.ProductOverviewRpt_OfferSeasonDetail_View.FirstOrDefault(o => o.OfferSeasonDetailID == offerSeasonDetailID);
if (dbItem == null)
{
throw new Exception("Item not found!");
}
data.Data = AutoMapper.Mapper.Map <ProductOverviewRpt_OfferSeasonDetail_View, DTO.PriceComparison.ProductOptionDetailDTO>(dbItem);
}
else
{
ProductOverviewRpt_PriceComparison_ProductOptionDetail_View dbItem = context.ProductOverviewRpt_PriceComparison_ProductOptionDetail_View.FirstOrDefault(o => o.FactoryOrderDetailID == id);
if (dbItem == null)
{
throw new Exception("Item not found!");
}
data.Data = converter.DB2DTO_PriceComparison_ProductOptionDetail(dbItem);
}
}
data.Factories = supportFactory.GetFactory().ToList();
data.QuotationStatuses = supportFactory.GetQuotationStatus().ToList();
return(data);
}
catch (Exception ex)
{
ex = Library.Helper.GetInnerException(ex);
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(null);
}
public List <DTO.PriceComparison.ProductOptionDetailDTO> GetBestComparableItemData(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_SearchBestComparableItem(
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);
}
