public List <userModel> search(userModel data) { if (BaseData.Connection.State == System.Data.ConnectionState.Closed) { BaseData.Connection.Open(); } string query = "SELECT top 20 * from users where 1=1 "; if (data.name != "") { query += " and name like '%" + data.name + "%'"; } if (data.family != "") { query += " and family like '%" + data.family + "%'"; } if (data.melli != "") { query += " and melli like '%" + data.melli + "%'"; } if (data.location != "") { query += " and location like '%" + data.location + "%'"; } if (data.id > 0) { query += " and id= " + data.id; } if (data.userType != UserType.Administrator) { query += " and user_type =" + (int)data.userType; } SqlCeCommand command = new SqlCeCommand(query, BaseData.Connection); var reader = command.ExecuteReader(); List <userModel> result = new List <userModel>(); while (reader.Read()) { result.Add(map(reader)); } BaseData.Connection.Close(); return(result); }
public userModel map(SqlCeDataReader reader) { userModel result = new userModel(); try { result.id = Convert.ToInt16(reader["id"]); result.name = reader["name"].ToString(); result.family = reader["family"].ToString(); result.userName = reader["userName"].ToString(); result.melli = reader["melli"].ToString(); result.carPelak = reader["car_pelak"].ToString(); result.address = reader["address"].ToString(); result.location = reader["location"].ToString(); result.userType = (UserType)reader["User_type"]; } catch { } return(result); }