public PurchaseOrderAmendmentHeaderCharge Create(PurchaseOrderAmendmentHeaderCharge pt)
        {
            pt.ObjectState = ObjectState.Added;
            _unitOfWork.Repository <PurchaseOrderAmendmentHeaderCharge>().Insert(pt);

            return(pt);
        }
示例#2
0
        public ActionResult Post(PurchaseOrderAmendmentHeaderViewModel vm)
        {
            bool BeforeSave = true;
            int  Serial     = 1;
            Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();

            PurchaseOrderAmendmentHeader pt = AutoMapper.Mapper.Map <PurchaseOrderAmendmentHeaderViewModel, PurchaseOrderAmendmentHeader>(vm);

            try
            {
                BeforeSave = PurchaseOrderAmendmentDocEvents.beforeWizardSaveEvent(this, new PurchaseEventArgs(vm.PurchaseOrderAmendmentHeaderId), ref db);
            }
            catch (Exception ex)
            {
                string message = _exception.HandleException(ex);
                TempData["CSEXC"] += message;
                EventException     = true;
            }


            if (!BeforeSave)
            {
                TempData["CSEXC"] += "Failed validation before save";
            }


            int Cnt = 0;
            int Sr  = 0;

            List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
            List <LineChargeViewModel>   LineCharges   = new List <LineChargeViewModel>();
            int  pk = 0;
            bool HeaderChargeEdit = false;



            PurchaseOrderSetting Settings = new PurchaseOrderSettingService(_unitOfWork).GetPurchaseOrderSettingForDocument(vm.DocTypeId, vm.DivisionId, vm.SiteId);

            int?MaxLineId   = 0;
            int PersonCount = 0;

            if (!Settings.CalculationId.HasValue)
            {
                throw new Exception("Calculation not configured in Purchase order settings");
            }

            int CalculationId = Settings.CalculationId ?? 0;

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


            if (ModelState.IsValid && BeforeSave && !EventException)
            {
                pt.Status = (int)StatusConstants.Drafted;

                _PurchaseOrderAmendmentHeaderService.Create(pt, User.Identity.Name);

                var SelectedPurchaseOrders = (List <PurchaseOrderAmendmentWizardViewModel>)System.Web.HttpContext.Current.Session["RateAmendmentWizardOrders"];

                var PurchaseOrderLineIds = SelectedPurchaseOrders.Select(m => m.PurchaseOrderLineId).ToArray();

                var PurchaseOrderBalanceRecords = (from p in db.ViewPurchaseOrderBalanceForInvoice
                                                   where PurchaseOrderLineIds.Contains(p.PurchaseOrderLineId)
                                                   select p).AsNoTracking().ToList();

                var PurchaseOrderRecords = (from p in db.PurchaseOrderLine
                                            where PurchaseOrderLineIds.Contains(p.PurchaseOrderLineId)
                                            select p).AsNoTracking().ToList();

                foreach (var item in SelectedPurchaseOrders)
                {
                    PurchaseOrderLine orderline = PurchaseOrderRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault();
                    var balorderline            = PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault();

                    if (item.Rate - PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().Rate != 0)
                    {
                        PurchaseOrderRateAmendmentLine line = new PurchaseOrderRateAmendmentLine();

                        line.PurchaseOrderAmendmentHeaderId = pt.PurchaseOrderAmendmentHeaderId;
                        line.PurchaseOrderLineId            = item.PurchaseOrderLineId;
                        line.Qty               = PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().BalanceQty;
                        line.AmendedRate       = item.Rate;
                        line.Rate              = line.AmendedRate - balorderline.Rate;
                        line.Amount            = balorderline.BalanceQty * orderline.UnitConversionMultiplier * line.Rate;
                        line.PurchaseOrderRate = balorderline.Rate;
                        line.Sr = Serial++;
                        line.PurchaseOrderRateAmendmentLineId = pk;
                        line.CreatedDate  = DateTime.Now;
                        line.ModifiedDate = DateTime.Now;
                        line.CreatedBy    = User.Identity.Name;
                        line.ModifiedBy   = User.Identity.Name;
                        LineStatus.Add(line.PurchaseOrderLineId, line.Rate);

                        line.ObjectState = Model.ObjectState.Added;
                        db.PurchaseOrderRateAmendmentLine.Add(line);

                        if (Settings.CalculationId.HasValue)
                        {
                            LineList.Add(new LineDetailListViewModel {
                                Amount = line.Amount, Rate = line.Rate, LineTableId = line.PurchaseOrderRateAmendmentLineId, HeaderTableId = pt.PurchaseOrderAmendmentHeaderId, PersonID = pt.SupplierId, DealQty = orderline.DealQty
                            });
                        }
                        pk++;
                        Cnt = Cnt + 1;
                    }
                }

                new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseRateOnAmendmentMultiple(LineStatus, pt.DocDate, ref db);


                new ChargesCalculationService(_unitOfWork).CalculateCharges(LineList, pt.PurchaseOrderAmendmentHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.PurchaseOrderAmendmentHeaderCharges", "Web.PurchaseOrderRateAmendmentLineCharges", out PersonCount, pt.DocTypeId, pt.SiteId, pt.DivisionId);

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


                //Saving Header charges
                for (int i = 0; i < HeaderCharges.Count(); i++)
                {
                    if (!HeaderChargeEdit)
                    {
                        PurchaseOrderAmendmentHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, PurchaseOrderAmendmentHeaderCharge>(HeaderCharges[i]);
                        POHeaderCharge.HeaderTableId = pt.PurchaseOrderAmendmentHeaderId;
                        POHeaderCharge.PersonID      = pt.SupplierId;
                        POHeaderCharge.ObjectState   = Model.ObjectState.Added;
                        db.PurchaseOrderAmendmentHeaderCharges.Add(POHeaderCharge);
                    }
                    else
                    {
                        var footercharge = new PurchaseOrderAmendmentHeaderChargeService(_unitOfWork).Find(HeaderCharges[i].Id);
                        footercharge.Rate        = HeaderCharges[i].Rate;
                        footercharge.Amount      = HeaderCharges[i].Amount;
                        footercharge.ObjectState = Model.ObjectState.Modified;
                        db.PurchaseOrderAmendmentHeaderCharges.Add(footercharge);
                    }
                }


                try
                {
                    PurchaseOrderAmendmentDocEvents.onWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
                }
                catch (Exception ex)
                {
                    string message = _exception.HandleException(ex);
                    TempData["CSEXC"] += message;
                    EventException     = true;
                }

                try
                {
                    if (EventException)
                    {
                        throw new Exception();
                    }
                    db.SaveChanges();
                    //_unitOfWork.Save();
                }

                catch (Exception ex)
                {
                    string message = _exception.HandleException(ex);
                    TempData["CSEXC"] += message;
                    PrepareViewBag(vm.DocTypeId);
                    ViewBag.Mode = "Add";
                    return(View("Create", vm));
                }

                try
                {
                    PurchaseOrderAmendmentDocEvents.afterWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
                }
                catch (Exception ex)
                {
                    string message = _exception.HandleException(ex);
                    TempData["CSEXC"] += message;
                }

                LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
                {
                    DocTypeId    = pt.DocTypeId,
                    DocId        = pt.PurchaseOrderAmendmentHeaderId,
                    ActivityType = (int)ActivityTypeContants.WizardCreate,
                    DocNo        = pt.DocNo,
                    DocDate      = pt.DocDate,
                    DocStatus    = pt.Status,
                }));

                Session.Remove("RateAmendmentWizardOrders");

                return(RedirectToAction("Index", "PurchaseOrderAmendmentHeader", new { id = pt.DocTypeId }).Success("Data saved Successfully"));
            }
            PrepareViewBag(vm.DocTypeId);
            ViewBag.Mode = "Add";
            return(View("Create", vm));
        }
示例#3
0
        public ActionResult ConfirmedPurchaseOrders(List <PurchaseOrderAmendmentWizardViewModel> ConfirmedList, int DocTypeId, string UserRemark)
        {
            //System.Web.HttpContext.Current.Session["RateAmendmentWizardOrders"] = ConfirmedList;
            //return Json(new { Success = "URL", Data = "/PurchaseOrderRateAmendmentWizard/Create/" + DocTypeId }, JsonRequestBehavior.AllowGet);

            if (ConfirmedList.Count() > 0 && ConfirmedList.GroupBy(m => m.SupplierId).Count() > 1)
            {
                return(Json(new { Success = false, Data = " Multiple Headers are selected. " }, JsonRequestBehavior.AllowGet));
            }
            else if (ConfirmedList.Count() == 0)
            {
                return(Json(new { Success = false, Data = " No Records are selected. " }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
                int SiteId     = (int)System.Web.HttpContext.Current.Session["SiteId"];

                bool BeforeSave = true;
                int  Serial     = 1;
                Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();

                try
                {
                    BeforeSave = PurchaseOrderAmendmentDocEvents.beforeWizardSaveEvent(this, new PurchaseEventArgs(0), ref db);
                }
                catch (Exception ex)
                {
                    string message = _exception.HandleException(ex);
                    return(Json(new { Success = false, Data = message }, JsonRequestBehavior.AllowGet));
                }


                if (!BeforeSave)
                {
                    TempData["CSEXC"] += "Failed validation before save";
                }


                int Cnt = 0;
                int Sr  = 0;

                List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
                List <LineChargeViewModel>   LineCharges   = new List <LineChargeViewModel>();
                int  pk = 0;
                bool HeaderChargeEdit = false;



                PurchaseOrderSetting Settings = new PurchaseOrderSettingService(_unitOfWork).GetPurchaseOrderSettingForDocument(DocTypeId, DivisionId, SiteId);

                int?MaxLineId   = 0;
                int PersonCount = 0;
                if (!Settings.CalculationId.HasValue)
                {
                    throw new Exception("Calculation not configured in Purchase order settings");
                }

                int CalculationId = Settings.CalculationId ?? 0;

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


                if (ModelState.IsValid && BeforeSave && !EventException)
                {
                    PurchaseOrderAmendmentHeader pt = new PurchaseOrderAmendmentHeader();

                    //Getting Settings
                    pt.SiteId     = SiteId;
                    pt.SupplierId = ConfirmedList.FirstOrDefault().SupplierId;
                    pt.DivisionId = DivisionId;
                    pt.DocTypeId  = DocTypeId;
                    pt.DocDate    = DateTime.Now;
                    pt.DocNo      = new DocumentTypeService(_unitOfWork).FGetNewDocNo("DocNo", ConfigurationManager.AppSettings["DataBaseSchema"] + ".PurchaseOrderAmendmentHeaders", pt.DocTypeId, pt.DocDate, pt.DivisionId, pt.SiteId);


                    pt.Status = (int)StatusConstants.Drafted;

                    _PurchaseOrderAmendmentHeaderService.Create(pt, User.Identity.Name);

                    var SelectedPurchaseOrders = ConfirmedList;

                    var PurchaseOrderLineIds = SelectedPurchaseOrders.Select(m => m.PurchaseOrderLineId).ToArray();

                    var PurchaseOrderBalanceRecords = (from p in db.ViewPurchaseOrderBalanceForInvoice
                                                       where PurchaseOrderLineIds.Contains(p.PurchaseOrderLineId)
                                                       select p).AsNoTracking().ToList();

                    var PurchaseOrderRecords = (from p in db.PurchaseOrderLine
                                                where PurchaseOrderLineIds.Contains(p.PurchaseOrderLineId)
                                                select p).AsNoTracking().ToList();

                    foreach (var item in SelectedPurchaseOrders)
                    {
                        PurchaseOrderLine orderline = PurchaseOrderRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault();
                        var balorderline            = PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault();

                        if (item.Rate - PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().Rate != 0)
                        {
                            PurchaseOrderRateAmendmentLine line = new PurchaseOrderRateAmendmentLine();

                            line.PurchaseOrderAmendmentHeaderId = pt.PurchaseOrderAmendmentHeaderId;
                            line.PurchaseOrderLineId            = item.PurchaseOrderLineId;
                            line.Qty               = PurchaseOrderBalanceRecords.Where(m => m.PurchaseOrderLineId == item.PurchaseOrderLineId).FirstOrDefault().BalanceQty;
                            line.AmendedRate       = item.Rate;
                            line.Rate              = line.AmendedRate - balorderline.Rate;
                            line.Amount            = balorderline.BalanceQty * orderline.UnitConversionMultiplier * line.Rate;
                            line.PurchaseOrderRate = balorderline.Rate;
                            line.Sr = Serial++;
                            line.PurchaseOrderRateAmendmentLineId = pk;
                            line.CreatedDate  = DateTime.Now;
                            line.ModifiedDate = DateTime.Now;
                            line.CreatedBy    = User.Identity.Name;
                            line.ModifiedBy   = User.Identity.Name;
                            LineStatus.Add(line.PurchaseOrderLineId, line.Rate);

                            line.ObjectState = Model.ObjectState.Added;
                            db.PurchaseOrderRateAmendmentLine.Add(line);

                            if (Settings.CalculationId.HasValue)
                            {
                                LineList.Add(new LineDetailListViewModel {
                                    Amount = line.Amount, Rate = line.Rate, LineTableId = line.PurchaseOrderRateAmendmentLineId, HeaderTableId = pt.PurchaseOrderAmendmentHeaderId, PersonID = pt.SupplierId, DealQty = orderline.DealQty
                                });
                            }
                            pk++;
                            Cnt = Cnt + 1;
                        }
                    }

                    new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseRateOnAmendmentMultiple(LineStatus, pt.DocDate, ref db);


                    new ChargesCalculationService(_unitOfWork).CalculateCharges(LineList, pt.PurchaseOrderAmendmentHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.PurchaseOrderAmendmentHeaderCharges", "Web.PurchaseOrderRateAmendmentLineCharges", out PersonCount, pt.DocTypeId, pt.SiteId, pt.DivisionId);

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


                    //Saving Header charges
                    for (int i = 0; i < HeaderCharges.Count(); i++)
                    {
                        if (!HeaderChargeEdit)
                        {
                            PurchaseOrderAmendmentHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, PurchaseOrderAmendmentHeaderCharge>(HeaderCharges[i]);
                            POHeaderCharge.HeaderTableId = pt.PurchaseOrderAmendmentHeaderId;
                            POHeaderCharge.PersonID      = pt.SupplierId;
                            POHeaderCharge.ObjectState   = Model.ObjectState.Added;
                            db.PurchaseOrderAmendmentHeaderCharges.Add(POHeaderCharge);
                        }
                        else
                        {
                            var footercharge = new PurchaseOrderAmendmentHeaderChargeService(_unitOfWork).Find(HeaderCharges[i].Id);
                            footercharge.Rate        = HeaderCharges[i].Rate;
                            footercharge.Amount      = HeaderCharges[i].Amount;
                            footercharge.ObjectState = Model.ObjectState.Modified;
                            db.PurchaseOrderAmendmentHeaderCharges.Add(footercharge);
                        }
                    }


                    try
                    {
                        PurchaseOrderAmendmentDocEvents.onWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
                    }
                    catch (Exception ex)
                    {
                        string message = _exception.HandleException(ex);
                        TempData["CSEXC"] += message;
                        EventException     = true;
                    }

                    try
                    {
                        if (EventException)
                        {
                            throw new Exception();
                        }
                        db.SaveChanges();
                        //_unitOfWork.Save();
                    }

                    catch (Exception ex)
                    {
                        string message = _exception.HandleException(ex);
                        return(Json(new { Success = false, Data = message }, JsonRequestBehavior.AllowGet));
                    }

                    try
                    {
                        PurchaseOrderAmendmentDocEvents.afterWizardSaveEvent(this, new PurchaseEventArgs(pt.PurchaseOrderAmendmentHeaderId, EventModeConstants.Add), ref db);
                    }
                    catch (Exception ex)
                    {
                        string message = _exception.HandleException(ex);
                        TempData["CSEXC"] += message;
                    }

                    LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
                    {
                        DocTypeId    = pt.DocTypeId,
                        DocId        = pt.PurchaseOrderAmendmentHeaderId,
                        ActivityType = (int)ActivityTypeContants.WizardCreate,
                        DocNo        = pt.DocNo,
                        DocDate      = pt.DocDate,
                        DocStatus    = pt.Status,
                    }));

                    return(Json(new { Success = "URL", Data = "/PurchaseOrderAmendmentHeader/Submit/" + pt.PurchaseOrderAmendmentHeaderId }, JsonRequestBehavior.AllowGet));
                }

                else
                {
                    return(Json(new { Success = false, Data = "ModelState is Invalid" }, JsonRequestBehavior.AllowGet));
                }
            }
        }
 public PurchaseOrderAmendmentHeaderCharge Add(PurchaseOrderAmendmentHeaderCharge pt)
 {
     _unitOfWork.Repository <PurchaseOrderAmendmentHeaderCharge>().Insert(pt);
     return(pt);
 }
 public void Update(PurchaseOrderAmendmentHeaderCharge pt)
 {
     pt.ObjectState = ObjectState.Modified;
     _unitOfWork.Repository <PurchaseOrderAmendmentHeaderCharge>().Update(pt);
 }
 public void Delete(PurchaseOrderAmendmentHeaderCharge pt)
 {
     _unitOfWork.Repository <PurchaseOrderAmendmentHeaderCharge>().Delete(pt);
 }
        public ActionResult _ResultsPost(PurchaseOrderAmendmentMasterDetailModel vm)
        {
            List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
            List <LineChargeViewModel>   LineCharges   = new List <LineChargeViewModel>();
            int  pk               = 0;
            int  Serial           = _PurchaseOrderRateAmendmentLineService.GetMaxSr(vm.PurchaseOrderRateAmendmentLineViewModel.FirstOrDefault().PurchaseOrderAmendmentHeaderId);
            bool HeaderChargeEdit = false;
            var  Header           = new PurchaseOrderAmendmentHeaderService(db).Find(vm.PurchaseOrderRateAmendmentLineViewModel.FirstOrDefault().PurchaseOrderAmendmentHeaderId);

            PurchaseOrderSetting Settings = new PurchaseOrderSettingService(_unitOfWork).GetPurchaseOrderSettingForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);

            int?MaxLineId = new PurchaseOrderRateAmendmentLineChargeService(_unitOfWork).GetMaxProductCharge(Header.PurchaseOrderAmendmentHeaderId, "Web.PurchaseOrderRateAmendmentLines", "PurchaseOrderAmendmentHeaderId", "PurchaseOrderRateAmendmentLineId");

            int PersonCount = 0;

            if (!Settings.CalculationId.HasValue)
            {
                throw new Exception("Calculation not configured in purchase order settings");
            }
            int CalculationId = Settings.CalculationId ?? 0;
            List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();

            Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();

            #region BeforeSave
            bool BeforeSave = true;
            try
            {
                BeforeSave = PurchaseOrderAmendmentDocEvents.beforeLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseOrderRateAmendmentLineViewModel.FirstOrDefault().PurchaseOrderAmendmentHeaderId), ref db);
            }
            catch (Exception ex)
            {
                string message = _exception.HandleException(ex);
                TempData["CSEXCL"] += message;
                EventException      = true;
            }

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

            if (ModelState.IsValid && BeforeSave && !EventException)
            {
                foreach (var item in vm.PurchaseOrderRateAmendmentLineViewModel.Where(m => (m.AmendedRate - m.PurchaseOrderRate) != 0 && m.AAmended == false))
                {
                    PurchaseOrderRateAmendmentLine line = new PurchaseOrderRateAmendmentLine();

                    line.PurchaseOrderAmendmentHeaderId = item.PurchaseOrderAmendmentHeaderId;
                    line.PurchaseOrderLineId            = item.PurchaseOrderLineId;
                    line.Qty               = item.Qty;
                    line.AmendedRate       = item.AmendedRate;
                    line.Rate              = item.AmendedRate - item.PurchaseOrderRate;
                    line.Amount            = item.DealQty * line.Rate;
                    line.PurchaseOrderRate = item.PurchaseOrderRate;
                    line.Sr           = Serial++;
                    line.CreatedDate  = DateTime.Now;
                    line.ModifiedDate = DateTime.Now;
                    line.CreatedBy    = User.Identity.Name;
                    line.ModifiedBy   = User.Identity.Name;
                    line.Remark       = item.Remark;
                    LineStatus.Add(line.PurchaseOrderLineId, line.Rate);

                    line.ObjectState = Model.ObjectState.Added;
                    db.PurchaseOrderRateAmendmentLine.Add(line);

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

                    pk++;
                }

                new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseRateOnAmendmentMultiple(LineStatus, Header.DocDate, ref db);


                new ChargesCalculationService(_unitOfWork).CalculateCharges(LineList, vm.PurchaseOrderRateAmendmentLineViewModel.FirstOrDefault().PurchaseOrderAmendmentHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.PurchaseOrderAmendmentHeaderCharges", "Web.PurchaseOrderRateAmendmentLineCharges", out PersonCount, Header.DocTypeId, Header.SiteId, Header.DivisionId);

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


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


                try
                {
                    PurchaseOrderAmendmentDocEvents.onLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseOrderRateAmendmentLineViewModel.FirstOrDefault().PurchaseOrderAmendmentHeaderId), 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("_Results", vm));
                }

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

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

                return(Json(new { success = true }));
            }
            return(PartialView("_Results", vm));
        }