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