public static DataTable SearchRecordDB(MISManager manager) { //string queryText = string.Format("Select * from users where UserID = {0} or FirstName LIKE '%{1}%' " + // "or LastName LIKE '%{2}%' or UserName LIKE '%{3}%' or RoleID = {4} ", // manager.UserId, manager.FirstName, manager.LastName, manager.UserName, manager.RoleId); string query = " Select * from users where "; if (manager.UserId != 0) { query += string.Format(" UserID = {0} ", manager.UserId); } else if (!string.IsNullOrEmpty(manager.FirstName)) { query += string.Format(" FirstName LIKE '%{0}%' ", manager.FirstName); } else if (!string.IsNullOrEmpty(manager.LastName)) { query += string.Format(" LastName LIKE '%{0}%' ", manager.LastName); } else if (!string.IsNullOrEmpty(manager.UserName)) { query += string.Format(" UserName LIKE '%{0}%' ", manager.UserName); } else if (manager.RoleId != 0) { query += string.Format(" RoleID = '{0}' ", manager.RoleId); } return(MISManagerDB.ExecuteReaderQuery(query)); }
public static DataTable ReadDataDB() { string queryText = String.Format("Select * from users"); return(MISManagerDB.ExecuteReaderQuery(queryText)); }