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));
}
