public PhysicalPerson_Note_AddEdit(PhysicalPersonViewModel physicalPerson) { physicalPersonService = DependencyResolver.Kernel.Get <IPhysicalPersonService>(); physicalPersonNoteService = DependencyResolver.Kernel.Get <IPhysicalPersonNoteService>(); InitializeComponent(); this.DataContext = this; CurrentPhysicalPerson = physicalPerson; CurrentPhysicalPersonNoteForm = new PhysicalPersonNoteViewModel(); CurrentPhysicalPersonNoteForm.Identifier = Guid.NewGuid(); CurrentPhysicalPersonNoteForm.ItemStatus = ItemStatus.Added; Thread displayThread = new Thread(() => DisplayPhysicalPersonNoteData()); displayThread.IsBackground = true; displayThread.Start(); btnAddNote.Focus(); }
//public PhysicalPersonNoteListResponse GetUnSyncedNotes(int companyId) //{ // PhysicalPersonNoteListResponse response = new PhysicalPersonNoteListResponse(); // List<PhysicalPersonNoteViewModel> viewModels = new List<PhysicalPersonNoteViewModel>(); // using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) // { // db.Open(); // try // { // SqliteCommand selectCommand = new SqliteCommand( // SqlCommandSelectPart + // "FROM PhysicalPersonNotes " + // "WHERE CompanyId = @CompanyId AND IsSynced = 0 " + // "ORDER BY Id DESC;", db); // selectCommand.Parameters.AddWithValue("@CompanyId", companyId); // SqliteDataReader query = selectCommand.ExecuteReader(); // while (query.Read()) // { // int counter = 0; // PhysicalPersonNoteViewModel dbEntry = new PhysicalPersonNoteViewModel(); // dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); // dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); // dbEntry.PhysicalPerson = SQLiteHelper.GetPhysicalPerson(query, ref counter); // dbEntry.Note = SQLiteHelper.GetString(query, ref counter); // dbEntry.NoteDate = SQLiteHelper.GetDateTime(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); // viewModels.Add(dbEntry); // } // } // catch (SqliteException error) // { // MainWindow.ErrorMessage = error.Message; // response.Success = false; // response.Message = error.Message; // response.PhysicalPersonNotes = new List<PhysicalPersonNoteViewModel>(); // return response; // } // db.Close(); // } // response.Success = true; // response.PhysicalPersonNotes = viewModels; // return response; //} #endregion #region Sync public void Sync(IPhysicalPersonNoteService physicalPersonNoteService, Action <int, int> callback = null) { try { SyncPhysicalPersonNoteRequest request = new SyncPhysicalPersonNoteRequest(); request.CompanyId = MainWindow.CurrentCompanyId; request.LastUpdatedAt = GetLastUpdatedAt(MainWindow.CurrentCompanyId); int toSync = 0; int syncedItems = 0; PhysicalPersonNoteListResponse response = physicalPersonNoteService.Sync(request); if (response.Success) { toSync = response?.PhysicalPersonNotes?.Count ?? 0; List <PhysicalPersonNoteViewModel> items = response.PhysicalPersonNotes; using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); using (var transaction = db.BeginTransaction()) { SqliteCommand deleteCommand = db.CreateCommand(); deleteCommand.CommandText = "DELETE FROM PhysicalPersonNotes WHERE Identifier = @Identifier"; SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; foreach (var item in items) { deleteCommand.Parameters.AddWithValue("@Identifier", item.Identifier); deleteCommand.ExecuteNonQuery(); deleteCommand.Parameters.Clear(); if (item.IsActive) { item.IsSynced = true; insertCommand = AddCreateParameters(insertCommand, item); insertCommand.ExecuteNonQuery(); insertCommand.Parameters.Clear(); syncedItems++; callback?.Invoke(syncedItems, toSync); } } transaction.Commit(); } db.Close(); } } else { throw new Exception(response.Message); } } catch (Exception ex) { MainWindow.ErrorMessage = ex.Message; } }
public PhysicalPersonNoteController(IServiceProvider provider) { PhysicalPersonNoteService = provider.GetRequiredService <IPhysicalPersonNoteService>(); }
public Home() { businessPartnerService = DependencyResolver.Kernel.Get <IBusinessPartnerService>(); businessPartnerTypeService = DependencyResolver.Kernel.Get <IBusinessPartnerTypeService>(); businessPartnerBankService = DependencyResolver.Kernel.Get <IBusinessPartnerBankService>(); businessPartnerDocumentService = DependencyResolver.Kernel.Get <IBusinessPartnerDocumentService>(); businessPartnerInstitutionService = DependencyResolver.Kernel.Get <IBusinessPartnerInstitutionService>(); businessPartnerLocationService = DependencyResolver.Kernel.Get <IBusinessPartnerLocationService>(); businessPartnerNoteService = DependencyResolver.Kernel.Get <IBusinessPartnerNoteService>(); //businessPartnerOrganizationUnitService = DependencyResolver.Kernel.Get<IBusinessPartnerOrganizationUnitService>(); businessPartnerPhoneService = DependencyResolver.Kernel.Get <IBusinessPartnerPhoneService>(); employeeService = DependencyResolver.Kernel.Get <IEmployeeService>(); employeeProfessionService = DependencyResolver.Kernel.Get <IEmployeeProfessionService>(); employeeNoteService = DependencyResolver.Kernel.Get <IEmployeeNoteService>(); employeeLicenceService = DependencyResolver.Kernel.Get <IEmployeeLicenceService>(); employeeItemService = DependencyResolver.Kernel.Get <IEmployeeItemService>(); employeeDocumentService = DependencyResolver.Kernel.Get <IEmployeeDocumentService>(); employeeCardService = DependencyResolver.Kernel.Get <IEmployeeCardService>(); licenceTypeService = DependencyResolver.Kernel.Get <ILicenceTypeService>(); familyMemberService = DependencyResolver.Kernel.Get <IFamilyMemberService>(); physicalPersonService = DependencyResolver.Kernel.Get <IPhysicalPersonService>(); physicalPersonProfessionService = DependencyResolver.Kernel.Get <IPhysicalPersonProfessionService>(); physicalPersonNoteService = DependencyResolver.Kernel.Get <IPhysicalPersonNoteService>(); physicalPersonLicenceService = DependencyResolver.Kernel.Get <IPhysicalPersonLicenceService>(); physicalPersonItemService = DependencyResolver.Kernel.Get <IPhysicalPersonItemService>(); physicalPersonDocumentService = DependencyResolver.Kernel.Get <IPhysicalPersonDocumentService>(); physicalPersonCardService = DependencyResolver.Kernel.Get <IPhysicalPersonCardService>(); outputInvoiceService = DependencyResolver.Kernel.Get <IOutputInvoiceService>(); inputInvoiceService = DependencyResolver.Kernel.Get <IInputInvoiceService>(); countryService = DependencyResolver.Kernel.Get <ICountryService>(); regionService = DependencyResolver.Kernel.Get <IRegionService>(); municipalityService = DependencyResolver.Kernel.Get <IMunicipalityService>(); cityService = DependencyResolver.Kernel.Get <ICityService>(); sectorService = DependencyResolver.Kernel.Get <ISectorService>(); professionService = DependencyResolver.Kernel.Get <IProfessionService>(); bankService = DependencyResolver.Kernel.Get <IBankService>(); agencyService = DependencyResolver.Kernel.Get <IAgencyService>(); constructionSiteService = DependencyResolver.Kernel.Get <IConstructionSiteService>(); constructionSiteDocumentService = DependencyResolver.Kernel.Get <IConstructionSiteDocumentService>(); constructionSiteCalculationService = DependencyResolver.Kernel.Get <IConstructionSiteCalculationService>(); constructionSiteNoteService = DependencyResolver.Kernel.Get <IConstructionSiteNoteService>(); //employeeByBusinessPartnerService = DependencyResolver.Kernel.Get<IEmployeeByBusinessPartnerService>(); //radnici po firmama? //employeeByConstructionSiteService = DependencyResolver.Kernel.Get<IEmployeeByConstructionSiteService>(); // radnici po gradilistu //businessPartnerByConstructionSiteService = DependencyResolver.Kernel.Get<IBusinessPartnerByConstructionSiteService>(); //firme po gradilistu taxAdministrationService = DependencyResolver.Kernel.Get <ITaxAdministrationService>(); limitationService = DependencyResolver.Kernel.Get <ILimitationService>(); userService = DependencyResolver.Kernel.Get <IUserService>(); vatService = DependencyResolver.Kernel.Get <IVatService>(); discountService = DependencyResolver.Kernel.Get <IDiscountService>(); serviceDeliveryService = DependencyResolver.Kernel.Get <IServiceDeliveryService>(); statusService = DependencyResolver.Kernel.Get <IStatusService>(); shipmentService = DependencyResolver.Kernel.Get <IShipmentService>(); toDoService = DependencyResolver.Kernel.Get <IToDoService>(); phonebookService = DependencyResolver.Kernel.Get <IPhonebookService>(); callCentarService = DependencyResolver.Kernel.Get <ICallCentarService>(); employeeByConstructionSiteService = DependencyResolver.Kernel.Get <IEmployeeByConstructionSiteService>(); businessPartnerByConstructionSiteService = DependencyResolver.Kernel.Get <IBusinessPartnerByConstructionSiteService>(); employeeByBusinessPartnerService = DependencyResolver.Kernel.Get <IEmployeeByBusinessPartnerService>(); documentFolderService = DependencyResolver.Kernel.Get <IDocumentFolderService>(); documentFileService = DependencyResolver.Kernel.Get <IDocumentFileService>(); InitializeComponent(); this.DataContext = this; var resp = new CompanyUserSQLiteRepository().GetCompanyUser(MainWindow.CurrentCompanyId, MainWindow.CurrentUser?.Identifier ?? Guid.Empty); if (resp.Success) { var userRoles = resp.CompanyUser?.UserRoles ?? new List <UserRoleViewModel>(); if (userRoles.Any(x => x.Name == "CallCentar") || userRoles.Any(x => x.Name == "Admin")) { CallCentarList.Visibility = System.Windows.Visibility.Visible; } else { CallCentarList.Visibility = System.Windows.Visibility.Collapsed; } } }