public JsonResult Create([FromBody] ToDoViewModel c) { ToDoResponse response = new ToDoResponse(); try { response = this.toDoService.Create(c); if (response.Success) { if (c.User != null) { string target = "Korisnik_" + c.User.Id; notificationHub.Clients.Group(target).SendAsync("SendToDo", c); } } } catch (Exception ex) { response.Success = false; response.Message = ex.Message; Console.WriteLine(ex.Message); } return(Json(response, new Newtonsoft.Json.JsonSerializerSettings() { Formatting = Newtonsoft.Json.Formatting.Indented })); }
public ToDoResponse Create(ToDoViewModel toDo) { ToDoResponse response = new ToDoResponse(); using (SqliteConnection db = new SqliteConnection(SQLiteHelper.SqLiteTableName)) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, toDo); insertCommand.ExecuteNonQuery(); } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; return(response); } db.Close(); response.Success = true; return(response); } }
public ToDoResponse Delete(Guid identifier) { ToDoResponse response = new ToDoResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = new SqliteCommand(); insertCommand.Connection = db; //Use parameterized query to prevent SQL injection attacks insertCommand.CommandText = "DELETE FROM ToDos WHERE Identifier = @Identifier"; insertCommand.Parameters.AddWithValue("@Identifier", identifier); try { insertCommand.ExecuteNonQuery(); } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; return(response); } db.Close(); response.Success = true; return(response); } }
public static async Task HandleError(HttpContext context, Exception exception) { var jsonresult = new ToDoResponse(statusCode: (int)System.Net.HttpStatusCode.InternalServerError, result: "Some Exception Occured" + exception.Message, errorMessage: exception.Message); await context.Response.WriteAsync(Newtonsoft.Json.JsonConvert.SerializeObject(jsonresult)); }
/// <summary> /// /// </summary> /// <param name="objresponse"></param> /// <returns></returns> private ActionResult SetResponse(ToDoResponse objresponse) { switch (objresponse.StatusCode) { case (int)System.Net.HttpStatusCode.OK: return(Ok(objresponse)); case (int)System.Net.HttpStatusCode.BadRequest: return(BadRequest(objresponse)); case (int)System.Net.HttpStatusCode.NotFound: return(NotFound(objresponse)); default: return(BadRequest(objresponse)); } }
public ToDoResponse Create(ToDoViewModel li) { ToDoResponse response = new ToDoResponse(); try { response = WpfApiHandler.SendToApi <ToDoViewModel, ToDoResponse>(li, "Create"); } catch (Exception ex) { response.ToDo = new ToDoViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
private Negotiator GetById(GetByIdRequest request) { if (request.Id.IsNullOrWhitespace()) { return(Negotiate.WithStatusCode(HttpStatusCode.BadRequest)); } var todo = _dataStore.FindById(request.Id); if (todo == null) { return(Negotiate.WithStatusCode(HttpStatusCode.NotFound)); } return(Negotiate.WithModel(ToDoResponse.From(todo)) .WithStatusCode(HttpStatusCode.OK)); }
public ToDoResponse Delete(Guid identifier) { ToDoResponse response = new ToDoResponse(); try { ToDoViewModel li = new ToDoViewModel(); li.Identifier = identifier; response = WpfApiHandler.SendToApi <ToDoViewModel, ToDoResponse>(li, "Delete"); } catch (Exception ex) { response.ToDo = new ToDoViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public JsonResult Delete([FromBody] ToDoViewModel toDo) { ToDoResponse response = new ToDoResponse(); try { response = this.toDoService.Delete(toDo.Identifier); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; Console.WriteLine(ex.Message); } return(Json(response, new Newtonsoft.Json.JsonSerializerSettings() { Formatting = Newtonsoft.Json.Formatting.Indented })); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { if (CurrentToDo == null) { MainWindow.WarningMessage = ((string)Application.Current.FindResource("Morate_odabrati_stavku_za_brisanjeUzvičnik")); return; } Thread th = new Thread(() => { if (CurrentToDo == null) { MainWindow.WarningMessage = ((string)Application.Current.FindResource("Morate_odabrati_stavku_za_brisanjeUzvičnik")); return; } ToDoResponse response = toDoService.Delete(CurrentToDo.Identifier); if (!response.Success) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_brisanja_sa_serveraUzvičnik")); return; } response = new ToDoSQLiteRepository().Delete(CurrentToDo.Identifier); if (!response.Success) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_lokalnog_brisanjaUzvičnik")); return; } MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Podaci_su_uspešno_obrisaniUzvičnik")); DisplayData(); }); th.IsBackground = true; th.Start(); }
public ToDoResponse DeleteAll() { ToDoResponse response = new ToDoResponse(); try { using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); db.EnableExtensions(true); SqliteCommand insertCommand = new SqliteCommand(); insertCommand.Connection = db; //Use parameterized query to prevent SQL injection attacks insertCommand.CommandText = "DELETE FROM ToDos"; try { insertCommand.ExecuteNonQuery(); } catch (SqliteException error) { response.Success = false; response.Message = error.Message; MainWindow.ErrorMessage = error.Message; return(response); } db.Close(); } } catch (SqliteException error) { response.Success = false; response.Message = error.Message; return(response); } response.Success = true; return(response); }
public ToDoResponse Create(ToDoViewModel li) { ToDoResponse response = new ToDoResponse(); try { ToDo addedToDo = unitOfWork.GetToDoRepository().Create(li.ConvertToToDo()); unitOfWork.Save(); response.ToDo = addedToDo.ConvertToToDoViewModel(); response.Success = true; } catch (Exception ex) { response.ToDo = new ToDoViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public ToDoResponse Delete(Guid identifier) { ToDoResponse response = new ToDoResponse(); try { ToDo deletedToDo = unitOfWork.GetToDoRepository().Delete(identifier); unitOfWork.Save(); response.ToDo = deletedToDo?.ConvertToToDoViewModel(); response.Success = true; } catch (Exception ex) { response.ToDo = new ToDoViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public ToDoResponse GetToDo(Guid identifier) { ToDoResponse response = new ToDoResponse(); ToDoViewModel toDo = new ToDoViewModel(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM ToDos " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { toDo = Read(query); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.ToDo = new ToDoViewModel(); return(response); } db.Close(); } response.Success = true; response.ToDo = toDo; return(response); }