public DocumentFileResponse Delete(Guid identifier) { DocumentFileResponse response = new DocumentFileResponse(); 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 DocumentFiles 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 DocumentFileResponse Create(DocumentFileViewModel DocumentFile) { DocumentFileResponse response = new DocumentFileResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, DocumentFile); 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 DocumentFileResponse Create(DocumentFileViewModel viewModel) { DocumentFileResponse response = new DocumentFileResponse(); try { response.DocumentFile = unitOfWork.GetDocumentFileRepository().Create(viewModel.ConvertToDocumentFile()) ?.ConvertToDocumentFileViewModel(); response.Success = true; } catch (Exception ex) { response.Success = false; response.Message = ex.Message; } return(response); }
public DocumentFileResponse Clear(int companyId) { DocumentFileResponse response = new DocumentFileResponse(); try { unitOfWork.GetDocumentFileRepository().Clear(companyId); response.Success = true; } catch (Exception ex) { response.Success = false; response.Message = ex.Message; } return(response); }
public DocumentFileResponse Delete(DocumentFileViewModel toDelete) { DocumentFileResponse response = new DocumentFileResponse(); try { response = WpfApiHandler.SendToApi <DocumentFileViewModel, DocumentFileResponse>(toDelete, "Delete"); } catch (Exception ex) { response.DocumentFile = new DocumentFileViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public DocumentFileResponse Delete(DocumentFileViewModel toDelete) { DocumentFileResponse response = new DocumentFileResponse(); try { response.DocumentFile = unitOfWork.GetDocumentFileRepository().Delete(toDelete?.Id ?? 0) ?.ConvertToDocumentFileViewModel(); response.Success = true; } catch (Exception ex) { response.Success = false; response.Message = ex.Message; } return(response); }
public JsonResult Delete([FromBody] DocumentFileViewModel c) { DocumentFileResponse response = new DocumentFileResponse(); try { response = this.documentFileService.Delete(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 JsonResult Clear(int CompanyId) { DocumentFileResponse response = new DocumentFileResponse(); try { response = documentFileService.Clear(CompanyId); } 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 DocumentFileResponse Clear(int companyId) { DocumentFileResponse response = new DocumentFileResponse(); try { response = WpfApiHandler.GetFromApi <DocumentFileViewModel, DocumentFileResponse>("Clear", new Dictionary <string, string>() { { "CompanyId", companyId.ToString() } }); } catch (Exception ex) { response.DocumentFile = new DocumentFileViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }