public static TaxAdministrationViewModel ConvertToTaxAdministrationViewModel(this TaxAdministration taxAdministration) { TaxAdministrationViewModel taxAdministrationViewModel = new TaxAdministrationViewModel() { Id = taxAdministration.Id, Identifier = taxAdministration.Identifier, Code = taxAdministration.Code, SecondCode = taxAdministration.SecondCode, Name = taxAdministration.Name, Address1 = taxAdministration.Address1, Address2 = taxAdministration.Address2, Address3 = taxAdministration.Address3, IBAN1 = taxAdministration.IBAN1, SWIFT = taxAdministration.SWIFT, City = taxAdministration.City?.ConvertToCityViewModelLite(), Bank1 = taxAdministration.Bank1?.ConvertToBankViewModelLite(), Bank2 = taxAdministration.Bank2?.ConvertToBankViewModelLite(), Company = taxAdministration.Company?.ConvertToCompanyViewModelLite(), CreatedBy = taxAdministration.CreatedBy?.ConvertToUserViewModelLite(), IsActive = taxAdministration.Active, UpdatedAt = taxAdministration.UpdatedAt, CreatedAt = taxAdministration.CreatedAt, }; return(taxAdministrationViewModel); }
public static TaxAdministration ConvertToTaxAdministration(this TaxAdministrationViewModel taxAdministrationViewModel) { TaxAdministration taxAdministration = new TaxAdministration() { Id = taxAdministrationViewModel.Id, Identifier = taxAdministrationViewModel.Identifier, Code = taxAdministrationViewModel.Code, SecondCode = taxAdministrationViewModel.SecondCode, Name = taxAdministrationViewModel.Name, Address1 = taxAdministrationViewModel.Address1, Address2 = taxAdministrationViewModel.Address2, Address3 = taxAdministrationViewModel.Address3, IBAN1 = taxAdministrationViewModel.IBAN1, SWIFT = taxAdministrationViewModel.SWIFT, CityId = taxAdministrationViewModel.City?.Id ?? null, BankId1 = taxAdministrationViewModel.Bank1?.Id ?? null, BankId2 = taxAdministrationViewModel.Bank2?.Id ?? null, CreatedById = taxAdministrationViewModel.CreatedBy?.Id ?? null, CompanyId = taxAdministrationViewModel.Company?.Id ?? null, Active = taxAdministrationViewModel.IsActive, UpdatedAt = taxAdministrationViewModel.UpdatedAt, CreatedAt = taxAdministrationViewModel.CreatedAt, }; return(taxAdministration); }
public TaxAdministration Create(TaxAdministration taxAdministration) { if (context.TaxAdministrations.Where(x => x.Identifier != null && x.Identifier == taxAdministration.Identifier).Count() == 0) { if (context.TaxAdministrations.Where(x => x.SecondCode == taxAdministration.SecondCode).Count() > 0) { throw new Exception("Poreska administracija sa datom šifrom već postoji u bazi! / Die Steuerverwaltung mit einem bestimmten Code ist bereits in der Datenbank vorhanden!"); } taxAdministration.Id = 0; taxAdministration.Code = GetNewCodeValue(taxAdministration.CompanyId ?? 0); taxAdministration.Active = true; taxAdministration.UpdatedAt = DateTime.Now; taxAdministration.CreatedAt = DateTime.Now; context.TaxAdministrations.Add(taxAdministration); return(taxAdministration); } else { // Load taxAdministration that will be updated TaxAdministration dbEntry = context.TaxAdministrations .FirstOrDefault(x => x.Identifier == taxAdministration.Identifier && x.Active == true); if (dbEntry != null) { dbEntry.CityId = taxAdministration.CityId ?? null; dbEntry.BankId1 = taxAdministration.BankId1 ?? null; dbEntry.BankId2 = taxAdministration.BankId2 ?? null; dbEntry.CompanyId = taxAdministration.CompanyId ?? null; dbEntry.CreatedById = taxAdministration.CreatedById ?? null; // Set properties dbEntry.Code = taxAdministration.Code; dbEntry.Name = taxAdministration.Name; dbEntry.Address1 = taxAdministration.Address1; dbEntry.Address2 = taxAdministration.Address2; dbEntry.Address3 = taxAdministration.Address3; dbEntry.IBAN1 = taxAdministration.IBAN1; dbEntry.SWIFT = taxAdministration.SWIFT; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); } }
public TaxAdministration Delete(Guid identifier) { // Load TaxAdministration that will be deleted TaxAdministration dbEntry = context.TaxAdministrations .FirstOrDefault(x => x.Identifier == identifier && x.Active == true); if (dbEntry != null) { // Set activity dbEntry.Active = false; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public TaxAdministration Create(TaxAdministration taxAdministration) { if (context.OutputInvoices.Where(x => x.Identifier != null && x.Identifier == taxAdministration.Identifier).Count() == 0) { taxAdministration.Id = 0; taxAdministration.Code = GetNewCodeValue(taxAdministration.CompanyId ?? 0); taxAdministration.Active = true; taxAdministration.UpdatedAt = DateTime.Now; taxAdministration.CreatedAt = DateTime.Now; context.TaxAdministrations.Add(taxAdministration); return(taxAdministration); } else { // Load taxAdministration that will be updated TaxAdministration dbEntry = context.TaxAdministrations .FirstOrDefault(x => x.Identifier == taxAdministration.Identifier && x.Active == true); if (dbEntry != null) { dbEntry.CityId = taxAdministration.CityId ?? null; dbEntry.BankId1 = taxAdministration.BankId1 ?? null; dbEntry.BankId2 = taxAdministration.BankId2 ?? null; dbEntry.CompanyId = taxAdministration.CompanyId ?? null; dbEntry.CreatedById = taxAdministration.CreatedById ?? null; // Set properties dbEntry.Code = taxAdministration.Code; dbEntry.Name = taxAdministration.Name; dbEntry.Address1 = taxAdministration.Address1; dbEntry.Address2 = taxAdministration.Address2; dbEntry.Address3 = taxAdministration.Address3; dbEntry.IBAN1 = taxAdministration.IBAN1; dbEntry.SWIFT = taxAdministration.SWIFT; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); } }
public TaxAdministrationResponse Create(TaxAdministrationViewModel re) { TaxAdministrationResponse response = new TaxAdministrationResponse(); try { TaxAdministration addedTaxAdministration = unitOfWork.GetTaxAdministrationRepository().Create(re.ConvertToTaxAdministration()); unitOfWork.Save(); response.TaxAdministration = addedTaxAdministration.ConvertToTaxAdministrationViewModel(); response.Success = true; } catch (Exception ex) { response.TaxAdministration = new TaxAdministrationViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public TaxAdministrationResponse Delete(Guid identifier) { TaxAdministrationResponse response = new TaxAdministrationResponse(); try { TaxAdministration deletedTaxAdministration = unitOfWork.GetTaxAdministrationRepository().Delete(identifier); unitOfWork.Save(); response.TaxAdministration = deletedTaxAdministration.ConvertToTaxAdministrationViewModel(); response.Success = true; } catch (Exception ex) { response.TaxAdministration = new TaxAdministrationViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public static TaxAdministrationViewModel ConvertToTaxAdministrationViewModelLite(this TaxAdministration taxAdministration) { TaxAdministrationViewModel taxAdministrationViewModel = new TaxAdministrationViewModel() { Id = taxAdministration.Id, Identifier = taxAdministration.Identifier, Code = taxAdministration.Code, SecondCode = taxAdministration.SecondCode, Name = taxAdministration.Name, Address1 = taxAdministration.Address1, Address2 = taxAdministration.Address2, Address3 = taxAdministration.Address3, IBAN1 = taxAdministration.IBAN1, SWIFT = taxAdministration.SWIFT, IsActive = taxAdministration.Active, UpdatedAt = taxAdministration.UpdatedAt, CreatedAt = taxAdministration.CreatedAt, }; return(taxAdministrationViewModel); }
public List <TaxAdministration> GetTaxAdministrations(int companyId) { List <TaxAdministration> TaxAdministrations = new List <TaxAdministration>(); string queryString = "SELECT TaxAdministrationId, TaxAdministrationIdentifier, TaxAdministrationCode, TaxAdministrationSecondCode, TaxAdministrationName, " + "CityId, CityIdentifier, CityZipCode, CityName, " + "Address1, Address2, Address3, " + "BankId1, BankIdentifier1, BankCode1, BankName1, " + "BankId2, BankIdentifier2, BankCode2, BankName2, " + "IBAN1, SWIFT, " + "Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " + "FROM vTaxAdministrations " + "WHERE CompanyId = @CompanyId AND Active = 1;"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = connection.CreateCommand(); command.CommandText = queryString; command.Parameters.Add(new SqlParameter("@CompanyId", companyId)); connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { TaxAdministration taxAdministration; while (reader.Read()) { taxAdministration = new TaxAdministration(); taxAdministration.Id = Int32.Parse(reader["TaxAdministrationId"].ToString()); taxAdministration.Identifier = Guid.Parse(reader["TaxAdministrationIdentifier"].ToString()); taxAdministration.Code = reader["TaxAdministrationCode"]?.ToString(); taxAdministration.SecondCode = reader["TaxAdministrationSecondCode"]?.ToString(); taxAdministration.Name = reader["TaxAdministrationName"].ToString(); if (reader["CityId"] != DBNull.Value) { taxAdministration.City = new City(); taxAdministration.CityId = Int32.Parse(reader["CityId"].ToString()); taxAdministration.City.Id = Int32.Parse(reader["CityId"].ToString()); taxAdministration.City.Identifier = Guid.Parse(reader["CityIdentifier"].ToString()); taxAdministration.City.ZipCode = reader["CityZipCode"].ToString(); taxAdministration.City.Name = reader["CityName"].ToString(); } if (reader["Address1"] != DBNull.Value) { taxAdministration.Address1 = reader["Address1"].ToString(); } if (reader["Address2"] != DBNull.Value) { taxAdministration.Address2 = reader["Address2"].ToString(); } if (reader["Address3"] != DBNull.Value) { taxAdministration.Address3 = reader["Address3"].ToString(); } if (reader["BankId1"] != DBNull.Value) { taxAdministration.Bank1 = new Bank(); taxAdministration.BankId1 = Int32.Parse(reader["BankId1"].ToString()); taxAdministration.Bank1.Id = Int32.Parse(reader["BankId1"].ToString()); taxAdministration.Bank1.Identifier = Guid.Parse(reader["BankIdentifier1"].ToString()); taxAdministration.Bank1.Swift = reader["BankCode1"].ToString(); taxAdministration.Bank1.Name = reader["BankName1"].ToString(); } if (reader["BankId2"] != DBNull.Value) { taxAdministration.Bank2 = new Bank(); taxAdministration.BankId2 = Int32.Parse(reader["BankId2"].ToString()); taxAdministration.Bank2.Id = Int32.Parse(reader["BankId2"].ToString()); taxAdministration.Bank2.Identifier = Guid.Parse(reader["BankIdentifier2"].ToString()); taxAdministration.Bank2.Swift = reader["BankCode2"].ToString(); taxAdministration.Bank2.Name = reader["BankName2"].ToString(); } if (reader["IBAN1"] != DBNull.Value) { taxAdministration.IBAN1 = reader["IBAN1"].ToString(); } if (reader["SWIFT"] != DBNull.Value) { taxAdministration.SWIFT = reader["SWIFT"].ToString(); } taxAdministration.Active = bool.Parse(reader["Active"].ToString()); taxAdministration.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString()); if (reader["CreatedById"] != DBNull.Value) { taxAdministration.CreatedBy = new User(); taxAdministration.CreatedById = Int32.Parse(reader["CreatedById"].ToString()); taxAdministration.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString()); taxAdministration.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString(); taxAdministration.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString(); } if (reader["CompanyId"] != DBNull.Value) { taxAdministration.Company = new Company(); taxAdministration.CompanyId = Int32.Parse(reader["CompanyId"].ToString()); taxAdministration.Company.Id = Int32.Parse(reader["CompanyId"].ToString()); taxAdministration.Company.Name = reader["CompanyName"].ToString(); } TaxAdministrations.Add(taxAdministration); } } } return(TaxAdministrations); //List<TaxAdministration> TaxAdministrations = context.TaxAdministrations // .Include(x => x.City) // .Include(x => x.Bank1) // .Include(x => x.Bank2) // .Include(x => x.Company) // .Include(x => x.CreatedBy) // .Where(x => x.Active == true && x.CompanyId == companyId) // .OrderByDescending(x => x.CreatedAt) // .AsNoTracking() // .ToList(); //return TaxAdministrations; }