public static BusinessPartnerByConstructionSite ConvertToBusinessPartnerByConstructionSite(this BusinessPartnerByConstructionSiteViewModel businessPartnerByConstructionSiteViewModel)
{
BusinessPartnerByConstructionSite businessPartnerByConstructionSite = new BusinessPartnerByConstructionSite()
{
Id = businessPartnerByConstructionSiteViewModel.Id,
Identifier = businessPartnerByConstructionSiteViewModel.Identifier,
Code = businessPartnerByConstructionSiteViewModel.Code,
StartDate = businessPartnerByConstructionSiteViewModel.StartDate,
EndDate = businessPartnerByConstructionSiteViewModel.EndDate,
RealEndDate = businessPartnerByConstructionSiteViewModel.RealEndDate,
MaxNumOfEmployees = businessPartnerByConstructionSiteViewModel.MaxNumOfEmployees,
BusinessPartnerId = businessPartnerByConstructionSiteViewModel.BusinessPartner?.Id ?? null,
BusinessPartnerCount = businessPartnerByConstructionSiteViewModel.BusinessPartnerCount,
ConstructionSiteId = businessPartnerByConstructionSiteViewModel.ConstructionSite?.Id ?? null,
CreatedById = businessPartnerByConstructionSiteViewModel.CreatedBy?.Id ?? null,
CompanyId = businessPartnerByConstructionSiteViewModel.Company?.Id ?? null,
CreatedAt = businessPartnerByConstructionSiteViewModel.CreatedAt,
UpdatedAt = businessPartnerByConstructionSiteViewModel.UpdatedAt
};
return(businessPartnerByConstructionSite);
}
public BusinessPartnerByConstructionSite Delete(BusinessPartnerByConstructionSite businessPartnerByConstructionSite)
{
// Load BusinessPartnerByConstructionSite that will be deleted
BusinessPartnerByConstructionSite dbEntry = context.BusinessPartnerByConstructionSites
.FirstOrDefault(x => x.Identifier == businessPartnerByConstructionSite.Identifier && x.Active == true);
if (dbEntry != null)
{
// Set activity
dbEntry.Active = false;
dbEntry.RealEndDate = businessPartnerByConstructionSite.RealEndDate;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
public BusinessPartnerByConstructionSite Create(BusinessPartnerByConstructionSite businessPartnerByConstructionSite)
{
if (context.BusinessPartnerByConstructionSites.Where(x => x.Identifier != null && x.Identifier == businessPartnerByConstructionSite.Identifier).Count() == 0)
{
businessPartnerByConstructionSite.Id = 0;
businessPartnerByConstructionSite.Code = GetNewCodeValue(businessPartnerByConstructionSite.CompanyId ?? 0);
businessPartnerByConstructionSite.Active = true;
businessPartnerByConstructionSite.UpdatedAt = DateTime.Now;
businessPartnerByConstructionSite.CreatedAt = DateTime.Now;
context.BusinessPartnerByConstructionSites.Add(businessPartnerByConstructionSite);
return(businessPartnerByConstructionSite);
}
else
{
// Load businessPartnerByConstructionSite that will be updated
BusinessPartnerByConstructionSite dbEntry = context.BusinessPartnerByConstructionSites
.FirstOrDefault(x => x.Identifier == businessPartnerByConstructionSite.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.BusinessPartnerId = businessPartnerByConstructionSite.BusinessPartnerId ?? null;
dbEntry.ConstructionSiteId = businessPartnerByConstructionSite.ConstructionSiteId ?? null;
dbEntry.CompanyId = businessPartnerByConstructionSite.CompanyId ?? null;
dbEntry.CreatedById = businessPartnerByConstructionSite.CreatedById ?? null;
// Set properties
dbEntry.Code = businessPartnerByConstructionSite.Code;
dbEntry.StartDate = businessPartnerByConstructionSite.StartDate;
dbEntry.EndDate = businessPartnerByConstructionSite.EndDate;
dbEntry.RealEndDate = businessPartnerByConstructionSite.RealEndDate;
dbEntry.MaxNumOfEmployees = businessPartnerByConstructionSite.MaxNumOfEmployees;
dbEntry.BusinessPartnerCount = businessPartnerByConstructionSite.BusinessPartnerCount;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public BusinessPartnerByConstructionSiteResponse Create(BusinessPartnerByConstructionSiteViewModel re)
{
BusinessPartnerByConstructionSiteResponse response = new BusinessPartnerByConstructionSiteResponse();
try
{
BusinessPartnerByConstructionSite addedBusinessPartnerByConstructionSite = unitOfWork.GetBusinessPartnerByConstructionSiteRepository().Create(re.ConvertToBusinessPartnerByConstructionSite());
unitOfWork.Save();
response.BusinessPartnerByConstructionSite = addedBusinessPartnerByConstructionSite.ConvertToBusinessPartnerByConstructionSiteViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.BusinessPartnerByConstructionSite = new BusinessPartnerByConstructionSiteViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public BusinessPartnerByConstructionSiteResponse Delete(BusinessPartnerByConstructionSiteViewModel businessPartnerByConstructionSite)
{
BusinessPartnerByConstructionSiteResponse response = new BusinessPartnerByConstructionSiteResponse();
try
{
// First remove all employees on that construction site and that company
var employeesByConstructionSite = unitOfWork.GetEmployeeByConstructionSiteRepository().GetEmployeeByConstructionSitesAndBusinessPartner(
businessPartnerByConstructionSite.Company.Id, businessPartnerByConstructionSite.ConstructionSite.Id, businessPartnerByConstructionSite.BusinessPartner.Id);
if (employeesByConstructionSite != null)
{
foreach (var item in employeesByConstructionSite)
{
unitOfWork.GetEmployeeByConstructionSiteRepository().Delete(item);
Employee employee = unitOfWork.GetEmployeeRepository().GetEmployee((int)item.EmployeeId);
employee.ConstructionSiteCode = "";
employee.ConstructionSiteName = "";
employee.UpdatedAt = DateTime.Now;
}
}
BusinessPartnerByConstructionSite deletedBusinessPartnerByConstructionSite = unitOfWork.GetBusinessPartnerByConstructionSiteRepository()
.Delete(businessPartnerByConstructionSite.ConvertToBusinessPartnerByConstructionSite());
unitOfWork.Save();
response.BusinessPartnerByConstructionSite = deletedBusinessPartnerByConstructionSite.ConvertToBusinessPartnerByConstructionSiteViewModel();
response.Success = true;
}
catch (Exception ex)
{
response.BusinessPartnerByConstructionSite = new BusinessPartnerByConstructionSiteViewModel();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public static BusinessPartnerByConstructionSiteViewModel ConvertToBusinessPartnerByConstructionSiteViewModelLite(this BusinessPartnerByConstructionSite businessPartnerByConstructionSite)
{
BusinessPartnerByConstructionSiteViewModel remedyViewModel = new BusinessPartnerByConstructionSiteViewModel()
{
Id = businessPartnerByConstructionSite.Id,
Identifier = businessPartnerByConstructionSite.Identifier,
Code = businessPartnerByConstructionSite.Code,
StartDate = businessPartnerByConstructionSite.StartDate,
EndDate = businessPartnerByConstructionSite.EndDate,
RealEndDate = businessPartnerByConstructionSite.RealEndDate,
BusinessPartnerCount = businessPartnerByConstructionSite.BusinessPartnerCount,
MaxNumOfEmployees = businessPartnerByConstructionSite.MaxNumOfEmployees,
IsActive = businessPartnerByConstructionSite.Active,
UpdatedAt = businessPartnerByConstructionSite.UpdatedAt,
CreatedAt = businessPartnerByConstructionSite.CreatedAt
};
return(remedyViewModel);
}
public List <BusinessPartnerByConstructionSite> GetBusinessPartnerByConstructionSites(int companyId)
{
List <BusinessPartnerByConstructionSite> BusinessPartnerByConstructionSites = new List <BusinessPartnerByConstructionSite>();
string queryString =
"SELECT BusinessPartnerByConstructionSiteId, BusinessPartnerByConstructionSiteIdentifier, BusinessPartnerByConstructionSiteCode, StartDate, EndDate, RealEndDate, MaxNumOfEmployees, " +
"BusinessPartnerId, BusinessPartnerIdentifier, BusinessPartnerCode, BusinessPartnerName, BusinessPartnerInternalCode, BusinessPartnerNameGer, " +
"BusinessPartnerCount, " +
"ConstructionSiteId, ConstructionSiteIdentifier, ConstructionSiteCode, ConstructionSiteName, " +
"Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vBusinessPartnerByConstructionSites " +
"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())
{
BusinessPartnerByConstructionSite businessPartnerByConstructionSite;
while (reader.Read())
{
businessPartnerByConstructionSite = new BusinessPartnerByConstructionSite();
businessPartnerByConstructionSite.Id = Int32.Parse(reader["BusinessPartnerByConstructionSiteId"].ToString());
businessPartnerByConstructionSite.Identifier = Guid.Parse(reader["BusinessPartnerByConstructionSiteIdentifier"].ToString());
businessPartnerByConstructionSite.Code = reader["BusinessPartnerByConstructionSiteCode"].ToString();
if (reader["StartDate"] != DBNull.Value)
{
businessPartnerByConstructionSite.StartDate = DateTime.Parse(reader["StartDate"].ToString());
}
if (reader["EndDate"] != DBNull.Value)
{
businessPartnerByConstructionSite.EndDate = DateTime.Parse(reader["EndDate"].ToString());
}
if (reader["RealEndDate"] != DBNull.Value)
{
businessPartnerByConstructionSite.RealEndDate = DateTime.Parse(reader["RealEndDate"]?.ToString());
}
if (reader["MaxNumOfEmployees"] != DBNull.Value)
{
businessPartnerByConstructionSite.MaxNumOfEmployees = Int32.Parse(reader["MaxNumOfEmployees"].ToString());
}
if (reader["BusinessPartnerId"] != DBNull.Value)
{
businessPartnerByConstructionSite.BusinessPartner = new BusinessPartner();
businessPartnerByConstructionSite.BusinessPartnerId = Int32.Parse(reader["BusinessPartnerId"].ToString());
businessPartnerByConstructionSite.BusinessPartner.Id = Int32.Parse(reader["BusinessPartnerId"].ToString());
businessPartnerByConstructionSite.BusinessPartner.Identifier = Guid.Parse(reader["BusinessPartnerIdentifier"].ToString());
businessPartnerByConstructionSite.BusinessPartner.Code = reader["BusinessPartnerCode"].ToString();
businessPartnerByConstructionSite.BusinessPartner.Name = reader["BusinessPartnerName"].ToString();
businessPartnerByConstructionSite.BusinessPartner.InternalCode = reader["BusinessPartnerInternalCode"].ToString();
businessPartnerByConstructionSite.BusinessPartner.NameGer = reader["BusinessPartnerNameGer"].ToString();
}
if (reader["BusinessPartnerCount"] != DBNull.Value)
{
businessPartnerByConstructionSite.BusinessPartnerCount = Int32.Parse(reader["BusinessPartnerCount"].ToString());
}
if (reader["ConstructionSiteId"] != DBNull.Value)
{
businessPartnerByConstructionSite.ConstructionSite = new ConstructionSite();
businessPartnerByConstructionSite.ConstructionSiteId = Int32.Parse(reader["ConstructionSiteId"].ToString());
businessPartnerByConstructionSite.ConstructionSite.Id = Int32.Parse(reader["ConstructionSiteId"].ToString());
businessPartnerByConstructionSite.ConstructionSite.Identifier = Guid.Parse(reader["ConstructionSiteIdentifier"].ToString());
businessPartnerByConstructionSite.ConstructionSite.Code = reader["ConstructionSiteCode"].ToString();
businessPartnerByConstructionSite.ConstructionSite.Name = reader["ConstructionSiteName"].ToString();
}
businessPartnerByConstructionSite.Active = bool.Parse(reader["Active"].ToString());
businessPartnerByConstructionSite.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
businessPartnerByConstructionSite.CreatedBy = new User();
businessPartnerByConstructionSite.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
businessPartnerByConstructionSite.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
businessPartnerByConstructionSite.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
businessPartnerByConstructionSite.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
businessPartnerByConstructionSite.Company = new Company();
businessPartnerByConstructionSite.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
businessPartnerByConstructionSite.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
businessPartnerByConstructionSite.Company.Name = reader["CompanyName"].ToString();
}
BusinessPartnerByConstructionSites.Add(businessPartnerByConstructionSite);
}
}
}
return(BusinessPartnerByConstructionSites);
}
