예제 #1
0
        public ActionResult Index(FormCollection collection)
        {
            string   Departmentt   = collection["Department"];
            string   WorkLocationn = collection["WorkLocation"];
            string   fromdatee     = collection["FromDate"];
            string   todatee       = collection["ToDate"];
            long?    Department    = null;
            long?    Work_Location = null;
            DateTime?FromDate      = null;
            DateTime?ToDate        = null;

            if (Departmentt != "")
            {
                Department = Convert.ToInt64(collection["Department"]);
            }
            if (WorkLocationn != "")
            {
                Work_Location = Convert.ToInt64(collection["WorkLocation"]);
            }
            if (fromdatee != "")
            {
                FromDate = Convert.ToDateTime(collection["FromDate"]);
            }
            if (todatee != "")
            {
                ToDate = Convert.ToDateTime(collection["ToDate"]);
            }
            //long? Department = Convert.ToInt64(collection["Department"]);
            //long? Work_Location = Convert.ToInt64(collection["WorkLocation"]);
            //DateTime? FromDate = Convert.ToDateTime(collection["FromDate"]);
            //DateTime? ToDate = Convert.ToDateTime(collection["ToDate"]);

            if (FromDate != null && ToDate == null)
            {
                ViewBag.EmployeeReportStatus = "please enter ToDate!";
                ViewBag.departments          = ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
                ViewBag.WorkLocation         = db.WorkLocationMaster;
                return(View());
            }
            if (FromDate == null && ToDate != null)
            {
                ViewBag.EmployeeReportStatus = "please enter FromDate!";
                ViewBag.departments          = ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
                ViewBag.WorkLocation         = db.WorkLocationMaster;
                return(View());
            }
            if (Department == null && Work_Location == null && FromDate == null && ToDate == null)
            {
                ViewBag.EmployeeReportStatus = "Please enter anyone option!";
                ViewBag.departments          = ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
                ViewBag.WorkLocation         = db.WorkLocationMaster;
                return(View());
            }

            var modeldata = db.EmployeeReport(Department, Work_Location, FromDate, ToDate).ToList();

            TempData["Data"]     = modeldata;
            ViewBag.departments  = ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
            ViewBag.WorkLocation = db.WorkLocationMaster;
            ViewBag.departments  = ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
            ViewBag.WorkLocation = db.WorkLocationMaster;
            return(View(modeldata));
        }