public ActionResult GetSearchPartial() { BLLLeave _leave = new BLLLeave(); SearchViewModel model = new SearchViewModel(); model.LeaveType = _leave.GetAllLeaveTypes(); return PartialView("SearchPartial", model); }
public IEnumerable<LeaveViewModel> Search(SearchViewModel model) { using(var _context = new DataContext()) { try { var result = _context.Database.SqlQuery<LeaveViewModel>("pSearchLeaves @xIDNO, @xName," + "@xLeaveTypeID, @xLeaveStatus," + "@xDateFiled, @xDateFrom, @xDateTo", new SqlParameter("@xIDNO", (object)model.IDNO ?? DBNull.Value), new SqlParameter("@xName", (object)model.Name ?? DBNull.Value), new SqlParameter("@xLeaveTypeID", (object)model.LeaveTypeID ?? DBNull.Value), new SqlParameter("@xLeaveStatus", (object)model.Status ?? DBNull.Value), new SqlParameter("@xDateFiled", model.DateFiled), new SqlParameter("@xDateFrom", model.From), new SqlParameter("@xDateTo", model.To)).ToList(); return result; } catch(Exception e) { Debug.WriteLine(e); } return null; } }
public ActionResult SummarySearch(SearchViewModel model) { BLLLeave _leave = new BLLLeave(); IEnumerable<LeaveViewModel> result = _leave.Search(model); return PartialView("SearchResultPartial", result); }
public IEnumerable<LeaveViewModel> Search(SearchViewModel model) { var minDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue; if(model.From < minDate) { model.From = minDate; } if (model.To < minDate) { model.To = minDate; } if (model.DateFiled < minDate) { model.DateFiled = minDate; } DALLeave _leave = new DALLeave(); return _leave.Search(model); }