public ActionResult List(LoginFilter filter) { var data = Login.Find(UserID, Employee.ID, Employee.BussinessID, "", filter, true); if (Request.IsAjaxRequest()) { return(Json(new { result = true, html = RenderPartialViewToString(Views.ListPartial, data) }, JsonRequestBehavior.AllowGet)); } return(View(Views.List, data)); }
public static LoginList Find(int userID, int employeeID, int bussinessID, string message = "", LoginFilter filter = null, bool log = false) { QueryOutput queryResult; var conditions = new List <string>(); if (filter != null) { if (filter.EmployeeID.HasValue) { conditions.Add(String.Format("and e.ID = {0}", filter.EmployeeID.DbValue())); } if (!String.IsNullOrEmpty(filter.Username)) { conditions.Add(String.Format("and l.Username like N'%{0}%'", filter.Username)); } } var result = new LoginList(message, filter); result.Data = Query <Login>(new DbQuery(userID, employeeID, DbAction.Login.View, String.Format(@"select top 100 l.*, e.Name as [EmployeeName] from Login l left join Employee e on l.EmployeeID = e.ID where l.Status = 'active' and l.BussinessID = {0} {1} order by l.Username", bussinessID, String.Join(" ", conditions)), log), out queryResult); return(result); }
public LoginList(string message = "", LoginFilter filter = null) { Filter = filter != null ? filter : new LoginFilter(); Message = message; }