public DocumentFolderResponse Delete(Guid identifier)
{
DocumentFolderResponse response = new DocumentFolderResponse();
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 DocumentFolders 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 DocumentFolderResponse Create(DocumentFolderViewModel DocumentFolder)
{
DocumentFolderResponse response = new DocumentFolderResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, DocumentFolder);
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 DocumentFolderResponse Delete(DocumentFolderViewModel toDelete)
{
DocumentFolderResponse response = new DocumentFolderResponse();
try
{
response = WpfApiHandler.SendToApi <DocumentFolderViewModel, DocumentFolderResponse>(toDelete, "Delete");
}
catch (Exception ex)
{
response.DocumentFolder = new DocumentFolderViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public DocumentFolderResponse Create(DocumentFolderViewModel viewModel)
{
DocumentFolderResponse response = new DocumentFolderResponse();
try
{
response.DocumentFolder = unitOfWork.GetDocumentFolderRepository().Create(viewModel.ConvertToDocumentFolder())
?.ConvertToDocumentFolderViewModel();
response.Success = true;
} catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public DocumentFolderResponse Clear(int companyId)
{
DocumentFolderResponse response = new DocumentFolderResponse();
try
{
unitOfWork.GetDocumentFolderRepository().Clear(companyId);
response.Success = true;
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public DocumentFolderResponse Delete(DocumentFolderViewModel toDelete)
{
DocumentFolderResponse response = new DocumentFolderResponse();
try
{
response.DocumentFolder = unitOfWork.GetDocumentFolderRepository().Delete(toDelete?.Id ?? 0)
?.ConvertToDocumentFolderViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public DocumentFolderResponse Clear(int companyId)
{
DocumentFolderResponse response = new DocumentFolderResponse();
try
{
response = WpfApiHandler.GetFromApi <DocumentFolderViewModel, DocumentFolderResponse>("Clear", new Dictionary <string, string>()
{
{ "CompanyId", companyId.ToString() }
});
}
catch (Exception ex)
{
response.DocumentFolder = new DocumentFolderViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public JsonResult Delete([FromBody] DocumentFolderViewModel c)
{
DocumentFolderResponse response = new DocumentFolderResponse();
try
{
response = this.documentFolderService.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)
{
DocumentFolderResponse response = new DocumentFolderResponse();
try
{
response = documentFolderService.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 DocumentFolderResponse GetDirectoryByPath(int companyId, string path)
{
DocumentFolderResponse response = new DocumentFolderResponse();
DocumentFolderViewModel folder = null;
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM DocumentFolders " +
"WHERE Path = @Path " +
"AND CompanyId = @CompanyId " +
"ORDER BY Name ASC ", db);
selectCommand.Parameters.AddWithValue("@Path", path);
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
folder = Read(query);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.DocumentFolder = null;
return(response);
}
db.Close();
}
response.Success = true;
response.DocumentFolder = folder;
return(response);
}
