public FisheryRemuneration GetFisheryRemuneration()
{
FisheryRemuneration fisheryRemuneration = new FisheryRemuneration();
using (SqlConnection conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
SqlCommand getFisheryRemuneration = new SqlCommand("GetFisheryRemuneration", conn);
getFisheryRemuneration.CommandType = CommandType.StoredProcedure;
SqlDataReader read = getFisheryRemuneration.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
fisheryRemuneration.FishPrice = Convert.ToDouble(read["FishPrice"]);
fisheryRemuneration.FishType = read["FishType"].ToString();
fisheryRemuneration.FishWeight = Convert.ToDouble(read["FishWeight"]);
fisheryRemuneration.SaleDate = read["SaleDate"].ToString();
}
}
}
catch (SqlException e)
{
Console.WriteLine("Fejl " + e.Message);
}
return(fisheryRemuneration);
}
}
public void SaveFisheryRemuneration(double fishPrice, string fishType, double fishWeight, string saleDate, int customerID)
{
FisheryRemuneration fisheryRemuneration = new FisheryRemuneration
{
FishPrice = fishPrice,
FishType = fishType,
FishWeight = fishWeight,
SaleDate = saleDate,
CustomerID = customerID
};
Dbcontroller.SaveFisheryRemuneration(fisheryRemuneration);
}
public void SaveFisheryRemuneration(FisheryRemuneration fisheryRemuneration)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
try
{
SqlCommand saveFisheryRemuneration = new SqlCommand("SaveFisheryRemuneration", conn);
saveFisheryRemuneration.CommandType = CommandType.StoredProcedure;
saveFisheryRemuneration.Parameters.Add(new SqlParameter("@FishPrice", fisheryRemuneration.FishPrice));
saveFisheryRemuneration.Parameters.Add(new SqlParameter("@FishType", fisheryRemuneration.FishType));
saveFisheryRemuneration.Parameters.Add(new SqlParameter("@FishWeight", fisheryRemuneration.FishWeight));
saveFisheryRemuneration.Parameters.Add(new SqlParameter("@SaleDate", fisheryRemuneration.SaleDate));
saveFisheryRemuneration.Parameters.Add(new SqlParameter("@CustomerID", fisheryRemuneration.CustomerID));
saveFisheryRemuneration.ExecuteNonQuery();
}
catch (SqlException e)
{
Console.WriteLine("Fejl" + e.Message);
}
}
}
public void AddFisheryRemuneration(FisheryRemuneration fisheryRemuneration)
{
fisheryRemunerations.Add(fisheryRemuneration);
}
