private PayDueListViewModel SaveGrid1(PayrollDueVM grid1, IEnumerable <KeyValuePair <string, ModelState> > state, Payrolls record)
        {
            //  List<Error> errors = new List<Error>();
            // List<PayrollDue> ListPayDue = new List<PayrollDue>();

            var payDueList = new PayDueListViewModel();

            payDueList.payDueList = new List <PayrollDue>();



            // Deleted
            if (grid1.deleted != null)
            {
                foreach (PayrollDueViewModel model in grid1.deleted)
                {
                    var payrolldeu = new PayrollDue
                    {
                        Id = model.Id
                    };


                    _hrUnitOfWork.PayrollRepository.Remove(payrolldeu);
                }
            }

            // Exclude delete models from sever side validations
            if (ServerValidationEnabled)
            {
                var modified = Models.Utils.GetModifiedRows(state.Where(a => !a.Key.Contains("deleted")));
                if (modified.Count > 0)
                {
                    payDueList.errors = _hrUnitOfWork.CompanyRepository.Check(new CheckParm
                    {
                        CompanyId  = CompanyId,
                        ObjectName = "PayrollDue",
                        Columns    = Models.Utils.GetModifiedRows(state.Where(a => !a.Key.Contains("deleted"))),
                        Culture    = Language
                    });

                    if (payDueList.errors.Count() > 0)
                    {
                        return(payDueList);
                    }
                }
            }

            // updated records
            if (grid1.updated != null)
            {
                foreach (PayrollDueViewModel model in grid1.updated)
                {
                    var payrolldue = new PayrollDue();
                    AutoMapper(new Models.AutoMapperParm {
                        Destination = payrolldue, Source = model, Transtype = TransType.Update
                    });
                    _hrUnitOfWork.PayrollRepository.Attach(payrolldue);
                    _hrUnitOfWork.PayrollRepository.Entry(payrolldue).State = EntityState.Modified;
                }
            }

            // inserted records
            if (grid1.inserted != null)
            {
                foreach (PayrollDueViewModel model in grid1.inserted)
                {
                    var payrolldue = new PayrollDue();
                    AutoMapper(new Models.AutoMapperParm {
                        Destination = payrolldue, Source = model, Transtype = TransType.Insert
                    });
                    payrolldue.Payroll = record;
                    _hrUnitOfWork.PayrollRepository.Add(payrolldue);
                    payDueList.payDueList.Add(payrolldue);
                }
            }

            return(payDueList);
        }
        public ActionResult Details(PayrollFormViewModel model, OptionsViewModel moreInfo, PayrollDueVM grid1, SubPeriodsVM grid2)
        {
            List <Error> errors = new List <Error>();

            if (ModelState.IsValid)
            {
                if (ServerValidationEnabled)
                {
                    errors = _hrUnitOfWork.SiteRepository.CheckForm(new CheckParm
                    {
                        CompanyId    = CompanyId,
                        ObjectName   = "Payroll",
                        TableName    = "Payrolls",
                        ParentColumn = "CompanyId",
                        Columns      = Models.Utils.GetColumnViews(ModelState.Where(a => !a.Key.Contains('.'))),
                        Culture      = Language
                    });

                    if (errors.Count() > 0)
                    {
                        foreach (var e in errors)
                        {
                            foreach (var errorMsg in e.errors)
                            {
                                ModelState.AddModelError(errorMsg.field, errorMsg.message);
                            }
                        }

                        return(Json(Models.Utils.ParseFormErrors(ModelState)));
                    }
                }

                Payrolls record;
                var      PeriodIdLocal = _hrUnitOfWork.Repository <PeriodName>().Where(a => a.Id == model.PeriodId).Select(a => new { Local = a.IsLocal }).FirstOrDefault();

                //insert
                if (model.Id == 0)
                {
                    record = new Payrolls();
                    AutoMapper(new Models.AutoMapperParm
                    {
                        Destination = record,
                        Source      = model,
                        ObjectName  = "Payroll",
                        Options     = moreInfo,
                        Transtype   = TransType.Insert
                    });
                    record.CreatedUser = UserName;
                    record.CreatedTime = DateTime.Now;
                    record.IsLocal     = PeriodIdLocal.Local;
                    record.CompanyId   = record.IsLocal ? CompanyId : (int?)null;
                    _hrUnitOfWork.PayrollRepository.Add(record);
                }
                //update
                else
                {
                    record = _hrUnitOfWork.Repository <Payrolls>().FirstOrDefault(a => a.Id == model.Id);
                    AutoMapper(new Models.AutoMapperParm
                    {
                        Destination = record,
                        Source      = model,
                        ObjectName  = "Payroll",
                        Options     = moreInfo,
                        Transtype   = TransType.Update
                    });
                    record.ModifiedTime = DateTime.Now;
                    record.ModifiedUser = UserName;
                    record.IsLocal      = PeriodIdLocal.Local;
                    record.CompanyId    = record.IsLocal ? CompanyId : (int?)null;
                    _hrUnitOfWork.PayrollRepository.Attach(record);
                    _hrUnitOfWork.PayrollRepository.Entry(record).State = EntityState.Modified;
                }

                // Save grid1
                var payDueList = new PayDueListViewModel();
                payDueList = SaveGrid1(grid1, ModelState.Where(a => a.Key.Contains("grid")), record);
                errors     = payDueList.errors;
                errors     = SaveGrid2(grid2, payDueList.payDueList, ModelState.Where(a => a.Key.Contains("grid")), record, model.Period.GetValueOrDefault());

                if (errors.Count > 0)
                {
                    return(Json(errors.First().errors.First().message));
                }

                errors = SaveChanges(Language);

                var message = "OK";
                if (errors.Count > 0)
                {
                    message = errors.First().errors.First().message;
                }

                return(Json(message));
            }

            return(Json(Models.Utils.ParseFormErrors(ModelState)));
        }