示例#1
0
        public PurchaseQuotationLineCharge Create(PurchaseQuotationLineCharge pt)
        {
            pt.ObjectState = ObjectState.Added;
            _unitOfWork.Repository <PurchaseQuotationLineCharge>().Insert(pt);

            return(pt);
        }
        public ActionResult _ResultsPost(PurchaseQuotationMasterDetailModel vm)
        {
            List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
            List <LineChargeViewModel>   LineCharges   = new List <LineChargeViewModel>();
            int  pk               = 0;
            int  ReceiptLinepk    = 0;
            int  StockPk          = 0;
            int  Cnt              = 0;
            int  Serial           = _PurchaseQuotationLineService.GetMaxSr(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId);
            bool HeaderChargeEdit = false;

            PurchaseQuotationHeader Header = _PurchaseQuotationHeaderService.Find(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId);

            PurchaseQuotationSetting Settings = new PurchaseQuotationSettingService(_unitOfWork).GetPurchaseQuotationSettingForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);

            int?MaxLineId = new PurchaseQuotationLineChargeService(_unitOfWork).GetMaxProductCharge(Header.PurchaseQuotationHeaderId, "Web.PurchaseQuotationLines", "PurchaseQuotationHeaderId", "PurchaseQuotationLineId");

            int PersonCount   = 0;
            int CalculationId = Settings.CalculationId;

            List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();

            bool BeforeSave = true;

            //try
            //{
            //    BeforeSave = PurchaseQuotationReceiveDocEvents.beforeLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId), ref db);
            //}
            //catch (Exception ex)
            //{
            //    string message = _exception.HandleException(ex);
            //    TempData["CSEXCL"] += message;
            //    EventException = true;
            //}

            if (!BeforeSave)
            {
                ModelState.AddModelError("", "Validation failed before save");
            }

            if (ModelState.IsValid && BeforeSave && !EventException)
            {
                int ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.FullFinishing).ProcessId;

                var IndentLineIds = vm.PurchaseQuotationLineViewModel.Select(m => m.PurchaseIndentLineId).ToArray();

                var IndentBalRecords = (from p in db.ViewPurchaseIndentBalance
                                        where IndentLineIds.Contains(p.PurchaseIndentLineId)
                                        select new
                {
                    LineId = p.PurchaseIndentLineId,
                    BalQty = p.BalanceQty,
                }).ToList();

                foreach (var item in vm.PurchaseQuotationLineViewModel)
                {
                    decimal balqty = IndentBalRecords.Where(m => m.LineId == item.PurchaseIndentLineId).FirstOrDefault().BalQty;

                    if (item.Qty > 0 && (Settings.isMandatoryRate == true ? item.Rate > 0 : 1 == 1) && item.Qty <= balqty)
                    {
                        PurchaseGoodsReceiptLine ReceiptLine = new PurchaseGoodsReceiptLine();
                        var PurchaseIndentLine = new PurchaseIndentLineService(_unitOfWork).Find(item.PurchaseIndentLineId.Value);


                        PurchaseQuotationLine line = new PurchaseQuotationLine();
                        line.PurchaseQuotationHeaderId = item.PurchaseQuotationHeaderId;
                        line.UnitConversionMultiplier  = item.UnitConversionMultiplier;
                        line.Rate = item.Rate;
                        line.PurchaseIndentLineId = item.PurchaseIndentLineId;
                        line.DiscountPer          = item.DiscountPer;
                        line.Qty                     = item.Qty;
                        line.DealUnitId              = item.DealUnitId;
                        line.DealQty                 = item.Qty * item.UnitConversionMultiplier;
                        line.Amount                  = (line.DealQty * item.Rate);
                        line.CreatedDate             = DateTime.Now;
                        line.ProductId               = PurchaseIndentLine.ProductId;
                        line.Dimension1Id            = PurchaseIndentLine.Dimension1Id;
                        line.Dimension2Id            = PurchaseIndentLine.Dimension2Id;
                        line.Specification           = PurchaseIndentLine.Specification;
                        line.Sr                      = Serial++;
                        line.ModifiedDate            = DateTime.Now;
                        line.CreatedBy               = User.Identity.Name;
                        line.ModifiedBy              = User.Identity.Name;
                        line.PurchaseQuotationLineId = pk;
                        line.ObjectState             = Model.ObjectState.Added;
                        //_PurchaseQuotationLineService.Create(line);
                        db.PurchaseQuotationLine.Add(line);


                        LineList.Add(new LineDetailListViewModel {
                            Amount = line.Amount, Rate = line.Rate, LineTableId = line.PurchaseQuotationLineId, HeaderTableId = item.PurchaseQuotationHeaderId, PersonID = Header.SupplierId
                        });

                        pk++;
                        StockPk++;
                    }
                }

                if (Header.Status != (int)StatusConstants.Drafted)
                {
                    Header.Status       = (int)StatusConstants.Modified;
                    Header.ModifiedBy   = User.Identity.Name;
                    Header.ModifiedDate = DateTime.Now;
                }

                Header.ObjectState = Model.ObjectState.Modified;
                db.PurchaseQuotationHeader.Add(Header);

                //new PurchaseGoodsReceiptHeaderService(_unitOfWork).Update(ReceiptHeader);

                new ChargesCalculationService(_unitOfWork).CalculateCharges(LineList, vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.PurchaseQuotationHeaderCharges", "Web.PurchaseQuotationLineCharges", out PersonCount, Header.DocTypeId, Header.SiteId, Header.DivisionId);

                //Saving Charges
                foreach (var item in LineCharges)
                {
                    PurchaseQuotationLineCharge PoLineCharge = Mapper.Map <LineChargeViewModel, PurchaseQuotationLineCharge>(item);
                    PoLineCharge.ObjectState = Model.ObjectState.Added;
                    db.PurchaseQuotationLineCharge.Add(PoLineCharge);
                    //new PurchaseQuotationLineChargeService(_unitOfWork).Create(PoLineCharge);
                }


                //Saving Header charges
                for (int i = 0; i < HeaderCharges.Count(); i++)
                {
                    if (!HeaderChargeEdit)
                    {
                        PurchaseQuotationHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, PurchaseQuotationHeaderCharge>(HeaderCharges[i]);
                        POHeaderCharge.HeaderTableId = vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId;
                        POHeaderCharge.PersonID      = Header.SupplierId;
                        POHeaderCharge.ObjectState   = Model.ObjectState.Added;
                        db.PurchaseQuotationHeaderCharge.Add(POHeaderCharge);
                        //new PurchaseQuotationHeaderChargeService(_unitOfWork).Create(POHeaderCharge);
                    }
                    else
                    {
                        var footercharge = new PurchaseQuotationHeaderChargeService(_unitOfWork).Find(HeaderCharges[i].Id);
                        footercharge.Rate        = HeaderCharges[i].Rate;
                        footercharge.Amount      = HeaderCharges[i].Amount;
                        footercharge.ObjectState = Model.ObjectState.Modified;
                        db.PurchaseQuotationHeaderCharge.Add(footercharge);
                        //new PurchaseQuotationHeaderChargeService(_unitOfWork).Update(footercharge);
                    }
                }

                //try
                //{
                //    PurchaseQuotationReceiveDocEvents.onLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId), ref db);
                //}
                //catch (Exception ex)
                //{
                //    string message = _exception.HandleException(ex);
                //    TempData["CSEXCL"] += message;
                //    EventException = true;
                //}

                try
                {
                    if (EventException)
                    {
                        throw new Exception();
                    }

                    db.SaveChanges();
                    //_unitOfWork.Save();
                }

                catch (Exception ex)
                {
                    string message = _exception.HandleException(ex);
                    TempData["CSEXCL"] += message;
                    return(PartialView("_IndentResults", vm));
                }

                //try
                //{
                //    PurchaseQuotationReceiveDocEvents.afterLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseQuotationLineViewModel.FirstOrDefault().PurchaseQuotationHeaderId), ref db);
                //}
                //catch (Exception ex)
                //{
                //    string message = _exception.HandleException(ex);
                //    TempData["CSEXC"] += message;
                //}

                LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
                {
                    DocTypeId    = Header.DocTypeId,
                    DocId        = Header.PurchaseQuotationHeaderId,
                    ActivityType = (int)ActivityTypeContants.MultipleCreate,
                    DocNo        = Header.DocNo,
                    DocDate      = Header.DocDate,
                    DocStatus    = Header.Status,
                }));

                return(Json(new { success = true }));
            }
            return(PartialView("_IndentResults", vm));
        }
示例#3
0
 public void Update(PurchaseQuotationLineCharge pt)
 {
     pt.ObjectState = ObjectState.Modified;
     _unitOfWork.Repository <PurchaseQuotationLineCharge>().Update(pt);
 }
示例#4
0
 public PurchaseQuotationLineCharge Add(PurchaseQuotationLineCharge pt)
 {
     _unitOfWork.Repository <PurchaseQuotationLineCharge>().Insert(pt);
     return(pt);
 }
示例#5
0
 public void Delete(PurchaseQuotationLineCharge pt)
 {
     _unitOfWork.Repository <PurchaseQuotationLineCharge>().Delete(pt);
 }