public static DepartmentModel Load(int id) { using (var connection = new MySqlConnection(Settings.Default.ConnectionString)) { connection.Open(); var query = "SELECT Id, Name FROM Department WHERE Id = @id"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.Parameters.Add(new MySqlParameter("@id", MySqlDbType.Int32)); cmd.Prepare(); cmd.Parameters["@id"].Value = id; MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read() && !reader.IsDBNull(0)) { var department = new DepartmentModel { Id = reader.GetInt32("Id"), Name = reader.GetString("Name") }; return department; } else { //throw new NotSupportedArgument("Id not found"); return null; } } }
public static IEnumerable<DepartmentModel> LoadAll() { using (var connection = new MySqlConnection(Settings.Default.ConnectionString)) { connection.Open(); var query = "SELECT Id, Name FROM Department"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read() && !reader.IsDBNull(0)) { var department = new DepartmentModel { Id = reader.GetInt32("Id"), Name = reader.GetString("Name") }; yield return department; } } }
public DepartmentViewModel(DepartmentModel model) { Model = model; }