internal static TrialGroup GetTrialGroup(int trialgroupid)
{
TrialGroup trialGroup = null;
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
connection.Open();
SqlCommand cmdGetCustomers = new SqlCommand("select * from TrialGroup, Crop WHERE TrialGroupID = @TrialGroupId AND Crop.CropID = TrialGroup.CropID", connection);
cmdGetCustomers.Parameters.Add(new SqlParameter("@TrialGroupId", trialgroupid));
SqlDataReader reader = cmdGetCustomers.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
trialGroup = new TrialGroup(reader.GetInt32(0), new Crop(reader.GetString(6)), reader.GetInt32(3), reader.GetString(4), null);
}
}
}
catch (SqlException e)
{
}
finally
{
connection.Close();
connection.Dispose();
}
}
return(trialGroup);
}
public IHttpActionResult PutTrialGroup(int id, TrialGroup trialGroup)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != trialGroup.TrialGroupID)
{
return(BadRequest());
}
db.Entry(trialGroup).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TrialGroupExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetTrialGroup(int id)
{
TrialGroup trialGroup = db.TrialGroups.Find(id);
if (trialGroup == null)
{
return(NotFound());
}
return(Ok(trialGroup));
}
public IHttpActionResult PostTrialGroup(TrialGroup trialGroup)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.TrialGroups.Add(trialGroup);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = trialGroup.TrialGroupID }, trialGroup));
}
public IHttpActionResult DeleteTrialGroup(int id)
{
TrialGroup trialGroup = db.TrialGroups.Find(id);
if (trialGroup == null)
{
return(NotFound());
}
db.TrialGroups.Remove(trialGroup);
db.SaveChanges();
return(Ok(trialGroup));
}
