public Documents_Mailing_List() { InitializeComponent(); this.DataContext = this; FilterBusinessPartnerDocuments = new BusinessPartnerDocumentViewModel(); FilterBusinessPartnerDocuments.PropertyChanged += FilterBusinessPartnerDocuments_PropertyChanged; FilterConstructionSiteDocuments = new ConstructionSiteDocumentViewModel(); FilterConstructionSiteDocuments.PropertyChanged += FilterConstructionSiteDocuments_PropertyChanged; FilterEmployeeDocuments = new EmployeeDocumentViewModel(); FilterEmployeeDocuments.PropertyChanged += FilterEmployeeDocuments_PropertyChanged; FilterPhysicalPersonDocuments = new PhysicalPersonDocumentViewModel(); FilterPhysicalPersonDocuments.PropertyChanged += FilterPhysicalPersonDocuments_PropertyChanged; DocumentsForMail = new ObservableCollection <DocumentForMailViewModel>(); Thread td = new Thread(() => { DisplayBusinessPartnerDocumentData(); DisplayConstructionSiteDocumentData(); DisplayEmployeeDocumentData(); DisplayPhysicalPersonDocumentData(); }); td.IsBackground = true; td.Start(); }
public ConstructionSiteDocumentResponse Create(ConstructionSiteDocumentViewModel constructionSiteDocument) { ConstructionSiteDocumentResponse response = new ConstructionSiteDocumentResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, constructionSiteDocument); 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); } }
private void BtnDelete_Click(object sender, RoutedEventArgs e) { var response = new ConstructionSiteDocumentSQLiteRepository().SetStatusDeleted(CurrentConstructionSiteDocumentDG.Identifier); if (response.Success) { MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Stavka_je_uspešno_obrisanaUzvičnik")); CurrentConstructionSiteDocumentForm = new ConstructionSiteDocumentViewModel(); CurrentConstructionSiteDocumentForm.Identifier = Guid.NewGuid(); CurrentConstructionSiteDocumentForm.ItemStatus = ItemStatus.Added; CurrentConstructionSiteDocumentDG = null; ConstructionSiteCreatedUpdated(); Thread displayThread = new Thread(() => DisplayConstructionSiteDocumentData()); displayThread.IsBackground = true; displayThread.Start(); } else { MainWindow.ErrorMessage = response.Message; } }
private void btnAddDocument_Click(object sender, RoutedEventArgs e) { #region Validation if (CurrentConstructionSiteDocumentForm.Name == null) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Obavezno_polje_naziv")); return; } #endregion Thread th = new Thread(() => { SubmitButtonEnabled = false; CurrentConstructionSiteDocumentForm.ConstructionSite = CurrentConstructionSite; CurrentConstructionSiteDocumentForm.Company = new CompanyViewModel() { Id = MainWindow.CurrentCompanyId }; CurrentConstructionSiteDocumentForm.CreatedBy = new UserViewModel() { Id = MainWindow.CurrentUserId }; new ConstructionSiteDocumentSQLiteRepository().Delete(CurrentConstructionSiteDocumentForm.Identifier); var response = new ConstructionSiteDocumentSQLiteRepository().Create(CurrentConstructionSiteDocumentForm); if (!response.Success) { MainWindow.ErrorMessage = response.Message; CurrentConstructionSiteDocumentForm = new ConstructionSiteDocumentViewModel(); CurrentConstructionSiteDocumentForm.Identifier = Guid.NewGuid(); CurrentConstructionSiteDocumentForm.ItemStatus = ItemStatus.Added; CurrentConstructionSiteDocumentForm.IsSynced = false; return; } CurrentConstructionSiteDocumentForm = new ConstructionSiteDocumentViewModel(); CurrentConstructionSiteDocumentForm.Identifier = Guid.NewGuid(); CurrentConstructionSiteDocumentForm.ItemStatus = ItemStatus.Added; CurrentConstructionSiteDocumentForm.IsSynced = false; ConstructionSiteCreatedUpdated(); DisplayConstructionSiteDocumentData(); Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { txtDocumentName.Focus(); }) ); SubmitButtonEnabled = true; }); th.IsBackground = true; th.Start(); }
private void btnEditDocument_Click(object sender, RoutedEventArgs e) { CurrentConstructionSiteDocumentForm = new ConstructionSiteDocumentViewModel(); CurrentConstructionSiteDocumentForm.Identifier = CurrentConstructionSiteDocumentDG.Identifier; CurrentConstructionSiteDocumentForm.ItemStatus = ItemStatus.Edited; CurrentConstructionSiteDocumentForm.Name = CurrentConstructionSiteDocumentDG.Name; CurrentConstructionSiteDocumentForm.CreateDate = CurrentConstructionSiteDocumentDG.CreateDate; CurrentConstructionSiteDocumentForm.Path = CurrentConstructionSiteDocumentDG.Path; CurrentConstructionSiteDocumentForm.IsSynced = CurrentConstructionSiteDocumentDG.IsSynced; CurrentConstructionSiteDocumentForm.UpdatedAt = CurrentConstructionSiteDocumentDG.UpdatedAt; }
public ConstructionSiteDocumentListResponse GetFilteredConstructionSiteDocuments(int companyId, ConstructionSiteDocumentViewModel filterObject) { ConstructionSiteDocumentListResponse response = new ConstructionSiteDocumentListResponse(); List <ConstructionSiteDocumentViewModel> ConstructionSiteDocuments = new List <ConstructionSiteDocumentViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM ConstructionSiteDocuments " + "WHERE (" + " (@ConstructionSiteName IS NULL OR @ConstructionSiteName = '' OR ConstructionSiteName LIKE @ConstructionSiteName) OR " + " (@ConstructionSiteName IS NULL OR @ConstructionSiteName = '' OR Name LIKE @ConstructionSiteName) " + ") " + "AND (@ConstructionSiteInternalCode IS NULL OR @ConstructionSiteInternalCode = '' OR ConstructionSiteInternalCode LIKE @ConstructionSiteInternalCode) " + "AND (@DateFrom IS NULL OR @DateFrom = '' OR DATE(CreateDate) >= DATE(@DateFrom)) " + "AND (@DateTo IS NULL OR @DateTo = '' OR DATE(CreateDate) <= DATE(@DateTo)) " + "ORDER BY IsSynced, Id DESC;", db); selectCommand.Parameters.AddWithValue("@ConstructionSiteName", (String.IsNullOrEmpty(filterObject.Search_Name) ? "" : "%" + filterObject.Search_Name + "%")); selectCommand.Parameters.AddWithValue("@ConstructionSiteInternalCode", (String.IsNullOrEmpty(filterObject.Search_Code) ? "" : "%" + filterObject.Search_Code + "%")); selectCommand.Parameters.AddWithValue("@DateFrom", ((object)filterObject.Search_DateFrom) ?? DBNull.Value); selectCommand.Parameters.AddWithValue("@DateTo", ((object)filterObject.Search_DateTo) ?? DBNull.Value); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); SqliteDataReader query = selectCommand.ExecuteReader(); while (query.Read()) { ConstructionSiteDocumentViewModel dbEntry = Read(query); ConstructionSiteDocuments.Add(dbEntry); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.ConstructionSiteDocuments = new List <ConstructionSiteDocumentViewModel>(); return(response); } db.Close(); } response.Success = true; response.ConstructionSiteDocuments = ConstructionSiteDocuments; return(response); }
private static ConstructionSiteDocumentViewModel Read(SqliteDataReader query) { int counter = 0; ConstructionSiteDocumentViewModel dbEntry = new ConstructionSiteDocumentViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.ConstructionSite = SQLiteHelper.GetConstructionSiteWithInternalCode(query, ref counter); dbEntry.Name = SQLiteHelper.GetString(query, ref counter); dbEntry.CreateDate = SQLiteHelper.GetDateTime(query, ref counter); dbEntry.Path = SQLiteHelper.GetString(query, ref counter); dbEntry.ItemStatus = SQLiteHelper.GetInt(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 ConstructionSiteDocumentListResponse GetConstructionSiteDocumentsByConstructionSite(int companyId, Guid ConstructionSiteIdentifier) { ConstructionSiteDocumentListResponse response = new ConstructionSiteDocumentListResponse(); List <ConstructionSiteDocumentViewModel> ConstructionSiteDocuments = new List <ConstructionSiteDocumentViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM ConstructionSiteDocuments " + "WHERE ConstructionSiteIdentifier = @ConstructionSiteIdentifier " + "AND CompanyId = @CompanyId " + "ORDER BY IsSynced, Id DESC;", db); selectCommand.Parameters.AddWithValue("@ConstructionSiteIdentifier", ConstructionSiteIdentifier); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); SqliteDataReader query = selectCommand.ExecuteReader(); while (query.Read()) { ConstructionSiteDocumentViewModel dbEntry = Read(query); ConstructionSiteDocuments.Add(dbEntry); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.ConstructionSiteDocuments = new List <ConstructionSiteDocumentViewModel>(); return(response); } db.Close(); } response.Success = true; response.ConstructionSiteDocuments = ConstructionSiteDocuments; return(response); }
public static ConstructionSiteDocumentViewModel ConvertToConstructionSiteDocumentViewModelLite(this ConstructionSiteDocument constructionSiteDocument) { ConstructionSiteDocumentViewModel constructionSiteDocumentViewModel = new ConstructionSiteDocumentViewModel() { Id = constructionSiteDocument.Id, Identifier = constructionSiteDocument.Identifier, Name = constructionSiteDocument.Name, CreateDate = constructionSiteDocument.CreateDate, Path = constructionSiteDocument.Path, ItemStatus = constructionSiteDocument.ItemStatus, IsActive = constructionSiteDocument.Active, UpdatedAt = constructionSiteDocument.UpdatedAt, CreatedAt = constructionSiteDocument.CreatedAt }; return(constructionSiteDocumentViewModel); }
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, ConstructionSiteDocumentViewModel constructionSiteDocument) { insertCommand.Parameters.AddWithValue("@ServerId", constructionSiteDocument.Id); insertCommand.Parameters.AddWithValue("@Identifier", constructionSiteDocument.Identifier); insertCommand.Parameters.AddWithValue("@ConstructionSiteId", ((object)constructionSiteDocument.ConstructionSite.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ConstructionSiteIdentifier", ((object)constructionSiteDocument.ConstructionSite.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ConstructionSiteCode", ((object)constructionSiteDocument.ConstructionSite.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ConstructionSiteName", ((object)constructionSiteDocument.ConstructionSite.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ConstructionSiteInternalCode", ((object)constructionSiteDocument.ConstructionSite.InternalCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Name", ((object)constructionSiteDocument.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CreateDate", ((object)constructionSiteDocument.CreateDate) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Path", ((object)constructionSiteDocument.Path) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ItemStatus", ((object)constructionSiteDocument.ItemStatus) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@IsSynced", constructionSiteDocument.IsSynced); insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)constructionSiteDocument.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); }
public ConstructionSite_Document_AddEdit(ConstructionSiteViewModel constructionSite) { constructionSiteService = DependencyResolver.Kernel.Get <IConstructionSiteService>(); constructionSiteDocumentService = DependencyResolver.Kernel.Get <IConstructionSiteDocumentService>(); InitializeComponent(); this.DataContext = this; CurrentConstructionSite = constructionSite; CurrentConstructionSiteDocumentForm = new ConstructionSiteDocumentViewModel(); CurrentConstructionSiteDocumentForm.Identifier = Guid.NewGuid(); CurrentConstructionSiteDocumentForm.ItemStatus = ItemStatus.Added; Thread displayThread = new Thread(() => DisplayConstructionSiteDocumentData()); displayThread.IsBackground = true; displayThread.Start(); btnAddDocument.Focus(); }
public ConstructionSiteDocumentResponse GetConstructionSiteDocument(Guid identifier) { ConstructionSiteDocumentResponse response = new ConstructionSiteDocumentResponse(); ConstructionSiteDocumentViewModel ConstructionSiteDocument = new ConstructionSiteDocumentViewModel(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM ConstructionSiteDocuments " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { ConstructionSiteDocumentViewModel dbEntry = Read(query); ConstructionSiteDocument = dbEntry; } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.ConstructionSiteDocument = new ConstructionSiteDocumentViewModel(); return(response); } db.Close(); } response.Success = true; response.ConstructionSiteDocument = ConstructionSiteDocument; return(response); }
private void btnCancelDocument_Click(object sender, RoutedEventArgs e) { CurrentConstructionSiteDocumentForm = new ConstructionSiteDocumentViewModel(); CurrentConstructionSiteDocumentForm.Identifier = Guid.NewGuid(); CurrentConstructionSiteDocumentForm.ItemStatus = ItemStatus.Added; }