public BusinessPartnerLocationResponse Create(BusinessPartnerLocationViewModel businessPartnerLocation) { BusinessPartnerLocationResponse response = new BusinessPartnerLocationResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, businessPartnerLocation); 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 static BusinessPartnerLocation ConvertToBusinessPartnerLocation(this BusinessPartnerLocationViewModel businessPartnerLocationViewModel) { BusinessPartnerLocation businessPartnerLocation = new BusinessPartnerLocation() { Id = businessPartnerLocationViewModel.Id, Identifier = businessPartnerLocationViewModel.Identifier, BusinessPartnerId = businessPartnerLocationViewModel.BusinessPartner?.Id ?? null, Address = businessPartnerLocationViewModel.Address, CountryId = businessPartnerLocationViewModel.Country?.Id ?? null, CityId = businessPartnerLocationViewModel.City?.Id ?? null, MunicipalityId = businessPartnerLocationViewModel.Municipality?.Id ?? null, RegionId = businessPartnerLocationViewModel.Region?.Id ?? null, ItemStatus = businessPartnerLocationViewModel.ItemStatus, Active = businessPartnerLocationViewModel.IsActive, CreatedById = businessPartnerLocationViewModel.CreatedBy?.Id ?? null, CompanyId = businessPartnerLocationViewModel.Company?.Id ?? null, UpdatedAt = businessPartnerLocationViewModel.UpdatedAt, CreatedAt = businessPartnerLocationViewModel.CreatedAt, }; return(businessPartnerLocation); }
public static BusinessPartnerLocationViewModel ConvertToBusinessPartnerLocationViewModel(this BusinessPartnerLocation businessPartnerLocation) { BusinessPartnerLocationViewModel businessPartnerLocationViewModel = new BusinessPartnerLocationViewModel() { Id = businessPartnerLocation.Id, Identifier = businessPartnerLocation.Identifier, BusinessPartner = businessPartnerLocation.BusinessPartner?.ConvertToBusinessPartnerViewModelLite(), Address = businessPartnerLocation.Address, Country = businessPartnerLocation.Country?.ConvertToCountryViewModelLite(), City = businessPartnerLocation.City?.ConvertToCityViewModelLite(), Municipality = businessPartnerLocation.Municipality?.ConvertToMunicipalityViewModelLite(), Region = businessPartnerLocation.Region?.ConvertToRegionViewModelLite(), ItemStatus = businessPartnerLocation.ItemStatus, IsActive = businessPartnerLocation.Active, CreatedBy = businessPartnerLocation.CreatedBy?.ConvertToUserViewModelLite(), Company = businessPartnerLocation.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = businessPartnerLocation.UpdatedAt, CreatedAt = businessPartnerLocation.CreatedAt, }; return(businessPartnerLocationViewModel); }
private void BtnDelete_Click(object sender, RoutedEventArgs e) { var response = new BusinessPartnerLocationSQLiteRepository().SetStatusDeleted(CurrentBusinessPartnerLocationDG.Identifier); if (response.Success) { MainWindow.SuccessMessage = ((string)Application.Current.FindResource("Stavka_je_uspešno_obrisanaUzvičnik")); CurrentBusinessPartnerLocationForm = new BusinessPartnerLocationViewModel(); CurrentBusinessPartnerLocationForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerLocationForm.ItemStatus = ItemStatus.Added; CurrentBusinessPartnerLocationDG = null; BusinessPartnerCreatedUpdated(); Thread displayThread = new Thread(() => DisplayBusinessPartnerLocationData()); displayThread.IsBackground = true; displayThread.Start(); } else { MainWindow.ErrorMessage = response.Message; } }
private void btnEditLocation_Click(object sender, RoutedEventArgs e) { CurrentBusinessPartnerLocationForm = new BusinessPartnerLocationViewModel(); CurrentBusinessPartnerLocationForm.Identifier = CurrentBusinessPartnerLocationDG.Identifier; CurrentBusinessPartnerLocationForm.ItemStatus = ItemStatus.Edited; CurrentBusinessPartnerLocationForm.IsSynced = CurrentBusinessPartnerLocationDG.IsSynced; CurrentBusinessPartnerLocationForm.Country = CurrentBusinessPartnerLocationDG.Country; CurrentBusinessPartnerLocationForm.Municipality = CurrentBusinessPartnerLocationDG.Municipality; CurrentBusinessPartnerLocationForm.Region = CurrentBusinessPartnerLocationDG.Region; CurrentBusinessPartnerLocationForm.City = CurrentBusinessPartnerLocationDG.City; CurrentBusinessPartnerLocationForm.Address = CurrentBusinessPartnerLocationDG.Address; CurrentBusinessPartnerLocationForm.UpdatedAt = CurrentBusinessPartnerLocationDG.UpdatedAt; }
public BusinessPartnerLocationResponse Create(BusinessPartnerLocationViewModel businessPartnerLocationViewModel) { BusinessPartnerLocationResponse response = new BusinessPartnerLocationResponse(); try { response = WpfApiHandler.SendToApi <BusinessPartnerLocationViewModel, BusinessPartnerLocationResponse>(businessPartnerLocationViewModel, "Create"); } catch (Exception ex) { response.BusinessPartnerLocation = new BusinessPartnerLocationViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public static BusinessPartnerLocationViewModel ConvertToBusinessPartnerLocationViewModelLite(this BusinessPartnerLocation businessPartnerLocation) { BusinessPartnerLocationViewModel businessPartnerLocationViewModel = new BusinessPartnerLocationViewModel() { Id = businessPartnerLocation.Id, Identifier = businessPartnerLocation.Identifier, Address = businessPartnerLocation.Address, ItemStatus = businessPartnerLocation.ItemStatus, IsActive = businessPartnerLocation.Active, UpdatedAt = businessPartnerLocation.UpdatedAt, CreatedAt = businessPartnerLocation.CreatedAt, }; return(businessPartnerLocationViewModel); }
public BusinessPartnerLocationResponse Delete(Guid identifier) { BusinessPartnerLocationResponse response = new BusinessPartnerLocationResponse(); try { BusinessPartnerLocationViewModel viewModel = new BusinessPartnerLocationViewModel(); viewModel.Identifier = identifier; response = WpfApiHandler.SendToApi <BusinessPartnerLocationViewModel, BusinessPartnerLocationResponse>(viewModel, "Delete"); } catch (Exception ex) { response.BusinessPartnerLocation = new BusinessPartnerLocationViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public BusinessPartnerLocationListResponse GetBusinessPartnerLocationsByBusinessPartner(int companyId, Guid businessPartnerIdentifier) { BusinessPartnerLocationListResponse response = new BusinessPartnerLocationListResponse(); List <BusinessPartnerLocationViewModel> businessPartnerLocations = new List <BusinessPartnerLocationViewModel>(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM BusinessPartnerLocations " + "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()) { BusinessPartnerLocationViewModel dbEntry = Read(query); businessPartnerLocations.Add(dbEntry); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.BusinessPartnerLocations = new List <BusinessPartnerLocationViewModel>(); return(response); } db.Close(); } response.Success = true; response.BusinessPartnerLocations = businessPartnerLocations; return(response); }
private BusinessPartnerLocationViewModel Read(SqliteDataReader query) { int counter = 0; BusinessPartnerLocationViewModel dbEntry = new BusinessPartnerLocationViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.BusinessPartner = SQLiteHelper.GetBusinessPartner(query, ref counter); dbEntry.Address = SQLiteHelper.GetString(query, ref counter); dbEntry.Country = SQLiteHelper.GetCountry(query, ref counter); dbEntry.City = SQLiteHelper.GetCity(query, ref counter); dbEntry.Municipality = SQLiteHelper.GetMunicipality(query, ref counter); dbEntry.Region = SQLiteHelper.GetRegion(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 BusinessPartner_Location_AddEdit(BusinessPartnerViewModel businessPartner) { businessPartnerService = DependencyResolver.Kernel.Get <IBusinessPartnerService>(); businessPartnerLocationService = DependencyResolver.Kernel.Get <IBusinessPartnerLocationService>(); InitializeComponent(); this.DataContext = this; CurrentBusinessPartner = businessPartner; CurrentBusinessPartnerLocationForm = new BusinessPartnerLocationViewModel(); CurrentBusinessPartnerLocationForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerLocationForm.ItemStatus = ItemStatus.Added; Thread displayThread = new Thread(() => DisplayBusinessPartnerLocationData()); displayThread.IsBackground = true; displayThread.Start(); txtAddress.Focus(); }
public BusinessPartnerLocationResponse GetBusinessPartnerLocation(Guid identifier) { BusinessPartnerLocationResponse response = new BusinessPartnerLocationResponse(); BusinessPartnerLocationViewModel businessPartnerLocation = new BusinessPartnerLocationViewModel(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM BusinessPartnerLocations " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { BusinessPartnerLocationViewModel dbEntry = Read(query); businessPartnerLocation = dbEntry; } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.BusinessPartnerLocation = new BusinessPartnerLocationViewModel(); return(response); } db.Close(); } response.Success = true; response.BusinessPartnerLocation = businessPartnerLocation; return(response); }
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, BusinessPartnerLocationViewModel businessPartnerLocation) { insertCommand.Parameters.AddWithValue("@ServerId", businessPartnerLocation.Id); insertCommand.Parameters.AddWithValue("@Identifier", businessPartnerLocation.Identifier); insertCommand.Parameters.AddWithValue("@BusinessPartnerId", ((object)businessPartnerLocation.BusinessPartner.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerIdentifier", ((object)businessPartnerLocation.BusinessPartner.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerCode", ((object)businessPartnerLocation.BusinessPartner.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerName", ((object)businessPartnerLocation.BusinessPartner.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerInternalCode", ((object)businessPartnerLocation.BusinessPartner.InternalCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerNameGer", ((object)businessPartnerLocation.BusinessPartner.NameGer) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Address", ((object)businessPartnerLocation.Address) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryId", ((object)businessPartnerLocation.Country?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryIdentifier", ((object)businessPartnerLocation.Country?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryCode", ((object)businessPartnerLocation.Country?.Mark) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryName", ((object)businessPartnerLocation.Country?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityId", ((object)businessPartnerLocation.City?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityIdentifier", ((object)businessPartnerLocation.City?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityCode", ((object)businessPartnerLocation.City?.ZipCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityName", ((object)businessPartnerLocation.City?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityId", ((object)businessPartnerLocation.Municipality?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityIdentifier", ((object)businessPartnerLocation.Municipality?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityCode", ((object)businessPartnerLocation.Municipality?.MunicipalityCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityName", ((object)businessPartnerLocation.Municipality?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@RegionId", ((object)businessPartnerLocation.Region?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@RegionIdentifier", ((object)businessPartnerLocation.Region?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@RegionCode", ((object)businessPartnerLocation.Region?.RegionCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@RegionName", ((object)businessPartnerLocation.Region?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ItemStatus", ((object)businessPartnerLocation.ItemStatus) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@IsSynced", businessPartnerLocation.IsSynced); insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)businessPartnerLocation.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 void btnCancelLocation_Click(object sender, RoutedEventArgs e) { CurrentBusinessPartnerLocationForm = new BusinessPartnerLocationViewModel(); CurrentBusinessPartnerLocationForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerLocationForm.ItemStatus = ItemStatus.Added; }
private void btnAddLocation_Click(object sender, RoutedEventArgs e) { #region Validation if (CurrentBusinessPartnerLocationForm.Country == null) { MainWindow.ErrorMessage = ((string)Application.Current.FindResource("Obavezno_poljeDvotačka_Država")); return; } #endregion Thread th = new Thread(() => { SubmitButtonEnabled = false; CurrentBusinessPartnerLocationForm.BusinessPartner = CurrentBusinessPartner; CurrentBusinessPartnerLocationForm.Company = new CompanyViewModel() { Id = MainWindow.CurrentCompanyId }; CurrentBusinessPartnerLocationForm.CreatedBy = new UserViewModel() { Id = MainWindow.CurrentUserId }; new BusinessPartnerLocationSQLiteRepository().Delete(CurrentBusinessPartnerLocationForm.Identifier); var response = new BusinessPartnerLocationSQLiteRepository().Create(CurrentBusinessPartnerLocationForm); if (!response.Success) { MainWindow.ErrorMessage = response.Message; CurrentBusinessPartnerLocationForm = new BusinessPartnerLocationViewModel(); CurrentBusinessPartnerLocationForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerLocationForm.ItemStatus = ItemStatus.Added; CurrentBusinessPartnerLocationForm.IsSynced = false; return; } CurrentBusinessPartnerLocationForm = new BusinessPartnerLocationViewModel(); CurrentBusinessPartnerLocationForm.Identifier = Guid.NewGuid(); CurrentBusinessPartnerLocationForm.ItemStatus = ItemStatus.Added; CurrentBusinessPartnerLocationForm.IsSynced = false; BusinessPartnerCreatedUpdated(); DisplayBusinessPartnerLocationData(); Application.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { txtAddress.Focus(); }) ); SubmitButtonEnabled = true; }); th.IsBackground = true; th.Start(); }