public OutputInvoiceResponse Delete(Guid identifier) { OutputInvoiceResponse response = new OutputInvoiceResponse(); 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 OutputInvoices 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 OutputInvoiceResponse Update(OutputInvoiceViewModel oi) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { //List<OutputInvoiceItem> outputInvoiceItems = oi.ConvertToOutputInvoice().InvoiceItems; //oi.SumOfBase = outputInvoiceItems.Sum(x => x.Base); //oi.SumOfPdvValue = outputInvoiceItems.Sum(x => x.Pdv); //oi.SumOfTotalValue = outputInvoiceItems.Sum(x => x.TotalPrice); //oi.OutputInvoiceSubItems = null; OutputInvoice updatedOutputInvoice = unitOfWork.GetOutputInvoiceRepository().Update(oi.ConvertToOutputInvoice()); //unitOfWork.GetOutputInvoiceItemRepository().UpdateOutputInvoiceItems(outputInvoiceItems ?? new List<OutputInvoiceItem>(), updatedOutputInvoice); unitOfWork.Save(); response.OutputInvoice = updatedOutputInvoice.ConvertToOutputInvoiceViewModel(); response.Success = true; } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public JsonResult CancelOutputInvoice([FromBody] OutputInvoiceViewModel inOI) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { if (inOI != null && inOI.Id > 0) { response = this.outputInvoiceService.CancelOutputInvoice(inOI.Id); } else { response.Success = false; string errorMessage = "Prilikom storniranja izlaznog racuna id nije prosledjen."; response.Message = errorMessage; Console.WriteLine(errorMessage); } } 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 OutputInvoiceResponse Create(OutputInvoiceViewModel outputInvoice) { OutputInvoiceResponse response = new OutputInvoiceResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, outputInvoice); 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 OutputInvoiceResponse GetNewCodeValue() { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response = WpfApiHandler.GetFromApi <OutputInvoiceViewModel, OutputInvoiceResponse>("GetNewCodeValue", null); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; } return(response); }
public OutputInvoiceResponse Create(OutputInvoiceViewModel re) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response = WpfApiHandler.SendToApi <OutputInvoiceViewModel, OutputInvoiceResponse>(re, "Create"); } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
private void BtnSubmit_Click(object sender, RoutedEventArgs e) { #region Validation if (OutputInvoiceDocumentsFromDB == null || OutputInvoiceDocumentsFromDB.Count == 0) { MainWindow.WarningMessage = ((string)Application.Current.FindResource("Ne_postoje_stavke_za_proknjižavanje")); return; } #endregion Thread td = new Thread(() => { SubmitButtonContent = ((string)Application.Current.FindResource("Čuvanje_u_tokuTriTacke")); SubmitButtonEnabled = false; CurrentOutputInvoice.OutputInvoiceDocuments = OutputInvoiceDocumentsFromDB; OutputInvoiceResponse response = outputInvoiceService.Create(CurrentOutputInvoice); 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; OutputInvoiceCreatedUpdated(); Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { FlyoutHelper.CloseFlyout(this); }) ); } }); td.IsBackground = true; td.Start(); }
public OutputInvoiceResponse GetNewCodeValue() { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response.OutputInvoiceCode = unitOfWork.GetOutputInvoiceRepository().GetNewCodeValue(); response.Success = true; } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public JsonResult GetNewCodeValue() { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response = outputInvoiceService.GetNewCodeValue(); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; Console.WriteLine(ex.Message); } return(new JsonResult(response, new Newtonsoft.Json.JsonSerializerSettings() { Formatting = Newtonsoft.Json.Formatting.Indented })); }
public JsonResult SetInvoiceLock(int id, bool locked) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response = outputInvoiceService.SetInvoiceLock(id, locked); } 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 OutputInvoiceResponse Delete(Guid identifier) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { OutputInvoiceViewModel re = new OutputInvoiceViewModel(); re.Identifier = identifier; response = WpfApiHandler.SendToApi <OutputInvoiceViewModel, OutputInvoiceResponse>(re, "Delete"); } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public OutputInvoiceResponse CancelOutputInvoice(int id) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { OutputInvoiceViewModel oi = new OutputInvoiceViewModel(); oi.Id = id; response = WpfApiHandler.SendToApi <OutputInvoiceViewModel, OutputInvoiceResponse>(oi, "CancelOutputInvoice"); } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public JsonResult Update([FromBody] OutputInvoiceViewModel c) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response = this.outputInvoiceService.Update(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 OutputInvoiceResponse SetInvoiceLock(int id, bool locked) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response.OutputInvoice = unitOfWork.GetOutputInvoiceRepository().SetInvoiceLock(id, locked) .ConvertToOutputInvoiceViewModel(); unitOfWork.Save(); response.Success = true; } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public OutputInvoiceResponse GetOutputInvoice(int id) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { response = WpfApiHandler.GetFromApi <OutputInvoiceViewModel, OutputInvoiceResponse>("GetOutputInvoice", new Dictionary <string, string>() { { "id", id.ToString() } }); } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { // Check if any data is selected for delete if (CurrentOutputInvoice == null) { MainWindow.ErrorMessage = ("Morate odabrati iznizni račun za brisanje!"); return; } // Show blur effects SirmiumERPVisualEffects.AddEffectOnDialogShow(this); // Create confirmation window DeleteConfirmation deleteConfirmationForm = new DeleteConfirmation("izlazni račun", CurrentOutputInvoice.Code.ToString()); var showDialog = deleteConfirmationForm.ShowDialog(); if (showDialog != null && showDialog.Value) { // Delete business partner OutputInvoiceResponse response = outputInvoiceService.Delete(CurrentOutputInvoice.Id); // Display data and notifications if (response.Success) { MainWindow.SuccessMessage = ("Podaci su uspešno obrisani!"); Thread displayThread = new Thread(() => PopulateData()); displayThread.IsBackground = true; displayThread.Start(); } else { MainWindow.ErrorMessage = (response.Message); } } // Remove blur effects SirmiumERPVisualEffects.RemoveEffectOnDialogShow(this); dgOutputInvoices.Focus(); }
public OutputInvoiceResponse Delete(int id) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { OutputInvoice deletedOutputInvoice = unitOfWork.GetOutputInvoiceRepository().Delete(id); unitOfWork.Save(); response.OutputInvoice = deletedOutputInvoice.ConvertToOutputInvoiceViewModel(); response.Success = true; } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public OutputInvoiceResponse CancelOutputInvoice(int id) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { OutputInvoice outputInvoice = unitOfWork.GetOutputInvoiceRepository().CancelOutputInvoice(id); if (outputInvoice != null && outputInvoice.Active != false) { unitOfWork.Save(); } response.OutputInvoice = outputInvoice.ConvertToOutputInvoiceViewModel(); response.Success = true; } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public OutputInvoiceResponse Create(OutputInvoiceViewModel outputInvoice) { OutputInvoiceResponse response = new OutputInvoiceResponse(); try { //Backup items List <OutputInvoiceNoteViewModel> outputInvoiceNotes = outputInvoice .OutputInvoiceNotes?.ToList() ?? new List <OutputInvoiceNoteViewModel>(); outputInvoice.OutputInvoiceNotes = null; List <OutputInvoiceDocumentViewModel> outputInvoiceDocuments = outputInvoice .OutputInvoiceDocuments?.ToList() ?? new List <OutputInvoiceDocumentViewModel>(); outputInvoice.OutputInvoiceDocuments = null; OutputInvoice createdOutputInvoice = unitOfWork.GetOutputInvoiceRepository() .Create(outputInvoice.ConvertToOutputInvoice()); // Update items if (outputInvoiceNotes != null && outputInvoiceNotes.Count > 0) { foreach (OutputInvoiceNoteViewModel item in outputInvoiceNotes .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <OutputInvoiceNoteViewModel>()) { item.OutputInvoice = new OutputInvoiceViewModel() { Id = createdOutputInvoice.Id }; item.ItemStatus = ItemStatus.Submited; var createdItem = unitOfWork.GetOutputInvoiceNoteRepository().Create(item.ConvertToOutputInvoiceNote()); } foreach (OutputInvoiceNoteViewModel item in outputInvoiceNotes .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <OutputInvoiceNoteViewModel>()) { item.OutputInvoice = new OutputInvoiceViewModel() { Id = createdOutputInvoice.Id }; unitOfWork.GetOutputInvoiceNoteRepository().Create(item.ConvertToOutputInvoiceNote()); unitOfWork.GetOutputInvoiceNoteRepository().Delete(item.Identifier); } } // Update items if (outputInvoiceDocuments != null && outputInvoiceDocuments.Count > 0) { foreach (OutputInvoiceDocumentViewModel item in outputInvoiceDocuments .Where(x => x.ItemStatus == ItemStatus.Added || x.ItemStatus == ItemStatus.Edited)?.ToList() ?? new List <OutputInvoiceDocumentViewModel>()) { item.OutputInvoice = new OutputInvoiceViewModel() { Id = createdOutputInvoice.Id }; item.ItemStatus = ItemStatus.Submited; var createdItem = unitOfWork.GetOutputInvoiceDocumentRepository().Create(item.ConvertToOutputInvoiceDocument()); } foreach (OutputInvoiceDocumentViewModel item in outputInvoiceDocuments .Where(x => x.ItemStatus == ItemStatus.Deleted)?.ToList() ?? new List <OutputInvoiceDocumentViewModel>()) { item.OutputInvoice = new OutputInvoiceViewModel() { Id = createdOutputInvoice.Id }; unitOfWork.GetOutputInvoiceDocumentRepository().Create(item.ConvertToOutputInvoiceDocument()); unitOfWork.GetOutputInvoiceDocumentRepository().Delete(item.Identifier); } } unitOfWork.Save(); response.OutputInvoice = createdOutputInvoice.ConvertToOutputInvoiceViewModel(); response.Success = true; } catch (Exception ex) { response.OutputInvoice = new OutputInvoiceViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }