/// <summary>
/// Indsætter en ny plante i databasen.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static string InsertNewPlant(ChiliPlant data)
{
using (var connection = new SqlConnection(ConcStr))
{
try
{
var cmd = new SqlCommand("INSERT INTO Plants (Age, Name, [Desc], UserId, ImagePath, ProfileId, TemperatureSetting, LightSetting) VALUES (@Age, @Name, @Desc, @UserId, @ImagePath, @ProfileId, @TemperatureSetting, @LightSetting);", connection);
cmd.Parameters.AddWithValue("@Age", data.Age);
cmd.Parameters.AddWithValue("@Name", data.Name);
cmd.Parameters.AddWithValue("@Desc", data.Description);
cmd.Parameters.AddWithValue("@UserId", data.UserId);
cmd.Parameters.AddWithValue("@ImagePath", data.ImagePath);
cmd.Parameters.AddWithValue("@ProfileId", data.ProfileId);
cmd.Parameters.AddWithValue("@TemperatureSetting", data.TempSetting);
cmd.Parameters.AddWithValue("@LightSetting", data.LightSetting);
connection.Open();
var rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected != 1)
{
return "Error inserting Plants into database.";
}
else
{
return "Success";
}
}
catch (Exception ex)
{
return ex.Message;
}
}
}
/// <summary>
/// Henter en plante med et given id.
/// </summary>
/// <param name="plantId"></param>
/// <returns></returns>
public static ChiliPlant GetChiliPlant(int plantId)
{
using (var connection = new SqlConnection(ConcStr))
{
var cmd = new SqlCommand("SELECT * FROM Plants WHERE Id=@plantId;", connection);
cmd.Parameters.AddWithValue("@plantId", plantId);
connection.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
var plant = new ChiliPlant()
{
Id = reader.GetInt32(0),
Name = reader.GetString(2),
Description = reader.GetString(3),
Age = reader.GetInt32(1),
UserId = reader.GetInt32(4),
ProfileId = reader.GetInt32(6),
TempSetting = reader.GetInt32(7),
LightSetting = reader.GetInt32(8),
ImagePath = reader.GetString(5)
};
reader.Close();
return plant;
}
else
{
return null;
}
}
}
