internal object InsertUnit(Trainingsunit trainingsunit, int owner)
{
using (IDbConnection connection = provider.GetConnection())
{
return(trainingsDataRepository.InsertUnit(connection, trainingsunit, owner));
}
}
public object InsertUnit(IDbConnection connection, Trainingsunit trainingsunit, int owner)
{
string sql = @"INSERT INTO trainingunit (name, description, owner ) VALUES (@name, @description, @owner)";
connection.Query <Trainingsunit>(sql, new { name = trainingsunit.Name, description = trainingsunit.Description, owner = owner });
var id = connection.Query <Trainingsunit>("SELECT ID FROM trainingunit WHERE name = @name AND description = @description AND owner = @owner", new { name = trainingsunit.Name, description = trainingsunit.Description, owner = owner });
return(connection.Query <Trainingsunit>("SELECT * FROM trainingunit WHERE ID = @id", new { id = id }));
}
private void Button_Click_SaveExercise(object sender, RoutedEventArgs e)
{
trainingRestClient = new TrainingRestClient(currentUser.Id);
int parent = -1;
if (chkEnableUnit.IsChecked == true)
{
if (radioButtonNewUnit.IsChecked == true)
{
Trainingsunit trainingsunit = new Trainingsunit();
if (radioButtonPrivate.IsChecked == true)
{
trainingsunit.Accessibility = "private";
}
else
{
trainingsunit.Accessibility = "public";
}
trainingsunit.Description = textBoxDescripUnit.Text;
trainingsunit.Name = textBoxNameUnit.Text;
trainingsunit = trainingRestClient.SaveUnit(trainingsunit);
}
else if (radioButtonExisting.IsChecked == true)
{
int id = (int)comboBoxUnits.SelectedValue;
parent = id;
}
}
if (trainingRestClient.SaveExercise(GetExercise(parent)))
{
if (MessageBoxResult.OK == MessageBox.Show("Übung wurde erfolgreich gespeichert!"))
{
var images = canvas.Children.OfType <Canvas>().ToList();
foreach (var image in images)
{
canvas.Children.Remove(image);
}
textboxName.Text = "";
textboxProcedure.Text = "";
textboxType.Text = "";
}
}
}
internal Trainingsunit SaveUnit(Trainingsunit trainingsunit)
{
try
{
var request = new RestRequest("training/insertunit", Method.POST);
var json = JsonConvert.SerializeObject(trainingsunit);
request.AddParameter("text/json", json, ParameterType.RequestBody);
IRestResponse response = client.Execute <Trainingsunit>(request);
Trainingsunit unit = JsonConvert.DeserializeObject <Trainingsunit>(response.Content);
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
return(unit);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(new Trainingsunit());
}
public IHttpActionResult InsertUnit([FromBody] Trainingsunit trainingsunit)
{
return(Ok(trainingService.InsertUnit(trainingsunit, trainingsunit.Owner)));
}
