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