public ActionResult Index(FormCollection collection) { string Designationn = collection["Designation"]; string Gradee = collection["Grade"]; string Travel_Purposee = collection["Travel_Purpose"]; string fromdatee = collection["FromDate"]; string todatee = collection["ToDate"]; long? Designation = null; long? Grade = null; long? Travel_Purpose = null; DateTime?FromDate = null; DateTime?ToDate = null; if (Designationn != "") { Designation = Convert.ToInt64(collection["Designation"]); } if (Gradee != "") { Grade = Convert.ToInt64(collection["Grade"]); } if (Travel_Purposee != "") { Travel_Purpose = Convert.ToInt32(collection["Travel_Purpose"]); } if (fromdatee != "") { FromDate = Convert.ToDateTime(collection["FromDate"]); } if (todatee != "") { ToDate = Convert.ToDateTime(collection["ToDate"]); } if (FromDate != null && ToDate == null) { ViewBag.EmployeeReportStatus = "please enter ToDate!"; ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true); ViewBag.Grade = db.HRMS_CATEGORY_GRADE; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); return(View()); } if (FromDate == null && ToDate != null) { ViewBag.EmployeeReportStatus = "please enter FromDate!"; ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true); ViewBag.Grade = db.HRMS_CATEGORY_GRADE; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); return(View()); } if (Designation == null && Grade == null && Travel_Purpose == null && FromDate == null && ToDate == null) { ViewBag.EmployeeReportStatus = "Please enter anyone option!"; ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true); ViewBag.Grade = db.HRMS_CATEGORY_GRADE; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); return(View()); } var modeldata = db.TravelApplicationExpanseReport(FromDate, ToDate, Travel_Purpose, Grade, Designation).ToList(); TempData["Data"] = modeldata; ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true); ViewBag.Grade = db.HRMS_CATEGORY_GRADE; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); return(View(modeldata)); }