public PhonebookResponse Create(PhonebookViewModel Phonebook)
{
PhonebookResponse response = new PhonebookResponse();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
try
{
insertCommand = AddCreateParameters(insertCommand, Phonebook);
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 PhonebookResponse Delete(Guid identifier)
{
PhonebookResponse response = new PhonebookResponse();
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 Phonebooks 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 PhonebookResponse Create(PhonebookViewModel re)
{
PhonebookResponse response = new PhonebookResponse();
try
{
response = WpfApiHandler.SendToApi <PhonebookViewModel, PhonebookResponse>(re, "Create");
}
catch (Exception ex)
{
response.Phonebook = new PhonebookViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
private void BtnSubmit_Click(object sender, RoutedEventArgs e)
{
#region Validation
if (PhonebookDocumentsFromDB == null || PhonebookDocumentsFromDB.Count == 0)
{
MainWindow.WarningMessage = ((string)Application.Current.FindResource("Morate_uneti_osnovne_podatkeUzvičnik"));
return;
}
#endregion
Thread td = new Thread(() => {
SubmitButtonContent = ((string)Application.Current.FindResource("Čuvanje_u_tokuTriTacke"));
SubmitButtonEnabled = false;
CurrentPhonebook.PhonebookDocuments = PhonebookDocumentsFromDB;
PhonebookResponse response = PhonebookService.Create(CurrentPhonebook);
if (!response.Success)
{
MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_čuvanja_na_serveruUzvičnik"));
SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži"));
SubmitButtonEnabled = true;
}
if (response.Success)
{
MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Podaci_su_uspešno_sačuvaniUzvičnik"));
SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži"));
SubmitButtonEnabled = true;
PhonebookCreatedUpdated();
Application.Current.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new Action(() =>
{
FlyoutHelper.CloseFlyout(this);
})
);
}
});
td.IsBackground = true;
td.Start();
}
public PhonebookResponse Delete(Guid identifier)
{
PhonebookResponse response = new PhonebookResponse();
try
{
PhonebookViewModel re = new PhonebookViewModel();
re.Identifier = identifier;
response = WpfApiHandler.SendToApi <PhonebookViewModel, PhonebookResponse>(re, "Delete");
}
catch (Exception ex)
{
response.Phonebook = new PhonebookViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public JsonResult Delete([FromBody] PhonebookViewModel phonebook)
{
PhonebookResponse response = new PhonebookResponse();
try
{
response = this.phonebookService.Delete(phonebook.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 PhonebookResponse Delete(Guid identifier)
{
PhonebookResponse response = new PhonebookResponse();
try
{
DomainCore.Common.Phonebooks.Phonebook deletedPhonebook = unitOfWork.GetPhonebookRepository().Delete(identifier);
unitOfWork.Save();
response.Phonebook = deletedPhonebook.ConvertToPhonebookViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.Phonebook = new PhonebookViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public PhonebookResponse GetPhonebook(Guid identifier)
{
PhonebookResponse response = new PhonebookResponse();
PhonebookViewModel Phonebook = new PhonebookViewModel();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM Phonebooks " +
"WHERE Identifier = @Identifier;", db);
selectCommand.Parameters.AddWithValue("@Identifier", identifier);
SqliteDataReader query = selectCommand.ExecuteReader();
if (query.Read())
{
PhonebookViewModel dbEntry = Read(query);
Phonebook = dbEntry;
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.Phonebook = new PhonebookViewModel();
return(response);
}
db.Close();
}
response.Success = true;
response.Phonebook = Phonebook;
return(response);
}
public PhonebookResponse Create(PhonebookViewModel re)
{
PhonebookResponse response = new PhonebookResponse();
try
{
// Backup notes
List <PhonebookNoteViewModel> PhonebookNotes = re.PhonebookNotes?.ToList();
re.PhonebookNotes = null;
// Backup documents
List <PhonebookDocumentViewModel> PhonebookDocuments = re.PhonebookDocuments?.ToList();
re.PhonebookDocuments = null;
// Backup phone
List <PhonebookPhoneViewModel> PhonebookPhones = re.PhonebookPhones?.ToList();
re.PhonebookPhones = null;
Phonebook createdPhonebook = unitOfWork.GetPhonebookRepository().Create(re.ConvertToPhonebook());
// Update notes
if (PhonebookNotes != null && PhonebookNotes.Count > 0)
{
// Items for create or update
foreach (var PhonebookNote in PhonebookNotes
.Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <PhonebookNoteViewModel>())
{
PhonebookNote.Phonebook = new PhonebookViewModel()
{
Id = createdPhonebook.Id
};
PhonebookNote.ItemStatus = ItemStatus.Submited;
PhonebookNote createdPhonebookNote = unitOfWork.GetPhonebookNoteRepository()
.Create(PhonebookNote.ConvertToPhonebookNote());
}
foreach (var item in PhonebookNotes
.Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <PhonebookNoteViewModel>())
{
item.Phonebook = new PhonebookViewModel()
{
Id = createdPhonebook.Id
};
unitOfWork.GetPhonebookNoteRepository().Create(item.ConvertToPhonebookNote());
unitOfWork.GetPhonebookNoteRepository().Delete(item.Identifier);
}
}
// Update documents
if (PhonebookDocuments != null && PhonebookDocuments.Count > 0)
{
// Items for create or update
foreach (var PhonebookDocument in PhonebookDocuments
.Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <PhonebookDocumentViewModel>())
{
PhonebookDocument.Phonebook = new PhonebookViewModel()
{
Id = createdPhonebook.Id
};
PhonebookDocument.ItemStatus = ItemStatus.Submited;
PhonebookDocument createdPhonebookDocument = unitOfWork.GetPhonebookDocumentRepository()
.Create(PhonebookDocument.ConvertToPhonebookDocument());
}
foreach (var item in PhonebookDocuments
.Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <PhonebookDocumentViewModel>())
{
item.Phonebook = new PhonebookViewModel()
{
Id = createdPhonebook.Id
};
unitOfWork.GetPhonebookDocumentRepository().Create(item.ConvertToPhonebookDocument());
unitOfWork.GetPhonebookDocumentRepository().Delete(item.Identifier);
}
}
// Update Phones
if (PhonebookPhones != null && PhonebookPhones.Count > 0)
{
// Items for create or update
foreach (var PhonebookPhone in PhonebookPhones
.Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <PhonebookPhoneViewModel>())
{
PhonebookPhone.Phonebook = new PhonebookViewModel()
{
Id = createdPhonebook.Id
};
PhonebookPhone.ItemStatus = ItemStatus.Submited;
PhonebookPhone createdPhonebookPhone = unitOfWork.GetPhonebookPhoneRepository()
.Create(PhonebookPhone.ConvertToPhonebookPhone());
}
foreach (var item in PhonebookPhones
.Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <PhonebookPhoneViewModel>())
{
item.Phonebook = new PhonebookViewModel()
{
Id = createdPhonebook.Id
};
unitOfWork.GetPhonebookPhoneRepository().Create(item.ConvertToPhonebookPhone());
unitOfWork.GetPhonebookPhoneRepository().Delete(item.Identifier);
}
}
unitOfWork.Save();
response.Phonebook = createdPhonebook.ConvertToPhonebookViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.Phonebook = new PhonebookViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
