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);
}
public BusinessPartnerOrganizationUnit Delete(Guid identifier)
{
BusinessPartnerOrganizationUnit dbEntry = context.BusinessPartnerOrganizationUnits
.FirstOrDefault(x => x.Identifier == identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.Active = false;
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
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 BusinessPartnerOrganizationUnitResponse Delete(Guid identifier)
{
BusinessPartnerOrganizationUnitResponse response = new BusinessPartnerOrganizationUnitResponse();
try
{
BusinessPartnerOrganizationUnit deletedBusinessPartnerOrganizationUnit = unitOfWork.GetBusinessPartnerOrganizationUnitRepository().Delete(identifier);
unitOfWork.Save();
response.BusinessPartnerOrganizationUnit = deletedBusinessPartnerOrganizationUnit.ConvertToBusinessPartnerOrganizationUnitViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.BusinessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnitViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public BusinessPartnerOrganizationUnit Create(BusinessPartnerOrganizationUnit businessPartnerOrganizationUnit)
{
if (context.BusinessPartnerOrganizationUnits.Where(x => x.Identifier != null && x.Identifier == businessPartnerOrganizationUnit.Identifier).Count() == 0)
{
businessPartnerOrganizationUnit.Id = 0;
businessPartnerOrganizationUnit.Active = true;
context.BusinessPartnerOrganizationUnits.Add(businessPartnerOrganizationUnit);
return(businessPartnerOrganizationUnit);
}
else
{
// Load businessPartnerOrganizationUnit that will be updated
BusinessPartnerOrganizationUnit dbEntry = context.BusinessPartnerOrganizationUnits
.FirstOrDefault(x => x.Identifier == businessPartnerOrganizationUnit.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.BusinessPartnerId = businessPartnerOrganizationUnit.BusinessPartnerId ?? null;
dbEntry.CountryId = businessPartnerOrganizationUnit.CountryId ?? null;
dbEntry.CityId = businessPartnerOrganizationUnit.CityId ?? null;
dbEntry.MunicipalityId = businessPartnerOrganizationUnit.MunicipalityId ?? null;
dbEntry.CompanyId = businessPartnerOrganizationUnit.CompanyId ?? null;
dbEntry.CreatedById = businessPartnerOrganizationUnit.CreatedById ?? null;
// Set properties
dbEntry.Code = businessPartnerOrganizationUnit.Code;
dbEntry.Name = businessPartnerOrganizationUnit.Name;
dbEntry.Address = businessPartnerOrganizationUnit.Address;
dbEntry.ContactPerson = businessPartnerOrganizationUnit.ContactPerson;
dbEntry.Phone = businessPartnerOrganizationUnit.Phone;
dbEntry.Mobile = businessPartnerOrganizationUnit.Mobile;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
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 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 BusinessPartnerOrganizationUnit GetBusinessPartnerOrganizationUnit(int id)
{
BusinessPartnerOrganizationUnit businessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnit();
string queryString =
"SELECT BusinessPartnerOrganizationUnitId, BusinessPartnerOrganizationUnitIdentifier, " +
"BusinessPartnerId, BusinessPartnerIdentifier, BusinessPartnerCode, BusinessPartnerName, " +
"Code, Name, Address, " +
"CountryId, CountryIdentifier, CountryCode, CountryName, " +
"CityId, CityIdentifier, CityCode, CityName, " +
"MunicipalityId, MunicipalityIdentifier, MunicipalityCode, MunicipalityName, " +
"ContactPerson, Phone, Mobile, " +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vBusinessPartnerOrganizationUnits " +
"WHERE BusinessPartnerOrganizationUnitId = @BusinessPartnerOrganizationUnitId AND Active = 1;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;
command.Parameters.Add(new SqlParameter("@BusinessPartnerOrganizationUnitId", id));
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
businessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnit();
businessPartnerOrganizationUnit.Id = Int32.Parse(reader["BusinessPartnerOrganizationUnitId"].ToString());
businessPartnerOrganizationUnit.Identifier = Guid.Parse(reader["BusinessPartnerOrganizationUnitIdentifier"].ToString());
if (reader["BusinessPartnerId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.BusinessPartner = new BusinessPartner();
businessPartnerOrganizationUnit.BusinessPartnerId = Int32.Parse(reader["BusinessPartnerId"].ToString());
businessPartnerOrganizationUnit.BusinessPartner.Id = Int32.Parse(reader["BusinessPartnerId"].ToString());
businessPartnerOrganizationUnit.BusinessPartner.Identifier = Guid.Parse(reader["BusinessPartnerIdentifier"].ToString());
businessPartnerOrganizationUnit.BusinessPartner.Code = reader["BusinessPartnerCode"].ToString();
businessPartnerOrganizationUnit.BusinessPartner.Name = reader["BusinessPartnerName"].ToString();
}
if (reader["Code"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Code = reader["Code"].ToString();
}
if (reader["Name"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Name = reader["Name"].ToString();
}
if (reader["Address"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Address = reader["Address"].ToString();
}
if (reader["CountryId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Country = new Country();
businessPartnerOrganizationUnit.CountryId = Int32.Parse(reader["CountryId"].ToString());
businessPartnerOrganizationUnit.Country.Id = Int32.Parse(reader["CountryId"].ToString());
businessPartnerOrganizationUnit.Country.Identifier = Guid.Parse(reader["CountryIdentifier"].ToString());
businessPartnerOrganizationUnit.Country.Mark = reader["CountryCode"].ToString();
businessPartnerOrganizationUnit.Country.Name = reader["CountryName"].ToString();
}
if (reader["CityId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.City = new City();
businessPartnerOrganizationUnit.CityId = Int32.Parse(reader["CityId"].ToString());
businessPartnerOrganizationUnit.City.Id = Int32.Parse(reader["CityId"].ToString());
businessPartnerOrganizationUnit.City.Identifier = Guid.Parse(reader["CityIdentifier"].ToString());
businessPartnerOrganizationUnit.City.Code = reader["CityCode"].ToString();
businessPartnerOrganizationUnit.City.Name = reader["CityName"].ToString();
}
if (reader["MunicipalityId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Municipality = new Municipality();
businessPartnerOrganizationUnit.MunicipalityId = Int32.Parse(reader["MunicipalityId"].ToString());
businessPartnerOrganizationUnit.Municipality.Id = Int32.Parse(reader["MunicipalityId"].ToString());
businessPartnerOrganizationUnit.Municipality.Identifier = Guid.Parse(reader["MunicipalityIdentifier"].ToString());
businessPartnerOrganizationUnit.Municipality.Code = reader["MunicipalityCode"].ToString();
businessPartnerOrganizationUnit.Municipality.Name = reader["MunicipalityName"].ToString();
}
if (reader["ContactPerson"] != DBNull.Value)
{
businessPartnerOrganizationUnit.ContactPerson = reader["ContactPerson"].ToString();
}
if (reader["Phone"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Phone = reader["Phone"].ToString();
}
if (reader["Mobile"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Mobile = reader["Mobile"].ToString();
}
businessPartnerOrganizationUnit.Active = bool.Parse(reader["Active"].ToString());
businessPartnerOrganizationUnit.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
businessPartnerOrganizationUnit.CreatedBy = new User();
businessPartnerOrganizationUnit.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
businessPartnerOrganizationUnit.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
businessPartnerOrganizationUnit.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
businessPartnerOrganizationUnit.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Company = new Company();
businessPartnerOrganizationUnit.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
businessPartnerOrganizationUnit.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
businessPartnerOrganizationUnit.Company.Name = reader["CompanyName"].ToString();
}
}
}
}
return(businessPartnerOrganizationUnit);
//return context.BusinessPartnerOrganizationUnits
// .Include(x => x.BusinessPartner)
// .Include(x => x.Country)
// .Include(x => x.City)
// .Include(x => x.Municipality)
// .Include(x => x.Company)
// .Include(x => x.CreatedBy)
// .FirstOrDefault(x => x.Id == id && x.Active == true);
}
public List <BusinessPartnerOrganizationUnit> GetBusinessPartnerOrganizationUnitsNewerThen(int companyId, DateTime lastUpdateTime)
{
List <BusinessPartnerOrganizationUnit> BusinessPartnerOrganizationUnits = new List <BusinessPartnerOrganizationUnit>();
string queryString =
"SELECT BusinessPartnerOrganizationUnitId, BusinessPartnerOrganizationUnitIdentifier, " +
"BusinessPartnerId, BusinessPartnerIdentifier, BusinessPartnerCode, BusinessPartnerName, " +
"Code, Name, Address, " +
"CountryId, CountryIdentifier, CountryCode, CountryName, " +
"CityId, CityIdentifier, CityCode, CityName, " +
"MunicipalityId, MunicipalityIdentifier, MunicipalityCode, MunicipalityName, " +
"ContactPerson, Phone, Mobile, " +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vBusinessPartnerOrganizationUnits " +
"WHERE CompanyId = @CompanyId AND UpdatedAt > @LastUpdateTime;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = queryString;
command.Parameters.Add(new SqlParameter("@CompanyId", companyId));
command.Parameters.Add(new SqlParameter("@LastUpdateTime", lastUpdateTime));
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
BusinessPartnerOrganizationUnit businessPartnerOrganizationUnit;
while (reader.Read())
{
businessPartnerOrganizationUnit = new BusinessPartnerOrganizationUnit();
businessPartnerOrganizationUnit.Id = Int32.Parse(reader["BusinessPartnerOrganizationUnitId"].ToString());
businessPartnerOrganizationUnit.Identifier = Guid.Parse(reader["BusinessPartnerOrganizationUnitIdentifier"].ToString());
if (reader["BusinessPartnerId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.BusinessPartner = new BusinessPartner();
businessPartnerOrganizationUnit.BusinessPartnerId = Int32.Parse(reader["BusinessPartnerId"].ToString());
businessPartnerOrganizationUnit.BusinessPartner.Id = Int32.Parse(reader["BusinessPartnerId"].ToString());
businessPartnerOrganizationUnit.BusinessPartner.Identifier = Guid.Parse(reader["BusinessPartnerIdentifier"].ToString());
businessPartnerOrganizationUnit.BusinessPartner.Code = reader["BusinessPartnerCode"].ToString();
businessPartnerOrganizationUnit.BusinessPartner.Name = reader["BusinessPartnerName"].ToString();
}
if (reader["Code"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Code = reader["Code"].ToString();
}
if (reader["Name"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Name = reader["Name"].ToString();
}
if (reader["Address"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Address = reader["Address"].ToString();
}
if (reader["CountryId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Country = new Country();
businessPartnerOrganizationUnit.CountryId = Int32.Parse(reader["CountryId"].ToString());
businessPartnerOrganizationUnit.Country.Id = Int32.Parse(reader["CountryId"].ToString());
businessPartnerOrganizationUnit.Country.Identifier = Guid.Parse(reader["CountryIdentifier"].ToString());
businessPartnerOrganizationUnit.Country.Mark = reader["CountryCode"].ToString();
businessPartnerOrganizationUnit.Country.Name = reader["CountryName"].ToString();
}
if (reader["CityId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.City = new City();
businessPartnerOrganizationUnit.CityId = Int32.Parse(reader["CityId"].ToString());
businessPartnerOrganizationUnit.City.Id = Int32.Parse(reader["CityId"].ToString());
businessPartnerOrganizationUnit.City.Identifier = Guid.Parse(reader["CityIdentifier"].ToString());
businessPartnerOrganizationUnit.City.Code = reader["CityCode"].ToString();
businessPartnerOrganizationUnit.City.Name = reader["CityName"].ToString();
}
if (reader["MunicipalityId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Municipality = new Municipality();
businessPartnerOrganizationUnit.MunicipalityId = Int32.Parse(reader["MunicipalityId"].ToString());
businessPartnerOrganizationUnit.Municipality.Id = Int32.Parse(reader["MunicipalityId"].ToString());
businessPartnerOrganizationUnit.Municipality.Identifier = Guid.Parse(reader["MunicipalityIdentifier"].ToString());
businessPartnerOrganizationUnit.Municipality.Code = reader["MunicipalityCode"].ToString();
businessPartnerOrganizationUnit.Municipality.Name = reader["MunicipalityName"].ToString();
}
if (reader["ContactPerson"] != DBNull.Value)
{
businessPartnerOrganizationUnit.ContactPerson = reader["ContactPerson"].ToString();
}
if (reader["Phone"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Phone = reader["Phone"].ToString();
}
if (reader["Mobile"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Mobile = reader["Mobile"].ToString();
}
businessPartnerOrganizationUnit.Active = bool.Parse(reader["Active"].ToString());
businessPartnerOrganizationUnit.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
businessPartnerOrganizationUnit.CreatedBy = new User();
businessPartnerOrganizationUnit.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
businessPartnerOrganizationUnit.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
businessPartnerOrganizationUnit.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
businessPartnerOrganizationUnit.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
businessPartnerOrganizationUnit.Company = new Company();
businessPartnerOrganizationUnit.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
businessPartnerOrganizationUnit.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
businessPartnerOrganizationUnit.Company.Name = reader["CompanyName"].ToString();
}
BusinessPartnerOrganizationUnits.Add(businessPartnerOrganizationUnit);
}
}
}
return(BusinessPartnerOrganizationUnits);
//List<BusinessPartnerOrganizationUnit> businessPartnerOrganizationUnits = context.BusinessPartnerOrganizationUnits
// .Include(x => x.BusinessPartner)
// .Include(x => x.Country)
// .Include(x => x.City)
// .Include(x => x.Municipality)
// .Include(x => x.Company)
// .Include(x => x.CreatedBy)
// .Where(x => x.Company.Id == companyId && x.UpdatedAt > lastUpdateTime)
// .AsNoTracking()
// .ToList();
//return businessPartnerOrganizationUnits;
}
