public BusinessPartnerOrganizationUnitResponse Create(BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnit) { BusinessPartnerOrganizationUnitResponse response = new BusinessPartnerOrganizationUnitResponse(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); SqliteCommand insertCommand = db.CreateCommand(); insertCommand.CommandText = SqlCommandInsertPart; try { insertCommand = AddCreateParameters(insertCommand, businessPartnerOrganizationUnit); 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 BusinessPartnerOrganizationUnitViewModel ConvertToBusinessPartnerOrganizationUnitViewModel(this BusinessPartnerOrganizationUnit businessPartnerOrganizationUnit) { BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnitViewModel = new BusinessPartnerOrganizationUnitViewModel() { Id = businessPartnerOrganizationUnit.Id, Identifier = businessPartnerOrganizationUnit.Identifier, BusinessPartner = businessPartnerOrganizationUnit.BusinessPartner?.ConvertToBusinessPartnerViewModelLite(), Code = businessPartnerOrganizationUnit.Code, Name = businessPartnerOrganizationUnit.Name, Address = businessPartnerOrganizationUnit.Address, Country = businessPartnerOrganizationUnit.Country?.ConvertToCountryViewModelLite(), City = businessPartnerOrganizationUnit.City?.ConvertToCityViewModelLite(), Municipality = businessPartnerOrganizationUnit.Municipality?.ConvertToMunicipalityViewModelLite(), ContactPerson = businessPartnerOrganizationUnit.ContactPerson, Phone = businessPartnerOrganizationUnit.Phone, Mobile = businessPartnerOrganizationUnit.Mobile, IsActive = businessPartnerOrganizationUnit.Active, CreatedBy = businessPartnerOrganizationUnit.CreatedBy?.ConvertToUserViewModelLite(), Company = businessPartnerOrganizationUnit.Company?.ConvertToCompanyViewModelLite(), UpdatedAt = businessPartnerOrganizationUnit.UpdatedAt, CreatedAt = businessPartnerOrganizationUnit.CreatedAt, }; return(businessPartnerOrganizationUnitViewModel); }
public BusinessPartnerOrganizationUnitResponse Create(BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnitViewModel) { BusinessPartnerOrganizationUnitResponse response = new BusinessPartnerOrganizationUnitResponse(); try { response = WpfApiHandler.SendToApi <BusinessPartnerOrganizationUnitViewModel, BusinessPartnerOrganizationUnitResponse>(businessPartnerOrganizationUnitViewModel, "Create"); } catch (Exception ex) { response.BusinessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnitViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public BusinessPartnerOrganizationUnitResponse Delete(Guid identifier) { BusinessPartnerOrganizationUnitResponse response = new BusinessPartnerOrganizationUnitResponse(); try { BusinessPartnerOrganizationUnitViewModel viewModel = new BusinessPartnerOrganizationUnitViewModel(); viewModel.Identifier = identifier; response = WpfApiHandler.SendToApi <BusinessPartnerOrganizationUnitViewModel, BusinessPartnerOrganizationUnitResponse>(viewModel, "Delete"); } catch (Exception ex) { response.BusinessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnitViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public BusinessPartnerOrganizationUnitResponse Create(BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnitViewModel) { BusinessPartnerOrganizationUnitResponse response = new BusinessPartnerOrganizationUnitResponse(); try { BusinessPartnerOrganizationUnit addedBusinessPartnerOrganizationUnit = unitOfWork.GetBusinessPartnerOrganizationUnitRepository().Create(businessPartnerOrganizationUnitViewModel.ConvertToBusinessPartnerOrganizationUnit()); unitOfWork.Save(); response.BusinessPartnerOrganizationUnit = addedBusinessPartnerOrganizationUnit.ConvertToBusinessPartnerOrganizationUnitViewModel(); response.Success = true; } catch (Exception ex) { response.BusinessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnitViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public JsonResult Delete([FromBody] BusinessPartnerOrganizationUnitViewModel c) { BusinessPartnerOrganizationUnitResponse response = new BusinessPartnerOrganizationUnitResponse(); try { response = this.businessPartnerOrganizationUnitService.Delete(c.Identifier); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; Console.WriteLine(ex.Message); } return(Json(response, new Newtonsoft.Json.JsonSerializerSettings() { Formatting = Newtonsoft.Json.Formatting.Indented })); }
public BusinessPartnerOrganizationUnitResponse GetBusinessPartnerOrganizationUnit(Guid identifier) { BusinessPartnerOrganizationUnitResponse response = new BusinessPartnerOrganizationUnitResponse(); BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnitViewModel(); using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db")) { db.Open(); try { SqliteCommand selectCommand = new SqliteCommand( SqlCommandSelectPart + "FROM BusinessPartnerOrganizationUnits " + "WHERE Identifier = @Identifier;", db); selectCommand.Parameters.AddWithValue("@Identifier", identifier); SqliteDataReader query = selectCommand.ExecuteReader(); if (query.Read()) { businessPartnerOrganizationUnit = Read(query); } } catch (SqliteException error) { MainWindow.ErrorMessage = error.Message; response.Success = false; response.Message = error.Message; response.BusinessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnitViewModel(); return(response); } db.Close(); } response.Success = true; response.BusinessPartnerOrganizationUnit = businessPartnerOrganizationUnit; return(response); }
private SqliteCommand AddCreateParameters(SqliteCommand insertCommand, BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnit) { insertCommand.Parameters.AddWithValue("@ServerId", businessPartnerOrganizationUnit.Id); insertCommand.Parameters.AddWithValue("@Identifier", businessPartnerOrganizationUnit.Identifier); insertCommand.Parameters.AddWithValue("@Code", businessPartnerOrganizationUnit.Code); insertCommand.Parameters.AddWithValue("@Name", ((object)businessPartnerOrganizationUnit.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerId", ((object)businessPartnerOrganizationUnit.BusinessPartner.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerIdentifier", ((object)businessPartnerOrganizationUnit.BusinessPartner.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerCode", ((object)businessPartnerOrganizationUnit.BusinessPartner.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerName", ((object)businessPartnerOrganizationUnit.BusinessPartner.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerInternalCode", ((object)businessPartnerOrganizationUnit.BusinessPartner.InternalCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@BusinessPartnerNameGer", ((object)businessPartnerOrganizationUnit.BusinessPartner.NameGer) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Address", ((object)businessPartnerOrganizationUnit.Address) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryId", ((object)businessPartnerOrganizationUnit.Country?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryIdentifier", ((object)businessPartnerOrganizationUnit.Country?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryCode", ((object)businessPartnerOrganizationUnit.Country?.Mark) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CountryName", ((object)businessPartnerOrganizationUnit.Country?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityId", ((object)businessPartnerOrganizationUnit.City?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityIdentifier", ((object)businessPartnerOrganizationUnit.City?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityCode", ((object)businessPartnerOrganizationUnit.City?.ZipCode) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@CityName", ((object)businessPartnerOrganizationUnit.City?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityId", ((object)businessPartnerOrganizationUnit.Municipality?.Id) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityIdentifier", ((object)businessPartnerOrganizationUnit.Municipality?.Identifier) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityCode", ((object)businessPartnerOrganizationUnit.Municipality?.Code) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@MunicipalityName", ((object)businessPartnerOrganizationUnit.Municipality?.Name) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@ContactPerson", ((object)businessPartnerOrganizationUnit.ContactPerson) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Phone", ((object)businessPartnerOrganizationUnit.Phone) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@Mobile", ((object)businessPartnerOrganizationUnit.Mobile) ?? DBNull.Value); insertCommand.Parameters.AddWithValue("@IsSynced", businessPartnerOrganizationUnit.IsSynced); insertCommand.Parameters.AddWithValue("@UpdatedAt", ((object)businessPartnerOrganizationUnit.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 BusinessPartnerOrganizationUnitViewModel Read(SqliteDataReader query) { int counter = 0; BusinessPartnerOrganizationUnitViewModel dbEntry = new BusinessPartnerOrganizationUnitViewModel(); dbEntry.Id = SQLiteHelper.GetInt(query, ref counter); dbEntry.Identifier = SQLiteHelper.GetGuid(query, ref counter); dbEntry.Code = SQLiteHelper.GetString(query, ref counter); dbEntry.Name = SQLiteHelper.GetString(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.ContactPerson = SQLiteHelper.GetString(query, ref counter); dbEntry.Phone = SQLiteHelper.GetString(query, ref counter); dbEntry.Mobile = 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 static BusinessPartnerOrganizationUnitViewModel ConvertToBusinessPartnerOrganizationUnitViewModelLite(this BusinessPartnerOrganizationUnit businessPartnerOrganizationUnit) { BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnitViewModel = new BusinessPartnerOrganizationUnitViewModel() { Id = businessPartnerOrganizationUnit.Id, Identifier = businessPartnerOrganizationUnit.Identifier, Code = businessPartnerOrganizationUnit.Code, Name = businessPartnerOrganizationUnit.Name, Address = businessPartnerOrganizationUnit.Address, ContactPerson = businessPartnerOrganizationUnit.ContactPerson, Phone = businessPartnerOrganizationUnit.Phone, Mobile = businessPartnerOrganizationUnit.Mobile, IsActive = businessPartnerOrganizationUnit.Active, UpdatedAt = businessPartnerOrganizationUnit.UpdatedAt, CreatedAt = businessPartnerOrganizationUnit.CreatedAt, }; return(businessPartnerOrganizationUnitViewModel); }
public static BusinessPartnerOrganizationUnit ConvertToBusinessPartnerOrganizationUnit(this BusinessPartnerOrganizationUnitViewModel businessPartnerOrganizationUnitViewModel) { BusinessPartnerOrganizationUnit businessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnit() { Id = businessPartnerOrganizationUnitViewModel.Id, Identifier = businessPartnerOrganizationUnitViewModel.Identifier, BusinessPartnerId = businessPartnerOrganizationUnitViewModel.BusinessPartner?.Id ?? null, Code = businessPartnerOrganizationUnitViewModel.Code, Name = businessPartnerOrganizationUnitViewModel.Name, Address = businessPartnerOrganizationUnitViewModel.Address, CountryId = businessPartnerOrganizationUnitViewModel.Country?.Id ?? null, CityId = businessPartnerOrganizationUnitViewModel.City?.Id ?? null, MunicipalityId = businessPartnerOrganizationUnitViewModel.Municipality?.Id ?? null, ContactPerson = businessPartnerOrganizationUnitViewModel.ContactPerson, Phone = businessPartnerOrganizationUnitViewModel.Phone, Mobile = businessPartnerOrganizationUnitViewModel.Mobile, CreatedById = businessPartnerOrganizationUnitViewModel.CreatedBy?.Id ?? null, CompanyId = businessPartnerOrganizationUnitViewModel.Company?.Id ?? null, UpdatedAt = businessPartnerOrganizationUnitViewModel.UpdatedAt, CreatedAt = businessPartnerOrganizationUnitViewModel.CreatedAt, }; return(businessPartnerOrganizationUnit); }