public JsonResult GetEmployeeForPayroll()
        {
            objpayrollbll = new Payroll_BLL();
            DataTable dtemplist  = objpayrollbll.GetEmployeeForPayroll();
            var       emplist    = JsonConvert.SerializeObject(dtemplist);
            var       deserilize = JsonConvert.DeserializeObject(emplist);

            //objDesignationBLL.Dispose();
            return(Json(new { Designation = emplist }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetPayrollMultiple(int[] attendanceidarray, int year, int month)
        {
            try
            {
                General_Holiday_Property objholiday = new General_Holiday_Property();
                Payroll_Property         payroll    = new Payroll_Property();
                objholiday.holiday_month = month;
                objholiday.holiday_year  = year;
                Holidays_BLL objholidaybll = new Holidays_BLL(objholiday);
                payroll.GeneralHolidays = objholidaybll.SelectOne();
                var startDate = new DateTime(year, month, 1);
                var endDate   = startDate.AddMonths(1).AddDays(-1);
                payroll.fromDate           = startDate;
                payroll.ToDate             = endDate;
                payroll.attendanceidstring = string.Join(",", attendanceidarray);


                objpayrollbll = new Payroll_BLL(payroll);
                DateTime Firstdate = payroll.fromDate;
                DateTime EndDate   = payroll.ToDate;
                int      TotalDays = Convert.ToInt32((EndDate - Firstdate).TotalDays);

                //Since salary is calcualted on 30 days we are making days 30 if any month have less then 30 days
                if (TotalDays < 30)
                {
                    TotalDays = 30;
                }

                int businessdays = countWeekDays(Firstdate, EndDate) - (payroll.GeneralHolidays);

                int regularHolidays = (TotalDays - businessdays) + payroll.GeneralHolidays;

                payroll.totalDays       = TotalDays;
                payroll.businessDays    = businessdays;
                payroll.regularHolidays = regularHolidays;



                var payrolllst = JsonConvert.SerializeObject(objpayrollbll.GetDetailsForPayrollMultiple());
                int daysWorked = payroll.daysWorked;
                //ViewBag.payrollmultiple=
                //return Json(new { success = true, statuscode = 500, data = payrolllst }, JsonRequestBehavior.AllowGet);
                ViewBag.FooObj = payrolllst;
                return(View());
            }
            catch (Exception ex)
            {
                return(View());
                //return Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet);
            }
        }
        public JsonResult CalculateResult(Payroll_Property payroll)
        {
            try
            {
                General_Holiday_Property objholiday = new General_Holiday_Property();
                objholiday.holiday_month = payroll.month;
                objholiday.holiday_year  = payroll.year;
                Holidays_BLL objholidaybll = new Holidays_BLL(objholiday);
                payroll.GeneralHolidays = objholidaybll.SelectOne();
                var startDate = new DateTime(payroll.year, payroll.month, 1);
                var endDate   = startDate.AddMonths(1).AddDays(-1);
                payroll.fromDate = startDate;
                payroll.ToDate   = endDate;



                objpayrollbll = new Payroll_BLL(payroll);
                DateTime Firstdate    = payroll.fromDate;
                DateTime EndDate      = payroll.ToDate;
                int      TotalDays    = Convert.ToInt32((EndDate - Firstdate).TotalDays);
                int      businessdays = countWeekDays(Firstdate, EndDate) - (payroll.GeneralHolidays);

                int regularHolidays = (TotalDays - businessdays) + payroll.GeneralHolidays;

                payroll.totalDays       = TotalDays;
                payroll.businessDays    = businessdays;
                payroll.regularHolidays = regularHolidays;



                var payrolllst = JsonConvert.SerializeObject(objpayrollbll.GetDetailsForPayroll());
                int daysWorked = payroll.daysWorked;
                return(Json(new { success = true, statuscode = 500, data = payrolllst }, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                return(Json(new { success = false, statuscode = 500, msg = "Please Enter According To Instructions" }, JsonRequestBehavior.AllowGet));
            }
        }