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))); }