private static void OnCurrentVatPropertyChanged(DependencyObject source, DependencyPropertyChangedEventArgs e) { VatPopup popup = source as VatPopup; VatViewModel vat = (VatViewModel)e.NewValue; popup.txtVat.Text = vat != null ? vat.Code + " (" + vat.Amount + ")" : ""; }
public ActionResult Vat() { checkVatPortTypeClient vat = new checkVatPortTypeClient(); var model = new List <VatViewModel>(); var searchedVats = this.db.Vats.OrderByDescending(x => x.Id) .Select(v => v.VatNumber) .ToList(); foreach (var searchedVat in searchedVats) { bool valid; string name; string address; string countryCode = searchedVat.Substring(0, 2); string vatNumber = searchedVat.Substring(2); var a = vat.checkVat(ref countryCode, ref vatNumber, out valid, out name, out address); var checkVat = new VatViewModel { IsValid = valid, Name = name, Address = address }; model.Add(checkVat); } return(View("Vat", model: model)); }
public VatListResponse GetVatsByPage(int companyId, VatViewModel vatSearchObject, int currentPage = 1, int itemsPerPage = 50) { VatListResponse response = new VatListResponse(); List <VatViewModel> vats = new List <VatViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM Vats " + "WHERE (@Description IS NULL OR @Description = '' OR Description LIKE @Description) " + "AND CompanyId = @CompanyId " + "ORDER BY IsSynced, ServerId " + "LIMIT @ItemsPerPage OFFSET @Offset;", db); selectCommand.Parameters.AddWithValue("@Description", ((object)vatSearchObject.Search_Description) != null ? "%" + vatSearchObject.Search_Description + "%" : ""); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); selectCommand.Parameters.AddWithValue("@ItemsPerPage", itemsPerPage); selectCommand.Parameters.AddWithValue("@Offset", (currentPage - 1) * itemsPerPage); SqliteDataReader query = selectCommand.ExecuteReader(); while (query.Read()) { vats.Add(Read(query)); } selectCommand = new SqliteCommand( "SELECT Count(*) " + "FROM Vats " + "WHERE (@Description IS NULL OR @Description = '' OR Description LIKE @Description) " + "AND CompanyId = @CompanyId;", db); selectCommand.Parameters.AddWithValue("@Description", ((object)vatSearchObject.Search_Description) != null ? "%" + vatSearchObject.Search_Description + "%" : ""); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); query = selectCommand.ExecuteReader(); if (query.Read()) { response.TotalItems = query.GetInt32(0); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.Vats = new List <VatViewModel>(); return(response); } db.Close(); } response.Success = true; response.Vats = vats; return(response); }
public VatResponse Create(VatViewModel vat) { VatResponse response = new VatResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, vat); 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 VatViewModel MapToViewModel(Vat model) { VatViewModel viewModel = new VatViewModel(); PropertyCopier <Vat, VatViewModel> .Copy(model, viewModel); return(viewModel); }
public Vat MapToModel(VatViewModel viewModel) { Vat model = new Vat(); PropertyCopier <VatViewModel, Vat> .Copy(viewModel, model); return(model); }
private void btnAdd_Click(object sender, RoutedEventArgs e) { VatViewModel Vat = new VatViewModel(); Vat.Identifier = Guid.NewGuid(); Vat_AddEdit addEditForm = new Vat_AddEdit(Vat, true); addEditForm.VatCreatedUpdated += new VatHandler(SyncData); FlyoutHelper.OpenFlyout(this, (string)Application.Current.FindResource("Podaci_o_PDV_u"), 95, addEditForm); }
public Vat_AddEdit(VatViewModel VatViewModel, bool isCreateProcess, bool isPopup = false) { VatService = DependencyResolver.Kernel.Get <IVatService>(); InitializeComponent(); this.DataContext = this; CurrentVat = VatViewModel; IsCreateProcess = isCreateProcess; IsPopup = isPopup; }
public SqliteCommand AddCreateParameters(SqliteCommand insertCommand, VatViewModel vat) { insertCommand.Parameters.AddWithValue("@ServerId", vat.Id); insertCommand.Parameters.AddWithValue("@Identifier", vat.Identifier); insertCommand.Parameters.AddWithValue("@Code", ((object)vat.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Amount", ((object)vat.Amount) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Description", ((object)vat.Description) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@IsSynced", vat.IsSynced); insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)vat.UpdatedAt) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CreatedById", MainWindow.CurrentUser.Id); insertCommand.Parameters.AddWithValue("@CreatedByName", MainWindow.CurrentUser.FirstName + " " + MainWindow.CurrentUser.LastName); insertCommand.Parameters.AddWithValue("@CompanyId", MainWindow.CurrentCompany.Id); insertCommand.Parameters.AddWithValue("@CompanyName", MainWindow.CurrentCompany.CompanyName); return(insertCommand); }
private VatViewModel Read(SqliteDataReader query) { int counter = 0; VatViewModel dbEntry = new VatViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.Code = SQLiteHelper.GetString(query, ref counter); dbEntry.Amount = SQLiteHelper.GetDecimal(query, ref counter); dbEntry.Description = SQLiteHelper.GetString(query, ref counter); dbEntry.IsSynced = SQLiteHelper.GetBoolean(query, ref counter); dbEntry.UpdatedAt = SQLiteHelper.GetDateTime(query, ref counter); dbEntry.CreatedBy = SQLiteHelper.GetCreatedBy(query, ref counter); dbEntry.Company = SQLiteHelper.GetCompany(query, ref counter); return(dbEntry); }
public VatResponse Create(VatViewModel Vat) { VatResponse response = new VatResponse(); try { response = WpfApiHandler.SendToApi <VatViewModel, VatResponse>(Vat, "Create"); } catch (Exception ex) { response.Vat = new VatViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public VatResponse Delete(Guid identifier) { VatResponse response = new VatResponse(); try { VatViewModel Vat = new VatViewModel(); Vat.Identifier = identifier; response = WpfApiHandler.SendToApi <VatViewModel, VatResponse>(Vat, "Delete"); } catch (Exception ex) { response.Vat = new VatViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public static VatViewModel ConvertToVatViewModelLite(this Vat Vat) { VatViewModel VatViewModel = new VatViewModel() { Id = Vat.Id, Identifier = Vat.Identifier, Code = Vat.Code, Amount = Vat.Amount, Description = Vat.Description, IsActive = Vat.Active, UpdatedAt = Vat.UpdatedAt, CreatedAt = Vat.CreatedAt }; return(VatViewModel); }
public VatResponse Create(VatViewModel re) { VatResponse response = new VatResponse(); try { Vat addedVat = unitOfWork.GetVatRepository().Create(re.ConvertToVat()); unitOfWork.Save(); response.Vat = addedVat.ConvertToVatViewModel(); response.Success = true; } catch (Exception ex) { response.Vat = new VatViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public static Vat ConvertToVat(this VatViewModel VatViewModel) { Vat Vat = new Vat() { Id = VatViewModel.Id, Identifier = VatViewModel.Identifier, Code = VatViewModel.Code, Amount = VatViewModel.Amount, Description = VatViewModel.Description, Active = VatViewModel.IsActive, CreatedById = VatViewModel.CreatedBy?.Id ?? null, CompanyId = VatViewModel.Company?.Id ?? null, CreatedAt = VatViewModel.CreatedAt, UpdatedAt = VatViewModel.UpdatedAt, }; return(Vat); }
public JsonResult Delete([FromBody] VatViewModel Vat) { VatResponse response = new VatResponse(); try { response = this.VatService.Delete(Vat.Identifier); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; Console.WriteLine(ex.Message); } JsonResult result = Json(response, new Newtonsoft.Json.JsonSerializerSettings() { Formatting = Newtonsoft.Json.Formatting.Indented, ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Serialize }); return(result); }
public VatResponse GetVat(Guid identifier) { VatResponse response = new VatResponse(); VatViewModel vat = null; using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM Vats " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { vat = Read(query); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.Vat = new VatViewModel(); return(response); } db.Close(); } response.Success = true; response.Vat = vat; return(response); }
public void GetTaxTypeTest() { VatViewModels vat = new VatViewModels(); TaxType tax = new TaxType() { TaxItem = new List <TaxItemType>() { new TaxItemType() { TaxPercent = new TaxPercentType() { TaxCategoryCode = "S", Value = 20 }, TaxAmount = 20, TaxAmountSpecified = false } } }; vat = VatViewModels.Load(tax); VatViewModel vatItem = vat.VatViewList.FirstOrDefault(); Assert.IsNotNull(vatItem); }
private void btnSubmit_Click(object sender, RoutedEventArgs e) { #region Validation if (String.IsNullOrEmpty(CurrentVat.Description)) { MainWindow.WarningMessage = ((string)Application.Current.FindResource("Obavezno_polje_naziv")); return; } #endregion Thread th = new Thread(() => { SubmitButtonContent = ((string)Application.Current.FindResource("Čuvanje_u_tokuTriTacke")); SubmitButtonEnabled = false; CurrentVat.IsSynced = false; CurrentVat.Company = new CompanyViewModel() { Id = MainWindow.CurrentCompanyId }; CurrentVat.CreatedBy = new UserViewModel() { Id = MainWindow.CurrentUserId }; VatResponse response = new VatSQLiteRepository().Delete(CurrentVat.Identifier); response = new VatSQLiteRepository().Create(CurrentVat); if (!response.Success) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Greška_kod_lokalnog_čuvanjaUzvičnik")); SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži")); SubmitButtonEnabled = true; return; } response = VatService.Create(CurrentVat); if (!response.Success) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Podaci_su_sačuvani_u_lokaluUzvičnikTačka_Greška_kod_čuvanja_na_serveruUzvičnik")) + response.Message; SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži")); SubmitButtonEnabled = true; } if (response.Success) { MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Greška_kod_čuvanja_na_serveruUzvičnik")); SubmitButtonContent = ((string)Application.Current.FindResource("Proknjiži")); SubmitButtonEnabled = true; VatCreatedUpdated(); if (IsCreateProcess) { CurrentVat = new VatViewModel(); CurrentVat.Identifier = Guid.NewGuid(); Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { txtAmount.Focus(); }) ); } else { Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { if (IsPopup) { FlyoutHelper.CloseFlyoutPopup(this); } else { FlyoutHelper.CloseFlyout(this); } }) ); } } }); th.IsBackground = true; th.Start(); }