Example #1
0
        public ContractorGroup Add(ContractorGroup CTG, string userid)
        {
            var sqlQuery = @"INSERT INTO contractorGroup (IDCONTRACTORGROUP, CONTRACTORGROUPNAME, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES
                           ('" + CTG.IDCONTRACTORGROUP + @"', '" + CTG.CONTRACTORGROUPNAME + "', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
            var SID      = _db.Query <int>(sqlQuery, CTG).Single();

            CTG.SID = SID;
            return(CTG);
        }
Example #2
0
        public ContractorGroup Update(ContractorGroup CTG, string userid)
        {
            var sqlQuery =
                string.Format(@"UPDATE CONTRACTORGROUP SET IDCONTRACTORGROUP = '{0}', CONTRACTORGROUPNAME = '{1}', UPDATEBY = {2}, UPDATEDATE = '{3}' WHERE SID = {4}",
                              CTG.IDCONTRACTORGROUP, CTG.CONTRACTORGROUPNAME, Convert.ToInt32(userid), DateTime.Now, CTG.SID);

            this._db.Execute(sqlQuery, CTG);
            return(CTG);
        }
        public JsonResult Edit(ContractorGroup contractorgroup, string userid)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    CTG.Update(contractorgroup, Session["userid"].ToString());
                }
            }
            catch
            {
                return(Json("error"));
            }

            return(Json("success"));
        }
Example #4
0
        // GET: /Ir35/
        public IActionResult Index()
        {
            DayRate dayRate = new DayRate();
            //dayRate.Amount = 300;

            Contractor contractorYearly = new Contractor();

            contractorYearly.GrossPay = 0;

            //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Contractor contractorMonthly = new Contractor();

            contractorMonthly.GrossPay = 0;

            //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Contractor contractorWeekly = new Contractor();

            contractorWeekly.GrossPay = 0;

            //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            ContractorGroup contractorGroup = new ContractorGroup();

            contractorGroup.DayRateAmount = dayRate;
            contractorGroup.Yearly        = contractorYearly;
            contractorGroup.Monthly       = contractorMonthly;
            contractorGroup.Weekly        = contractorWeekly;

            /*
             * {
             *  Yearly = contractorYearly,
             *  Monthly = contractorMonthly,
             *  Weekly = contractorWeekly
             * };
             */
            return(View(contractorGroup));
        }
Example #5
0
        public IActionResult Index(ContractorGroup contractorGroup)
        {
            if (!ModelState.IsValid)
            {
                // 1st way
                //ModelState.AddModelError(string.Empty, "");

                // 2nd way
                //ModelState.AddModelError("error_summary", "Please correct the following problems:");
                //User the above with HtmlHelper.ValidationMessageCssClassName in the view

                // invalid - redisplay form with errors
                return(View(contractorGroup));
            }
            else
            {
                ModelState.Clear(); // required since writing back to same view

                DayRate    dayRate           = new DayRate();
                Contractor contractorYearly  = new Contractor();
                Contractor contractorMonthly = new Contractor();
                Contractor contractorWeekly  = new Contractor();


                ContractorGroup contractorGroup2 = new ContractorGroup();

                contractorGroup2.DayRateAmount = dayRate;
                contractorGroup2.Yearly        = contractorYearly;
                contractorGroup2.Monthly       = contractorMonthly;
                contractorGroup2.Weekly        = contractorWeekly;

                contractorGroup2.DayRateAmount.Amount = contractorGroup.DayRateAmount.Amount;

                //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                contractorGroup2.Yearly.GrossPay             = Math.Round(contractorGroup.DayRateAmount.Amount.Value * 5 * 52);
                contractorGroup2.Yearly.EmployersNi          = Math.Round(contractorGroup2.Yearly.GrossPay * (decimal)0.138);
                contractorGroup2.Yearly.EmployeesNiBandOne   = 0;
                contractorGroup2.Yearly.EmployeesNiBandTwo   = Math.Round((decimal)((50000 - 8632) * 0.12));
                contractorGroup2.Yearly.EmployeesNiBandThree = Math.Round((contractorGroup2.Yearly.GrossPay - 50000) * (decimal)0.02);
                contractorGroup2.Yearly.EmployeesNi          = contractorGroup2.Yearly.EmployeesNiBandOne +
                                                               contractorGroup2.Yearly.EmployeesNiBandTwo +
                                                               contractorGroup2.Yearly.EmployeesNiBandThree;
                contractorGroup2.Yearly.GeneralExpenses = Math.Round(contractorGroup2.Yearly.GrossPay * (decimal)0.05);
                contractorGroup2.Yearly.DeemedAmount    =
                    contractorGroup2.Yearly.GrossPay - contractorGroup2.Yearly.GeneralExpenses;
                contractorGroup2.Yearly.PayeBandOne   = 0;
                contractorGroup2.Yearly.PayeBandTwo   = Math.Round((decimal)((50000 - 12500) * 0.2));
                contractorGroup2.Yearly.PayeBandThree = Math.Round((contractorGroup2.Yearly.DeemedAmount - 50000) * (decimal)0.4);
                contractorGroup2.Yearly.Paye          = contractorGroup2.Yearly.PayeBandOne +
                                                        contractorGroup2.Yearly.PayeBandTwo +
                                                        contractorGroup2.Yearly.PayeBandThree;
                contractorGroup2.Yearly.TakeHomePay = contractorGroup2.Yearly.GrossPay -
                                                      contractorGroup2.Yearly.EmployersNi -
                                                      contractorGroup2.Yearly.EmployeesNi -
                                                      contractorGroup2.Yearly.Paye;
                contractorGroup2.Yearly.TakeHomePayPerc =
                    Math.Round((contractorGroup2.Yearly.TakeHomePay / contractorGroup2.Yearly.GrossPay) * 100);
                contractorGroup2.Yearly.TotalTaxPaid = contractorGroup2.Yearly.EmployersNi +
                                                       contractorGroup2.Yearly.EmployeesNi +
                                                       contractorGroup2.Yearly.Paye;
                contractorGroup2.Yearly.TotalTaxPaidPerc = 100 - contractorGroup2.Yearly.TakeHomePayPerc;

                //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                contractorGroup2.Monthly.GrossPay             = Math.Round((contractorGroup.DayRateAmount.Amount.Value * 5 * 52) / 12);
                contractorGroup2.Monthly.EmployersNi          = Math.Round(contractorGroup2.Monthly.GrossPay * (decimal)0.138);
                contractorGroup2.Monthly.EmployeesNiBandOne   = 0;
                contractorGroup2.Monthly.EmployeesNiBandTwo   = Math.Round(contractorGroup2.Yearly.EmployeesNiBandTwo / 12);
                contractorGroup2.Monthly.EmployeesNiBandThree = Math.Round(contractorGroup2.Yearly.EmployeesNiBandThree / 12);
                contractorGroup2.Monthly.EmployeesNi          = contractorGroup2.Monthly.EmployeesNiBandOne +
                                                                contractorGroup2.Monthly.EmployeesNiBandTwo +
                                                                contractorGroup2.Monthly.EmployeesNiBandThree;
                contractorGroup2.Monthly.GeneralExpenses = Math.Round(contractorGroup2.Monthly.GrossPay * (decimal)0.05);
                contractorGroup2.Monthly.DeemedAmount    =
                    contractorGroup2.Monthly.GrossPay - contractorGroup2.Monthly.GeneralExpenses;
                contractorGroup2.Monthly.PayeBandOne   = 0;
                contractorGroup2.Monthly.PayeBandTwo   = Math.Round(contractorGroup2.Yearly.PayeBandTwo / 12);
                contractorGroup2.Monthly.PayeBandThree = Math.Round(contractorGroup2.Yearly.PayeBandThree / 12);
                contractorGroup2.Monthly.Paye          = contractorGroup2.Monthly.PayeBandOne +
                                                         contractorGroup2.Monthly.PayeBandTwo +
                                                         contractorGroup2.Monthly.PayeBandThree;
                contractorGroup2.Monthly.TakeHomePay = contractorGroup2.Monthly.GrossPay -
                                                       contractorGroup2.Monthly.EmployersNi -
                                                       contractorGroup2.Monthly.EmployeesNi -
                                                       contractorGroup2.Monthly.Paye;
                contractorGroup2.Monthly.TakeHomePayPerc =
                    Math.Round((contractorGroup2.Monthly.TakeHomePay / contractorGroup2.Monthly.GrossPay) * 100);
                contractorGroup2.Monthly.TotalTaxPaid = contractorGroup2.Monthly.EmployersNi +
                                                        contractorGroup2.Monthly.EmployeesNi +
                                                        contractorGroup2.Monthly.Paye;
                contractorGroup2.Monthly.TotalTaxPaidPerc = 100 - contractorGroup2.Monthly.TakeHomePayPerc;

                //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                contractorGroup2.Weekly.GrossPay             = Math.Round((contractorGroup.DayRateAmount.Amount.Value * 5 * 52) / 52);
                contractorGroup2.Weekly.EmployersNi          = Math.Round(contractorGroup2.Weekly.GrossPay * (decimal)0.138);
                contractorGroup2.Weekly.EmployeesNiBandOne   = 0;
                contractorGroup2.Weekly.EmployeesNiBandTwo   = Math.Round(contractorGroup2.Yearly.EmployeesNiBandTwo / 52);
                contractorGroup2.Weekly.EmployeesNiBandThree = Math.Round(contractorGroup2.Yearly.EmployeesNiBandThree / 52);
                contractorGroup2.Weekly.EmployeesNi          = contractorGroup2.Weekly.EmployeesNiBandOne +
                                                               contractorGroup2.Weekly.EmployeesNiBandTwo +
                                                               contractorGroup2.Weekly.EmployeesNiBandThree;
                contractorGroup2.Weekly.GeneralExpenses = Math.Round(contractorGroup2.Weekly.GrossPay * (decimal)0.05);
                contractorGroup2.Weekly.DeemedAmount    =
                    contractorGroup2.Weekly.GrossPay - contractorGroup2.Weekly.GeneralExpenses;
                contractorGroup2.Weekly.PayeBandOne   = 0;
                contractorGroup2.Weekly.PayeBandTwo   = Math.Round(contractorGroup2.Yearly.PayeBandTwo / 52);
                contractorGroup2.Weekly.PayeBandThree = Math.Round(contractorGroup2.Yearly.PayeBandThree / 52);
                contractorGroup2.Weekly.Paye          = contractorGroup2.Weekly.PayeBandOne +
                                                        contractorGroup2.Weekly.PayeBandTwo +
                                                        contractorGroup2.Weekly.PayeBandThree;
                contractorGroup2.Weekly.TakeHomePay = contractorGroup2.Weekly.GrossPay -
                                                      contractorGroup2.Weekly.EmployersNi -
                                                      contractorGroup2.Weekly.EmployeesNi -
                                                      contractorGroup2.Weekly.Paye;
                contractorGroup2.Weekly.TakeHomePayPerc =
                    Math.Round((contractorGroup2.Weekly.TakeHomePay / contractorGroup2.Weekly.GrossPay) * 100);
                contractorGroup2.Weekly.TotalTaxPaid = contractorGroup2.Weekly.EmployersNi +
                                                       contractorGroup2.Weekly.EmployeesNi +
                                                       contractorGroup2.Weekly.Paye;
                contractorGroup2.Weekly.TotalTaxPaidPerc = 100 - contractorGroup2.Weekly.TakeHomePayPerc;

                return(View(contractorGroup2));
            }
        }