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;
}
