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