public ActionResult Index(FormCollection collection)
{
string Designationn = collection["Designation"];
string Gradee = collection["Grade"];
string statuss = collection["status"];
string fromdatee = collection["FromDate"];
string todatee = collection["ToDate"];
long? Designation = null;
long? Grade = null;
int? status = null;
DateTime?FromDate = null;
DateTime?ToDate = null;
if (Designationn != "")
{
Designation = Convert.ToInt64(collection["Designation"]);
}
if (Gradee != "")
{
Grade = Convert.ToInt64(collection["Grade"]);
}
if (statuss != "")
{
status = Convert.ToInt32(collection["status"]);
}
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;
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;
return(View());
}
if (Designation == null && Grade == null && status == 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;
return(View());
}
var modeldata = db.TravelApplicationReport(FromDate, ToDate, Grade, Designation, status).ToList();
TempData["Data"] = modeldata;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Grade = db.HRMS_CATEGORY_GRADE;
return(View(modeldata));
}
