public long GetDucksLeased(Ducks d) { long result = 0; try { comm.CommandText = "SELECT number_leased FROM Duck WHERE id_duck=@id_duck"; comm.Parameters.AddWithValue("id_duck", d.id_duck); comm.CommandType = CommandType.Text; connect.Open(); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { result = Convert.ToInt64(reader[0]); } return(result); } catch (Exception) { throw; } finally { if (connect != null) { connect.Close(); } } }
public int UpdateDuck(Ducks d) { try { comm.CommandText = "UPDATE Duck SET number_in_stock=@number_in_stock, number_leased=@number_leased WHERE id_duck=@id_duck"; comm.Parameters.AddWithValue("id_duck", d.id_duck); comm.Parameters.AddWithValue("number_in_stock", d.number_in_stock); comm.Parameters.AddWithValue("number_leased", d.number_leased); comm.CommandType = CommandType.Text; connect.Open(); return(comm.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (connect != null) { connect.Close(); } } }
public List <Ducks> GetAllDucks() { List <Ducks> ducks_list = new List <Ducks>(); try { comm.CommandText = "SELECT * FROM Duck"; comm.CommandType = CommandType.Text; connect.Open(); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { Ducks ducks = new Ducks() { id_duck = Convert.ToInt32(reader[0]), color = reader[1].ToString(), number_in_stock = Convert.ToInt64(reader[2]), number_leased = Convert.ToInt64(reader[3]), price = Convert.ToDecimal(reader[4]) }; ducks_list.Add(ducks); } return(ducks_list); } catch (Exception) { throw; } finally { if (connect != null) { connect.Close(); } } }