public static BusinessPartnerInstitution ConvertToBusinessPartnerInstitution(this BusinessPartnerInstitutionViewModel businessPartnerInstitutionViewModel) { BusinessPartnerInstitution businessPartnerInstitution = new BusinessPartnerInstitution() { Id = businessPartnerInstitutionViewModel.Id, Identifier = businessPartnerInstitutionViewModel.Identifier, BusinessPartnerId = businessPartnerInstitutionViewModel.BusinessPartner?.Id ?? null, Code = businessPartnerInstitutionViewModel.Code, Institution = businessPartnerInstitutionViewModel.Institution, Username = businessPartnerInstitutionViewModel.Username, Password = businessPartnerInstitutionViewModel.Password, ContactPerson = businessPartnerInstitutionViewModel.ContactPerson, Phone = businessPartnerInstitutionViewModel.Phone, Fax = businessPartnerInstitutionViewModel.Fax, Email = businessPartnerInstitutionViewModel.Email, Note = businessPartnerInstitutionViewModel.Note, ItemStatus = businessPartnerInstitutionViewModel.ItemStatus, Active = businessPartnerInstitutionViewModel.IsActive, CreatedById = businessPartnerInstitutionViewModel.CreatedBy?.Id ?? null, CompanyId = businessPartnerInstitutionViewModel.Company?.Id ?? null, UpdatedAt = businessPartnerInstitutionViewModel.UpdatedAt, CreatedAt = businessPartnerInstitutionViewModel.CreatedAt, }; return(businessPartnerInstitution); }
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, BusinessPartnerInstitutionViewModel businessPartnerInstitution) { insertCommand.Parameters.AddWithValue("@ServerId", businessPartnerInstitution.Id); insertCommand.Parameters.AddWithValue("@Identifier", businessPartnerInstitution.Identifier); insertCommand.Parameters.AddWithValue("@BusinessPartnerId", ((object)businessPartnerInstitution.BusinessPartner.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerIdentifier", ((object)businessPartnerInstitution.BusinessPartner.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerCode", ((object)businessPartnerInstitution.BusinessPartner.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerName", ((object)businessPartnerInstitution.BusinessPartner.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerInternalCode", ((object)businessPartnerInstitution.BusinessPartner.InternalCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerNameGer", ((object)businessPartnerInstitution.BusinessPartner.NameGer) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Code", ((object)businessPartnerInstitution.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Institution", ((object)businessPartnerInstitution.Institution) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Username", ((object)businessPartnerInstitution.Username) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Password", ((object)businessPartnerInstitution.Password) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ContactPerson", ((object)businessPartnerInstitution.ContactPerson) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Phone", ((object)businessPartnerInstitution.Phone) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Fax", ((object)businessPartnerInstitution.Fax) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Email", ((object)businessPartnerInstitution.Email) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Note", ((object)businessPartnerInstitution.Note) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ItemStatus", ((object)businessPartnerInstitution.ItemStatus) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@IsSynced", businessPartnerInstitution.IsSynced); insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)businessPartnerInstitution.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 static BusinessPartnerInstitutionViewModel ConvertToBusinessPartnerInstitutionViewModel(this BusinessPartnerInstitution businessPartnerInstitution) { BusinessPartnerInstitutionViewModel businessPartnerInstitutionViewModel = new BusinessPartnerInstitutionViewModel() { Id = businessPartnerInstitution.Id, Identifier = businessPartnerInstitution.Identifier, BusinessPartner = businessPartnerInstitution.BusinessPartner?.ConvertToBusinessPartnerViewModelLite(), Code = businessPartnerInstitution.Code, Institution = businessPartnerInstitution.Institution, Username = businessPartnerInstitution.Username, Password = businessPartnerInstitution.Password, ContactPerson = businessPartnerInstitution.ContactPerson, Phone = businessPartnerInstitution.Phone, Fax = businessPartnerInstitution.Fax, Email = businessPartnerInstitution.Email, Note = businessPartnerInstitution.Note, ItemStatus = businessPartnerInstitution.ItemStatus, IsActive = businessPartnerInstitution.Active, CreatedBy = businessPartnerInstitution.CreatedBy?.ConvertToUserViewModelLite(), Company = businessPartnerInstitution.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = businessPartnerInstitution.UpdatedAt, CreatedAt = businessPartnerInstitution.CreatedAt, }; return(businessPartnerInstitutionViewModel); }
private void BtnDelete_Click(object sender, RoutedEventArgs e) { var response = new BusinessPartnerInstitutionSQLiteRepository().SetStatusDeleted(CurrentBusinessPartnerInstitutionDG.Identifier); if (response.Success) { MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Stavka_je_uspešno_obrisanaUzvičnik")); CurrentBusinessPartnerInstitutionForm = new BusinessPartnerInstitutionViewModel(); CurrentBusinessPartnerInstitutionForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerInstitutionForm.ItemStatus = ItemStatus.Added; CurrentBusinessPartnerInstitutionDG = null; BusinessPartnerCreatedUpdated(); Thread displayThread = new Thread(() => DisplayBusinessPartnerInstitutionData()); displayThread.IsBackground = true; displayThread.Start(); } else { MainWindow.ErrorMessage = response.Message; } }
private BusinessPartnerInstitutionViewModel Read(SqliteDataReader query) { int counter = 0; BusinessPartnerInstitutionViewModel dbEntry = new BusinessPartnerInstitutionViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.BusinessPartner = SQLiteHelper.GetBusinessPartner(query, ref counter); dbEntry.Code = SQLiteHelper.GetString(query, ref counter); dbEntry.Institution = SQLiteHelper.GetString(query, ref counter); dbEntry.Username = SQLiteHelper.GetString(query, ref counter); dbEntry.Password = SQLiteHelper.GetString(query, ref counter); dbEntry.ContactPerson = SQLiteHelper.GetString(query, ref counter); dbEntry.Phone = SQLiteHelper.GetString(query, ref counter); dbEntry.Fax = SQLiteHelper.GetString(query, ref counter); dbEntry.Email = SQLiteHelper.GetString(query, ref counter); dbEntry.Note = 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 BusinessPartnerInstitutionResponse Create(BusinessPartnerInstitutionViewModel businessPartnerInstitution) { BusinessPartnerInstitutionResponse response = new BusinessPartnerInstitutionResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, businessPartnerInstitution); 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 btnEditInstitution_Click(object sender, RoutedEventArgs e) { CurrentBusinessPartnerInstitutionForm = new BusinessPartnerInstitutionViewModel(); CurrentBusinessPartnerInstitutionForm.Identifier = CurrentBusinessPartnerInstitutionDG.Identifier; CurrentBusinessPartnerInstitutionForm.ItemStatus = ItemStatus.Edited; CurrentBusinessPartnerInstitutionForm.IsSynced = CurrentBusinessPartnerInstitutionDG.IsSynced; CurrentBusinessPartnerInstitutionForm.Code = CurrentBusinessPartnerInstitutionDG.Code; CurrentBusinessPartnerInstitutionForm.Institution = CurrentBusinessPartnerInstitutionDG.Institution; CurrentBusinessPartnerInstitutionForm.Username = CurrentBusinessPartnerInstitutionDG.Username; CurrentBusinessPartnerInstitutionForm.Password = CurrentBusinessPartnerInstitutionDG.Password; CurrentBusinessPartnerInstitutionForm.ContactPerson = CurrentBusinessPartnerInstitutionDG.ContactPerson; CurrentBusinessPartnerInstitutionForm.Phone = CurrentBusinessPartnerInstitutionDG.Phone; CurrentBusinessPartnerInstitutionForm.Fax = CurrentBusinessPartnerInstitutionDG.Fax; CurrentBusinessPartnerInstitutionForm.Email = CurrentBusinessPartnerInstitutionDG.Email; CurrentBusinessPartnerInstitutionForm.Note = CurrentBusinessPartnerInstitutionDG.Note; CurrentBusinessPartnerInstitutionForm.UpdatedAt = CurrentBusinessPartnerInstitutionDG.UpdatedAt; }
public BusinessPartnerInstitutionListResponse GetBusinessPartnerInstitutionsByBusinessPartner(int companyId, Guid businessPartnerIdentifier) { BusinessPartnerInstitutionListResponse response = new BusinessPartnerInstitutionListResponse(); List <BusinessPartnerInstitutionViewModel> businessPartnerInstitutions = new List <BusinessPartnerInstitutionViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM BusinessPartnerInstitutions " + "WHERE BusinessPartnerIdentifier = @BusinessPartnerIdentifier " + "AND CompanyId = @CompanyId " + "ORDER BY IsSynced, Id DESC;", db); selectCommand.Parameters.AddWithValue("@BusinessPartnerIdentifier", businessPartnerIdentifier); selectCommand.Parameters.AddWithValue("@CompanyId", companyId); SqliteDataReader query = selectCommand.ExecuteReader(); while (query.Read()) { BusinessPartnerInstitutionViewModel dbEntry = Read(query); businessPartnerInstitutions.Add(dbEntry); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.BusinessPartnerInstitutions = new List <BusinessPartnerInstitutionViewModel>(); return(response); } db.Close(); } response.Success = true; response.BusinessPartnerInstitutions = businessPartnerInstitutions; return(response); }
public BusinessPartner_Institution_AddEdit(BusinessPartnerViewModel businessPartner) { businessPartnerService = DependencyResolver.Kernel.Get <IBusinessPartnerService>(); businessPartnerInstitutionService = DependencyResolver.Kernel.Get <IBusinessPartnerInstitutionService>(); InitializeComponent(); this.DataContext = this; CurrentBusinessPartner = businessPartner; CurrentBusinessPartnerInstitutionForm = new BusinessPartnerInstitutionViewModel(); CurrentBusinessPartnerInstitutionForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerInstitutionForm.ItemStatus = ItemStatus.Added; Thread displayThread = new Thread(() => DisplayBusinessPartnerInstitutionData()); displayThread.IsBackground = true; displayThread.Start(); txtCode.Focus(); }
public BusinessPartnerInstitutionResponse GetBusinessPartnerInstitution(Guid identifier) { BusinessPartnerInstitutionResponse response = new BusinessPartnerInstitutionResponse(); BusinessPartnerInstitutionViewModel businessPartnerInstitution = new BusinessPartnerInstitutionViewModel(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM BusinessPartnerInstitutions " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { BusinessPartnerInstitutionViewModel dbEntry = Read(query); businessPartnerInstitution = dbEntry; } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.BusinessPartnerInstitution = new BusinessPartnerInstitutionViewModel(); return(response); } db.Close(); } response.Success = true; response.BusinessPartnerInstitution = businessPartnerInstitution; return(response); }
private void btnCancelInstitution_Click(object sender, RoutedEventArgs e) { CurrentBusinessPartnerInstitutionForm = new BusinessPartnerInstitutionViewModel(); CurrentBusinessPartnerInstitutionForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerInstitutionForm.ItemStatus = ItemStatus.Added; }
private void btnAddInstitution_Click(object sender, RoutedEventArgs e) { #region Validation if (CurrentBusinessPartnerInstitutionForm.Institution == null) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Obavezno_poljeDvotačka_Institucija")); return; } #endregion Thread th = new Thread(() => { SubmitButtonEnabled = false; CurrentBusinessPartnerInstitutionForm.BusinessPartner = CurrentBusinessPartner; CurrentBusinessPartnerInstitutionForm.Company = new CompanyViewModel() { Id = MainWindow.CurrentCompanyId }; CurrentBusinessPartnerInstitutionForm.CreatedBy = new UserViewModel() { Id = MainWindow.CurrentUserId }; new BusinessPartnerInstitutionSQLiteRepository().Delete(CurrentBusinessPartnerInstitutionForm.Identifier); var response = new BusinessPartnerInstitutionSQLiteRepository().Create(CurrentBusinessPartnerInstitutionForm); if (!response.Success) { MainWindow.ErrorMessage = response.Message; CurrentBusinessPartnerInstitutionForm = new BusinessPartnerInstitutionViewModel(); CurrentBusinessPartnerInstitutionForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerInstitutionForm.ItemStatus = ItemStatus.Added; CurrentBusinessPartnerInstitutionForm.IsSynced = false; return; } CurrentBusinessPartnerInstitutionForm = new BusinessPartnerInstitutionViewModel(); CurrentBusinessPartnerInstitutionForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerInstitutionForm.ItemStatus = ItemStatus.Added; CurrentBusinessPartnerInstitutionForm.IsSynced = false; BusinessPartnerCreatedUpdated(); DisplayBusinessPartnerInstitutionData(); Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { txtCode.Focus(); }) ); SubmitButtonEnabled = true; }); th.IsBackground = true; th.Start(); }