public LimitationEmailResponse Delete(Guid identifier)
{
LimitationEmailResponse response = new LimitationEmailResponse();
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 LimitationEmails 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 LimitationEmailResponse Create(LimitationEmailViewModel LimitationEmail)
{
LimitationEmailResponse response = new LimitationEmailResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, LimitationEmail);
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 LimitationEmailResponse Create(LimitationEmailViewModel re)
{
LimitationEmailResponse response = new LimitationEmailResponse();
try
{
response = WpfApiHandler.SendToApi <LimitationEmailViewModel, LimitationEmailResponse>(re, "Create");
}
catch (Exception ex)
{
response.LimitationEmail = new LimitationEmailViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public LimitationEmailResponse Delete(Guid identifier)
{
LimitationEmailResponse response = new LimitationEmailResponse();
try
{
LimitationEmailViewModel re = new LimitationEmailViewModel();
re.Identifier = identifier;
response = WpfApiHandler.SendToApi <LimitationEmailViewModel, LimitationEmailResponse>(re, "Delete");
}
catch (Exception ex)
{
response.LimitationEmail = new LimitationEmailViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public LimitationEmailResponse Create(LimitationEmailViewModel re)
{
LimitationEmailResponse response = new LimitationEmailResponse();
try
{
LimitationEmail addedLimitationEmail = unitOfWork.GetLimitationEmailRepository().Create(re.ConvertToLimitationEmail());
unitOfWork.Save();
response.LimitationEmail = addedLimitationEmail.ConvertToLimitationEmailViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.LimitationEmail = new LimitationEmailViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public JsonResult Delete([FromBody] LimitationEmailViewModel LimitationEmail)
{
LimitationEmailResponse response = new LimitationEmailResponse();
try
{
response = this.LimitationEmailService.Delete(LimitationEmail.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
}));
}
public LimitationEmailResponse DeleteAll()
{
LimitationEmailResponse response = new LimitationEmailResponse();
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 LimitationEmails";
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);
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
if (CurrentLimitationEmailDG == null)
{
MainWindow.WarningMessage = "Morate odabrati LimitationEmail za brisanje!";
return;
}
SirmiumERPVisualEffects.AddEffectOnDialogShow(this);
// Create confirmation window
DeleteConfirmation deleteConfirmationForm = new DeleteConfirmation("LimitationEmail", CurrentLimitationEmailDG.Email);
var showDialog = deleteConfirmationForm.ShowDialog();
if (showDialog != null && showDialog.Value)
{
LimitationEmailResponse response = limitationEmailService.Delete(CurrentLimitationEmailDG.Identifier);
if (!response.Success)
{
MainWindow.ErrorMessage = "Greška kod brisanja sa servera!";
SirmiumERPVisualEffects.RemoveEffectOnDialogShow(this);
return;
}
response = new LimitationEmailSQLiteRepository().Delete(CurrentLimitationEmailDG.Identifier);
if (!response.Success)
{
MainWindow.ErrorMessage = "Greška kod lokalnog brisanja!";
SirmiumERPVisualEffects.RemoveEffectOnDialogShow(this);
return;
}
MainWindow.SuccessMessage = " LimitationEmail je uspešno obrisan!";
Thread displayThread = new Thread(() => Sync());
displayThread.IsBackground = true;
displayThread.Start();
}
SirmiumERPVisualEffects.RemoveEffectOnDialogShow(this);
}
public LimitationEmailResponse Delete(Guid identifier)
{
LimitationEmailResponse response = new LimitationEmailResponse();
try
{
LimitationEmail deletedLimitationEmail = unitOfWork.GetLimitationEmailRepository().Delete(identifier);
unitOfWork.Save();
response.LimitationEmail = deletedLimitationEmail?.ConvertToLimitationEmailViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.LimitationEmail = new LimitationEmailViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public LimitationEmailResponse GetLimitationEmail(Guid identifier)
{
LimitationEmailResponse response = new LimitationEmailResponse();
LimitationEmailViewModel LimitationEmail = new LimitationEmailViewModel();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM LimitationEmails " +
"WHERE Identifier = @Identifier;", db);
selectCommand.Parameters.AddWithValue("@Identifier", identifier);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
LimitationEmail = Read(query);
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.LimitationEmail = new LimitationEmailViewModel();
return(response);
}
db.Close();
}
response.Success = true;
response.LimitationEmail = LimitationEmail;
return(response);
}
