// get_Batch_AtProduction
public List <Batch_Production> get_Batch_AtProduction()
{
List <Batch_Production> batch_prod_list = new List <Batch_Production>();
SqlConnection con = null;
try
{
con = connect("DBConnectionString");
String query = "SELECT * FROM [Batch_2020] join [BatchAtProd_2020] ON [Batch_2020].batch_id=[BatchAtProd_2020].batch_id;";
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandTimeout = 480; // enlarge T.O
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // the connection will close as reading completes
while (dr.Read())
{
Batch_Production batch = new Batch_Production();
batch.BatchID = Convert.ToInt32(dr["batch_id"]);
batch.Date = Convert.ToDateTime(dr["date"]);
batch.Tank = Convert.ToInt32(dr["tank"]);
batch.Wort_volume = Convert.ToInt32(dr["wort_volume"]);
batch.BeerType = (string)dr["beer_type"];
batch.Cast_volume = (float)dr["cast_volume"];
batch.Yeast_cycle = Convert.ToInt32(dr["yeast_cycle"]);
batch.Co2_vol = (float)dr["Co2_vol"];
batch.PitchTime = ((TimeSpan)dr["pitch_time"]).ToString(); // this will fail in case of NULL
batch.Og = (float)dr["OG"];
batch.Fg = (float)dr["FG"];
batch.Pitching_rate = (float)dr["pitching_rate"];
batch.Tank_temp = (float)dr["Temp_Tank"];
batch.Set_temp = (float)dr["Set_Temp"];
batch_prod_list.Add(batch);
}
return(batch_prod_list);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public HttpResponseMessage Put([FromBody] Batch_Production batch)
{
int numEffected = 0;
try
{
numEffected = batch.Update();
if (numEffected > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, numEffected));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public List <Batch_Production> Get()
{
Batch_Production batch = new Batch_Production();
return(batch.get_Batch());
}
