Example #1
0
        public bool UnConfirmData(int userID, int id, ref object dtoItem, out Library.DTO.Notification notification)
        {
            notification = new Notification()
            {
                Type = NotificationType.Success
            };

            int quotationDetailID = id;

            try
            {
                using (var context = CreateContext())
                {
                    QuotationDetail dbItem = context.QuotationDetail.FirstOrDefault(o => o.QuotationDetailID == quotationDetailID);

                    if (dbItem == null)
                    {
                        notification.Type    = NotificationType.Error;
                        notification.Message = "Data is not found!";
                        return(false);
                    }

                    dbItem.StatusID          = 1; // Pending
                    dbItem.StatusUpdatedBy   = userID;
                    dbItem.StatusUpdatedDate = DateTime.Now;

                    context.SaveChanges();

                    dtoItem = AutoMapper.Mapper.Map <PriceQuotationMng_PriceQuotationSearchResult_View, DTO.PriceQuotationSearchResultData>(context.PriceQuotationMng_PriceQuotationSearchResult_View.FirstOrDefault(o => o.QuotationDetailID == quotationDetailID));

                    return(true);
                }
            }
            catch (Exception ex)
            {
                notification.Type    = NotificationType.Error;
                notification.Message = ex.Message;
                return(false);
            }
        }
Example #2
0
        public override bool UpdateData(int userId, int id, ref object dtoItem, out Notification notification)
        {
            EditOfferQuotationData data = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <EditOfferQuotationData>();

            notification = new Notification()
            {
                Type = NotificationType.Success
            };

            try
            {
                using (var context = CreateContext())
                {
                    //bool isCheckFactory = CheckIsFactory(context, userId);
                    bool isCheckFactory = true;

                    // Case change price difference at pop-up quotation in factory
                    var dbQuotation     = context.Quotation.FirstOrDefault(o => o.QuotationID == data.QuotationID);
                    var priceDifference = context.PriceDifference.FirstOrDefault(o => o.PriceDifferenceUD == data.PriceDifferenceCode && o.Season == dbQuotation.Season);
                    if (priceDifference == null)
                    {
                        throw new Exception("Quality code is missing!");
                    }
                    data.PriceDifferenceRate = priceDifference.Rate;

                    if (data.Price != null)
                    {
                        // QuotationOffer.
                        QuotationOffer quotationOffer = new QuotationOffer
                        {
                            QuotationID               = data.QuotationID,
                            QuotationOfferDate        = DateTime.Now,
                            QuotationOfferVersion     = context.QuotationOffer.Where(o => o.QuotationID == data.QuotationID).ToList().Count + 1,
                            QuotationOfferDirectionID = (!isCheckFactory) ? 2 : 1,
                            UpdatedBy   = userId,
                            UpdatedDate = DateTime.Now
                        };
                        context.QuotationOffer.Add(quotationOffer);

                        // QuotationOfferDetail
                        QuotationOfferDetail quotationOfferDetail = new QuotationOfferDetail()
                        {
                            QuotationOfferID  = quotationOffer.QuotationOfferID,
                            QuotationDetailID = data.QuotationDetailID,
                            Price             = data.Price,
                            Remark            = data.Remark
                        };
                        context.QuotationOfferDetail.Add(quotationOfferDetail);
                    }

                    //QuotationDetail
                    QuotationDetail quotationDetail = context.QuotationDetail.FirstOrDefault(o => o.QuotationDetailID == data.QuotationDetailID);
                    if (data.Price != null)
                    {
                        if (isCheckFactory)
                        {
                            quotationDetail.PurchasingPrice = data.Price;
                            quotationDetail.SalePrice       = data.Price * (1 + data.PriceDifferenceRate);

                            if (data.Price == quotationDetail.TargetPrice) // Compare with target price
                            {
                                quotationDetail.StatusID          = 3;     // 3: Confirm
                                quotationDetail.StatusUpdatedBy   = userId;
                                quotationDetail.StatusUpdatedDate = DateTime.Now;
                            }
                        }
                        else
                        {
                            quotationDetail.TargetPrice = data.Price /*/ (1 + data.PriceDifferenceRate)*/;

                            if (quotationDetail.SalePrice != data.SalePrice)
                            {
                                quotationDetail.SalePrice = data.SalePrice;

                                // Update Quotation Offer Detail Last
                                QuotationOfferDetail lastQuotationOfferDetail = context.QuotationOfferDetail.Where(o => o.QuotationDetailID == data.QuotationDetailID).OrderByDescending(o => o.QuotationOfferDetailID).FirstOrDefault();
                                lastQuotationOfferDetail.Price = data.SalePrice;
                            }

                            if (quotationDetail.TargetPrice == quotationDetail.SalePrice) // Compare with sale price
                            {
                                quotationDetail.StatusID          = 3;                    // 3: Confirm
                                quotationDetail.StatusUpdatedBy   = userId;
                                quotationDetail.StatusUpdatedDate = DateTime.Now;
                            }
                        }

                        quotationDetail.PriceUpdatedBy   = userId;
                        quotationDetail.PriceUpdatedDate = DateTime.Now;
                    }

                    quotationDetail.Remark = data.Remark;

                    if (!isCheckFactory)
                    {
                        quotationDetail.PriceDifferenceCode = data.PriceDifferenceCode;
                        quotationDetail.PriceDifferenceRate = data.PriceDifferenceRate;
                        quotationDetail.OldPrice1           = data.OldPrice1;
                        quotationDetail.OldPrice2           = data.OldPrice2;
                        quotationDetail.OldPrice3           = data.OldPrice3;
                        quotationDetail.OldPriceRemark      = data.OldPriceRemark;
                    }

                    context.SaveChanges();

                    dtoItem = AutoMapper.Mapper.Map <PriceQuotationMng_PriceQuotationSearchResult_View, DTO.PriceQuotationSearchResultData>(context.PriceQuotationMng_PriceQuotationSearchResult_View.FirstOrDefault(o => o.QuotationDetailID == data.QuotationDetailID));

                    return(true);
                }
            }
            catch (Exception ex)
            {
                notification.Type    = NotificationType.Error;
                notification.Message = ex.Message;
                return(false);
            }
        }
Example #3
0
        public List <PriceQuotationSearchResultData> UpdateData(int userId, object dtoItems, out Notification notification)
        {
            string keyIds = "";

            notification = new Notification()
            {
                Type = NotificationType.Success
            };

            List <PriceQuotationSearchResultData> dataItems = ((Newtonsoft.Json.Linq.JArray)dtoItems).ToObject <List <PriceQuotationSearchResultData> >();

            using (var context = CreateContext())
            {
                //bool isFactory = CheckIsFactory(context, userId);
                bool isFactory = true;

                using (var trans = context.Database.BeginTransaction())
                {
                    try
                    {
                        for (int i = 0; i < dataItems.Count; i++)
                        {
                            var dataItem = dataItems[i];
                            if (dataItem.QuotationStatusID.Value == 3)
                            {
                                // skip processing if price already confirmed
                                continue;
                            }

                            if (i > 0)
                            {
                                keyIds = keyIds + ",";
                            }

                            // Quotation Offer
                            QuotationOffer offer = new QuotationOffer()
                            {
                                QuotationID               = dataItem.QuotationID,
                                QuotationOfferDate        = DateTime.Now,
                                QuotationOfferVersion     = context.QuotationOffer.Where(o => o.QuotationID == dataItem.QuotationID).ToList().Count + 1,
                                QuotationOfferDirectionID = (!isFactory) ? 2 : 1,
                                UpdatedBy   = userId,
                                UpdatedDate = DateTime.Now
                            };

                            context.QuotationOffer.Add(offer);

                            // Quotation Offer Detail
                            QuotationOfferDetail offerDetail = new QuotationOfferDetail()
                            {
                                QuotationOfferID  = offer.QuotationOfferID,
                                QuotationDetailID = dataItem.QuotationDetailID,
                                Price             = dataItem.Price
                            };

                            context.QuotationOfferDetail.Add(offerDetail);

                            // Quotation Detail
                            QuotationDetail quotationDetail = context.QuotationDetail.FirstOrDefault(o => o.QuotationDetailID == dataItem.QuotationDetailID);

                            if (isFactory)
                            {
                                quotationDetail.PurchasingPrice = dataItem.Price;
                                quotationDetail.SalePrice       = dataItem.Price * (1 + quotationDetail.PriceDifferenceRate);

                                if (dataItem.Price == quotationDetail.TargetPrice)
                                {
                                    quotationDetail.StatusID          = 3;
                                    quotationDetail.StatusUpdatedBy   = userId;
                                    quotationDetail.StatusUpdatedDate = DateTime.Now;
                                }
                            }
                            else
                            {
                                quotationDetail.TargetPrice = dataItem.Price;

                                if (quotationDetail.SalePrice != dataItem.SalePrice)
                                {
                                    quotationDetail.SalePrice = dataItem.SalePrice;
                                }

                                if (quotationDetail.TargetPrice == quotationDetail.SalePrice)
                                {
                                    quotationDetail.StatusID          = 3;
                                    quotationDetail.StatusUpdatedBy   = userId;
                                    quotationDetail.StatusUpdatedDate = DateTime.Now;
                                }
                            }

                            quotationDetail.PriceUpdatedBy   = userId;
                            quotationDetail.PriceUpdatedDate = DateTime.Now;

                            keyIds = keyIds + dataItem.QuotationDetailID.ToString();

                            context.SaveChanges();
                        }

                        trans.Commit();

                        return(converter.DB2DTO_PriceQuotationSearchResult(context.PriceQuotationMng_PriceQuotationSearchResult_View.Where(o => keyIds.Contains(o.QuotationDetailID.ToString())).ToList()));
                    }
                    catch (Exception ex)
                    {
                        trans.Rollback();

                        notification.Type    = NotificationType.Error;
                        notification.Message = ex.Message;

                        return(new List <PriceQuotationSearchResultData>());
                    }
                }
            }
        }