//get data additional condition
public List <DTO.ClientAdditionalConditionDTO> GetACData(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
List <DTO.ClientAdditionalConditionDTO> data = new List <DTO.ClientAdditionalConditionDTO>();
//try to get data
try
{
using (FactoryQuotation2MngEntities context = CreateContext())
{
if (id > 0)
{
data = converter.DB2DTO_ACData(context.FactoryQuotation2Mng_ClientAdditionalCondition_View.ToList());
}
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
public bool ImportQuotationDetail(int userId, object dtoItems, out Library.DTO.Notification notification)
{
List <DTO.ImportQuotationDetailDTO> dtoImports = ((Newtonsoft.Json.Linq.JArray)dtoItems).ToObject <List <DTO.ImportQuotationDetailDTO> >();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
//try to get data
try
{
using (FactoryQuotation2MngEntities context = CreateContext())
{
foreach (var item in dtoImports)
{
context.FactoryQuotation2Mng_action_AddQuotationOffer(item.QuotationDetailID, item.FactoryPrice, item.NewComment, userId);
context.FW_function_RefreshPriceCacheRow(item.Season, item.QuotationDetailID, null);
}
}
return(true);
}
catch (Exception ex)
{
notification = new Library.DTO.Notification()
{
Message = ex.Message, Type = Library.DTO.NotificationType.Error
};
return(false);
}
}
public List <DTO.OfferHistoryDTO> GetHistoryData(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
List <DTO.OfferHistoryDTO> data = new List <DTO.OfferHistoryDTO>();
//try to get data
try
{
using (FactoryQuotation2MngEntities context = CreateContext())
{
if (id > 0)
{
data = converter.DB2DTO_OfferHistory(context.FactoryQuotation2Mng_OfferHistory_View.Where(o => o.QuotationDetailID == id).OrderByDescending(o => o.UpdatedDate).ToList());
}
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
private FactoryQuotation2MngEntities CreateContext()
{
FactoryQuotation2MngEntities mContext = new FactoryQuotation2MngEntities(Library.Helper.CreateEntityConnectionString("DAL.FactoryQuotation2MngModel"));
mContext.Database.CommandTimeout = 300;
return(mContext);
}
//
// CUSTOM FUNCTION HERE
//
public DTO.SupportFormData GetSearchFilter(out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
DTO.SupportFormData data = new DTO.SupportFormData();
data.QuotationStatusDTOs = new List <DTO.QuotationStatusDTO>();
//try to get data
try
{
using (FactoryQuotation2MngEntities context = CreateContext())
{
data.QuotationStatusDTOs = converter.DB2DTO_QuotationStatus(context.SupportMng_QuotationStatus_View.ToList());
//
// ADD CUSTOM STATUS AS REQUESTED - HARD CODE
//
List <int> toBeRemoveItems = new List <int>();
foreach (var item in data.QuotationStatusDTOs)
{
if (item.QuotationStatusID != 1 && item.QuotationStatusID != 3 && item.QuotationStatusID != 5)
{
toBeRemoveItems.Add(item.QuotationStatusID);
}
}
foreach (int id in toBeRemoveItems)
{
data.QuotationStatusDTOs.Remove(data.QuotationStatusDTOs.FirstOrDefault(o => o.QuotationStatusID == id));
}
data.QuotationStatusDTOs.Add(new DTO.QuotationStatusDTO {
QuotationStatusID = -1, QuotationStatusNM = "ITEMS COSTPRICE"
});
data.QuotationStatusDTOs.Add(new DTO.QuotationStatusDTO {
QuotationStatusID = -2, QuotationStatusNM = "ITEMS NO COSTPRICE"
});
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
public bool UpdateData(int userId, object dtoItems, out Library.DTO.Notification notification)
{
List <DTO.FactoryQuotationSearchResultDTO> dtoOffers = ((Newtonsoft.Json.Linq.JArray)dtoItems).ToObject <List <DTO.FactoryQuotationSearchResultDTO> >();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
List <int> confirmedQuotationDetailIDs = new List <int>();
try
{
//
// check factory access permission
//
foreach (DTO.FactoryQuotationSearchResultDTO dtoOffer in dtoOffers)
{
if (fwFactory.CheckFactoryPermission(userId, dtoOffer.FactoryID.Value) <= 0)
{
throw new Exception("You dont have permission for accessing factory data for [" + dtoOffer.FactoryUD + "]!");
}
}
using (FactoryQuotation2MngEntities context = CreateContext())
{
// get similar item: same offerlineid, same factoryid
int[] existingIDs = dtoOffers.Where(o => o.NewPurchasingPrice.HasValue).Select(o => o.QuotationDetailID.Value).ToArray();
List <DTO.FactoryQuotationSearchResultDTO> additionalItems = new List <DTO.FactoryQuotationSearchResultDTO>();
foreach (DTO.FactoryQuotationSearchResultDTO dtoItem in dtoOffers.Where(o => o.NewPurchasingPrice.HasValue && o.OfferSeasonDetailID.HasValue && o.StatusID != 3).ToList())
{
additionalItems = converter.DB2DTO_SimilarItems(context.FactoryQuotation2Mng_SimilarItem_View.Where(o =>
!existingIDs.Contains(o.QuotationDetailID) &&
o.OfferSeasonDetailID == dtoItem.OfferSeasonDetailID &&
o.FactoryID == dtoItem.FactoryID &&
o.StatusID != 3).ToList());
if (additionalItems.Count() > 0)
{
additionalItems.ForEach(o => { o.NewPurchasingPrice = dtoItem.NewPurchasingPrice.Value; o.NewPurchasingComment = dtoItem.NewPurchasingComment; });
dtoOffers.AddRange(additionalItems);
}
}
foreach (DTO.FactoryQuotationSearchResultDTO dtoItem in dtoOffers.Where(o => o.NewPurchasingPrice.HasValue && o.QuotationStatusNM != "WAITING REJECT"))
{
QuotationDetail dbQuotationDetail = context.QuotationDetail.FirstOrDefault(o => o.QuotationDetailID == dtoItem.QuotationDetailID);
if (dbQuotationDetail == null)
{
throw new Exception("Quotation item: [" + dtoItem.ArticleCode + "] [" + dtoItem.FactoryUD + "] not found!");
}
var dbDiff = context.PriceDifference.FirstOrDefault(o => o.PriceDifferenceUD == dtoItem.PriceDifferenceCode && o.Season == dtoItem.Season);
if (dbDiff == null)
{
throw new Exception("Quality code: [" + dtoItem.PriceDifferenceCode + "] [" + dtoItem.Season + "] not found!");
}
dbQuotationDetail.PurchasingPrice = dtoItem.NewPurchasingPrice.Value;
dbQuotationDetail.PriceUpdatedDate = DateTime.Now;
dbQuotationDetail.SalePrice = dtoItem.NewPurchasingPrice.Value * (1 + Math.Round(dbDiff.Rate.Value / 100, 2, MidpointRounding.AwayFromZero));
// check if can confirm
if (dbQuotationDetail.TargetPrice == null)
{
dbQuotationDetail.TargetPrice = 0;
}
if (dbQuotationDetail.SalePrice == Math.Round(dbQuotationDetail.TargetPrice.Value / (1 + dbDiff.Rate.Value), 2, MidpointRounding.AwayFromZero))
{
dbQuotationDetail.StatusID = 3; // confirm status;
dbQuotationDetail.StatusUpdatedBy = userId;
dbQuotationDetail.StatusUpdatedDate = DateTime.Now;
//confirmedQuotationDetailIDs.Add(dbQuotationDetail.QuotationDetailID);
if (dbQuotationDetail.OfferSeasonQuotationRequestDetailID.HasValue)
{
confirmedQuotationDetailIDs.Add(dbQuotationDetail.QuotationDetailID);
}
}
QuotationOffer dbOffer = new QuotationOffer();
context.QuotationOffer.Add(dbOffer);
dbOffer.QuotationOfferVersion = context.QuotationOffer.Count(o => o.QuotationID == dbQuotationDetail.QuotationID) + 1;
dbOffer.QuotationID = dbQuotationDetail.QuotationID;
dbOffer.QuotationOfferDate = DateTime.Now;
dbOffer.QuotationOfferDirectionID = 1;
dbOffer.UpdatedBy = userId;
dbOffer.UpdatedDate = DateTime.Now;
QuotationOfferDetail dbOfferDetail = new QuotationOfferDetail();
dbOffer.QuotationOfferDetail.Add(dbOfferDetail);
dbOfferDetail.QuotationDetailID = dtoItem.QuotationDetailID;
dbOfferDetail.Price = dtoItem.NewPurchasingPrice.Value;
if (!string.IsNullOrEmpty(dtoItem.NewPurchasingComment))
{
dbOfferDetail.Remark = dtoItem.NewPurchasingComment;
}
}
foreach (DTO.FactoryQuotationSearchResultDTO dtoItem in dtoOffers.Where(o => o.QuotationStatusNM == "WAITING REJECT"))
{
QuotationDetail dbQuotationDetail = context.QuotationDetail.FirstOrDefault(o => o.QuotationDetailID == dtoItem.QuotationDetailID);
if (dbQuotationDetail == null)
{
throw new Exception("Quotation item: [" + dtoItem.ArticleCode + "] [" + dtoItem.FactoryUD + "] not found!");
}
dbQuotationDetail.StatusID = 5; //REJECTED
dbQuotationDetail.StatusUpdatedBy = userId;
dbQuotationDetail.StatusUpdatedDate = DateTime.Now;
//reset data OfferSeasonDetail
context.FactoryQuotation2Mng_function_AfterUnConfirm(dtoItem.QuotationDetailID);
}
context.SaveChanges();
// update offer season planing purchasing price
foreach (int quotationDetailID in confirmedQuotationDetailIDs)
{
context.FW_function_UpdateOfferSeasonDetailPurchasingPriceFromQuotationConfirmed(quotationDetailID, userId);
}
// refresh cached data
foreach (DTO.FactoryQuotationSearchResultDTO dtoItem in dtoOffers.ToList())
{
context.FW_function_RefreshPriceCacheRow(dtoItem.Season, dtoItem.QuotationDetailID, null);
}
return(true);
}
}
catch (Exception ex)
{
notification = new Library.DTO.Notification()
{
Message = ex.Message, Type = Library.DTO.NotificationType.Error
};
return(false);
}
}
public override DTO.SearchFormData GetDataWithFilter(System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Success
};
DTO.SearchFormData data = new DTO.SearchFormData();
data.Data = new List <DTO.FactoryQuotationSearchResultDTO>();
data.WaitForFactoryConclusionDTOs = new List <DTO.FactoryDTO>();
data.WaitForFactoryProductionConclusionDTOs = new List <DTO.FactoryDTO>();
totalRows = 0;
string Season = null;
string ClientUD = null;
string Description = null;
string FactoryUD = null;
string ProformaInvoiceNo = null;
int? ItemTypeID = null;
int? StatusID = null;
int? QuotationOfferDirectionID = null;
int? BusinessDataStatusID = null;
int UserID = 0;
bool? IsDeadline = null;
bool? IsRepeatItem = null;
if (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString()))
{
Season = filters["Season"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("ClientUD") && !string.IsNullOrEmpty(filters["ClientUD"].ToString()))
{
ClientUD = filters["ClientUD"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("Description") && !string.IsNullOrEmpty(filters["Description"].ToString()))
{
Description = filters["Description"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("FactoryUD") && !string.IsNullOrEmpty(filters["FactoryUD"].ToString()))
{
FactoryUD = filters["FactoryUD"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("ProformaInvoiceNo") && !string.IsNullOrEmpty(filters["ProformaInvoiceNo"].ToString()))
{
ProformaInvoiceNo = filters["ProformaInvoiceNo"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("ItemTypeID") && filters["ItemTypeID"] != null && !string.IsNullOrEmpty(filters["ItemTypeID"].ToString()))
{
ItemTypeID = Convert.ToInt32(filters["ItemTypeID"].ToString());
}
if (filters.ContainsKey("StatusID") && filters["StatusID"] != null && !string.IsNullOrEmpty(filters["StatusID"].ToString()))
{
StatusID = Convert.ToInt32(filters["StatusID"].ToString());
}
if (filters.ContainsKey("QuotationOfferDirectionID") && filters["QuotationOfferDirectionID"] != null && !string.IsNullOrEmpty(filters["QuotationOfferDirectionID"].ToString()))
{
QuotationOfferDirectionID = Convert.ToInt32(filters["QuotationOfferDirectionID"].ToString());
}
if (filters.ContainsKey("BusinessDataStatusID") && filters["BusinessDataStatusID"] != null && !string.IsNullOrEmpty(filters["BusinessDataStatusID"].ToString()))
{
BusinessDataStatusID = Convert.ToInt32(filters["BusinessDataStatusID"].ToString());
}
if (filters.ContainsKey("UserID") && filters["UserID"] != null && !string.IsNullOrEmpty(filters["UserID"].ToString()))
{
UserID = Convert.ToInt32(filters["UserID"].ToString());
}
if (filters.ContainsKey("IsDeadLine") && filters["IsDeadLine"] != null && !string.IsNullOrEmpty(filters["IsDeadLine"].ToString()))
{
IsDeadline = Convert.ToBoolean(int.Parse(filters["IsDeadLine"].ToString()));
}
if (filters.ContainsKey("IsRepeatItem") && filters["IsRepeatItem"] != null && !string.IsNullOrEmpty(filters["IsRepeatItem"].ToString()))
{
IsRepeatItem = Convert.ToBoolean(int.Parse(filters["IsRepeatItem"].ToString()));
}
//try to get data
try
{
using (FactoryQuotation2MngEntities context = CreateContext())
{
// get search data
if (pageIndex > 1)
{
totalRows = -1;
}
else
{
// get conclusion by season
var dbConclusion = context.FactoryQuotation2Mng_function_GetQuotaionConclusion(Season, ClientUD, Description, FactoryUD,
ItemTypeID, StatusID, QuotationOfferDirectionID, ProformaInvoiceNo, BusinessDataStatusID).FirstOrDefault();
data.TotalItem = dbConclusion.TotalItem.Value;
data.TotalConfirmedItem = dbConclusion.TotalConfirmedItem.Value;
data.TotalWaitForEurofar = dbConclusion.TotalWaitEurofar.Value;
data.TotalContainer = dbConclusion.TotalContainer.Value;
data.TotalConfirmedContainer = dbConclusion.TotalConfirmedContainer.Value;
data.TotalContainerWaitForEurofar = dbConclusion.TotalContainerWaitEurofar.Value;
// wait for factory conclusion - offer item
var WaitForFactoryConclusionDTOs = converter.DB2DTO_WaitForFactoryConclusionDTO(context.FactoryQuotation2Mng_function_GetWaitForFactoryConclusion(Season, UserID).ToList());
WaitForFactoryConclusionDTOs.Select(o => new { o.FactoryID, o.FactoryUD }).Distinct().ToList().ForEach(o => data.WaitForFactoryConclusionDTOs.Add(new DTO.FactoryDTO {
FactoryID = o.FactoryID, FactoryUD = o.FactoryUD
}));
foreach (DTO.FactoryDTO dtoFactory in data.WaitForFactoryConclusionDTOs)
{
if (WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 1) != null)
{
dtoFactory.OverDue1Day = WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 1).TotalItem;
}
if (WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 2) != null)
{
dtoFactory.OverDue2Day = WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 2).TotalItem;
}
if (WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 3) != null)
{
dtoFactory.OverDue3Day = WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 3).TotalItem;
}
if (WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 4) != null)
{
dtoFactory.OverDue4DayOrMore = WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 4).TotalItem;
}
dtoFactory.TotalPendingItem = WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID).TotalPendingItem;
dtoFactory.PricingTeamMemberID = WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID).PricingTeamMemberID;
dtoFactory.PricingTeamMemberNM = WaitForFactoryConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID).PricingTeamMemberNM;
}
// wait for factory conclusion - production item
var WaitForFactoryProductionConclusionDTOs = converter.DB2DTO_WaitForFactoryProductionConclusionDTO(context.FactoryQuotation2Mng_function_GetWaitForFactoryProductionConclusion(Season, UserID).ToList());
WaitForFactoryProductionConclusionDTOs.Select(o => new { o.FactoryID, o.FactoryUD }).Distinct().ToList().ForEach(o => data.WaitForFactoryProductionConclusionDTOs.Add(new DTO.FactoryDTO {
FactoryID = o.FactoryID, FactoryUD = o.FactoryUD
}));
foreach (DTO.FactoryDTO dtoFactory in data.WaitForFactoryProductionConclusionDTOs)
{
if (WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == -1) != null)
{
dtoFactory.OverLDS = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == -1).TotalItem;
}
if (WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 0) != null)
{
dtoFactory.LDS = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 0).TotalItem;
}
if (WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 1) != null)
{
dtoFactory.OneToTwoDays = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 1).TotalItem;
}
if (WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 2) != null)
{
dtoFactory.ThreeToFourDays = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 2).TotalItem;
}
if (WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 3) != null)
{
dtoFactory.FiveToSixDays = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 3).TotalItem;
}
if (WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 4) != null)
{
dtoFactory.MoreThanSixDays = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID && o.TotalWaitedWeeks == 4).TotalItem;
}
dtoFactory.TotalPendingItem = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID).TotalPendingItem;
dtoFactory.PricingTeamMemberID = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID).PricingTeamMemberID;
dtoFactory.PricingTeamMemberNM = WaitForFactoryProductionConclusionDTOs.FirstOrDefault(o => o.FactoryID == dtoFactory.FactoryID).PricingTeamMemberNM;
}
//totalRows = context.FactoryQuotation2Mng__function_GetTotalRowFound(Season, ClientUD, Description, FactoryUD, ItemTypeID, StatusID, QuotationOfferDirectionID, ProformaInvoiceNo, BusinessDataStatusID, UserID).FirstOrDefault().Value;
totalRows = context.FactoryQuotation2Mng_function_SearchFactoryQuotation(Season, ClientUD, Description, FactoryUD, ItemTypeID, StatusID, QuotationOfferDirectionID, ProformaInvoiceNo, BusinessDataStatusID, UserID, IsDeadline, IsRepeatItem, orderBy, orderDirection).Count();
}
var result = context.FactoryQuotation2Mng_function_SearchFactoryQuotation(Season, ClientUD, Description, FactoryUD, ItemTypeID, StatusID, QuotationOfferDirectionID, ProformaInvoiceNo, BusinessDataStatusID, UserID, IsDeadline, IsRepeatItem, orderBy, orderDirection);
data.Data = converter.DB2DTO_FactoryQuotationSearchResult(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = Library.Helper.HandleExceptionSingleLine(ex);
}
return(data);
}
