public void InsertExercise(IDbConnection connection, Trainingsexercise trainingsexercise, int owner)
{
connection.Query <Trainingsexercise>("INSERT INTO trainingexercise(name, process, accessibility, type, image, owner) VALUES(@name, @process, @accessibility, @type, @image, @owner)", new { name = trainingsexercise.Name, process = trainingsexercise.Process, accessibility = trainingsexercise.Accessibility, type = trainingsexercise.Type, image = trainingsexercise.ImagePath, owner = trainingsexercise.Owner }).FirstOrDefault();
var idexercise = connection.Query <Trainingsexercise>("SELECT ID FROM trainingexercise WHERE name = @name AND process = @process AND accessiblity = @accessibility AND type = @type AND owner = @owner", new { name = trainingsexercise.Name, process = trainingsexercise.Process, accessibility = trainingsexercise.Accessibility, type = trainingsexercise.Type, owner = trainingsexercise.Owner });
connection.Query <Trainingsexercise>("INSERT INTO trainingexercise(ID_unit, ID_exercise) VALUES(@idunit, @idexercise)", new { idunit = trainingsexercise.Parent, idexercise = idexercise });
}
public CommunityViewModel(User user)
{
currentUser = user;
selectedTrainExercise = new Trainingsexercise();
SelectedTrainObject = new Trainingsobject();
trainingRestClient = new TrainingRestClient(user.Id);
Refresh();
}
internal bool InsertExercise(Trainingsexercise trainingsexercise, int owner)
{
string name = trainingsexercise.Name + ".jpeg";
name = name.Replace(" ", string.Empty);
using (MemoryStream stream = new MemoryStream(trainingsexercise.Image))
{
Image img = System.Drawing.Image.FromStream(stream);
img.Save(@"C:\Users\Christina\Documents\Visual Studio 2017\Projects\BA\Planungstool-BA\WebService\Exercises\" + name, ImageFormat.Jpeg);
trainingsexercise.ImagePath = @"C:\Users\Christina\Documents\Visual Studio 2017\Projects\BA\Planungstool-BA\WebService\Exercises\" + name;
}
using (IDbConnection connection = provider.GetConnection())
{
trainingsDataRepository.InsertExercise(connection, trainingsexercise, owner);
return(true);
}
}
public bool SaveExercise(Trainingsexercise trainingsexercise)
{
try
{
var request = new RestRequest("training/insertexercise", Method.POST);
var json = JsonConvert.SerializeObject(trainingsexercise);
request.AddParameter("text/json", json, ParameterType.RequestBody);
IRestResponse response = client.Execute <List <Trainingsexercise> >(request);
List <Trainingsexercise> objects = JsonConvert.DeserializeObject <List <Trainingsexercise> >(response.Content);
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
return(true);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(false);
}
private Trainingsexercise GetExercise(int parent)
{
MemoryStream field = ImageFromCanvas;
Trainingsexercise trainingsexercise = new Trainingsexercise();
trainingsexercise.Name = textboxName.Text;
trainingsexercise.Process = textboxProcedure.Text;
if (radioButtonPrivate.IsChecked == true)
{
trainingsexercise.Accessibility = "private";
}
else
{
trainingsexercise.Accessibility = "public";
}
trainingsexercise.Owner = currentUser.Id;
trainingsexercise.Image = field.ToArray();
trainingsexercise.Type = textboxType.Text;
if (parent > 0)
{
trainingsexercise.Parent = parent;
}
return(trainingsexercise);
}
public IHttpActionResult InsertExercise([FromBody] Trainingsexercise trainingsexercise)
{
return(Ok(trainingService.InsertExercise(trainingsexercise, trainingsexercise.Owner)));
}
