public static EmployeeByConstructionSite ConvertToEmployeeByConstructionSite(this EmployeeByConstructionSiteViewModel employeeByConstructionSiteViewModel) { EmployeeByConstructionSite employeeByConstructionSite = new EmployeeByConstructionSite() { Id = employeeByConstructionSiteViewModel.Id, Identifier = employeeByConstructionSiteViewModel.Identifier, Code = employeeByConstructionSiteViewModel.Code, StartDate = employeeByConstructionSiteViewModel.StartDate, EndDate = employeeByConstructionSiteViewModel.EndDate, RealEndDate = employeeByConstructionSiteViewModel.RealEndDate, EmployeeId = employeeByConstructionSiteViewModel.Employee?.Id ?? null, EmployeeCount = employeeByConstructionSiteViewModel.EmployeeCount, BusinessPartnerId = employeeByConstructionSiteViewModel.BusinessPartner?.Id ?? null, BusinessPartnerCount = employeeByConstructionSiteViewModel.BusinessPartnerCount, ConstructionSiteId = employeeByConstructionSiteViewModel.ConstructionSite?.Id ?? null, CreatedById = employeeByConstructionSiteViewModel.CreatedBy?.Id ?? null, CompanyId = employeeByConstructionSiteViewModel.Company?.Id ?? null, CreatedAt = employeeByConstructionSiteViewModel.CreatedAt, UpdatedAt = employeeByConstructionSiteViewModel.UpdatedAt }; return(employeeByConstructionSite); }
public EmployeeByConstructionSite Delete(EmployeeByConstructionSite employeeByConstructionSite) { // Load EmployeeByConstructionSite that will be deleted EmployeeByConstructionSite dbEntry = context.EmployeeByConstructionSites .Include(x => x.Employee) .Include(x => x.CreatedBy) .FirstOrDefault(x => x.Identifier == employeeByConstructionSite.Identifier); if (dbEntry != null) { // Set activity dbEntry.Active = false; dbEntry.RealEndDate = employeeByConstructionSite.RealEndDate; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); }
public EmployeeByConstructionSiteResponse Create(EmployeeByConstructionSiteViewModel re) { EmployeeByConstructionSiteResponse response = new EmployeeByConstructionSiteResponse(); try { ConstructionSite constructionSite = unitOfWork.GetConstructionSiteRepository().GetConstructionSite(re.ConstructionSite.Id); Employee employee = unitOfWork.GetEmployeeRepository().GetEmployeeEntity(re.Employee.Id); employee.ConstructionSiteCode = constructionSite.InternalCode; employee.ConstructionSiteName = constructionSite.Name; employee.UpdatedAt = DateTime.Now; EmployeeByConstructionSite addedEmployeeByConstructionSite = unitOfWork.GetEmployeeByConstructionSiteRepository().Create(re.ConvertToEmployeeByConstructionSite()); EmployeeCard ec = new EmployeeCard() { Identifier = Guid.NewGuid(), EmployeeId = re.Employee.Id, CardDate = addedEmployeeByConstructionSite.StartDate, Description = "Radnik " + employee?.Name + " " + employee?.SurName + " je krenuo da radi na gradilištu " + constructionSite?.Name + ". Radnik je na gradilištu od: " + re.StartDate.ToString("dd.MM.yyyy") + " do " + re.EndDate.ToString("dd.MM.yyyy"), PlusMinus = "+", CreatedById = re.CreatedBy?.Id, CompanyId = re.Company?.Id, CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now }; unitOfWork.GetEmployeeCardRepository().Create(ec); unitOfWork.Save(); response.EmployeeByConstructionSite = addedEmployeeByConstructionSite.ConvertToEmployeeByConstructionSiteViewModel(); response.Success = true; } catch (Exception ex) { response.EmployeeByConstructionSite = new EmployeeByConstructionSiteViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public EmployeeByConstructionSite Create(EmployeeByConstructionSite employeeByConstructionSite) { if (context.EmployeeByConstructionSites.Where(x => x.Identifier != null && x.Identifier == employeeByConstructionSite.Identifier).Count() == 0) { employeeByConstructionSite.Id = 0; employeeByConstructionSite.Code = GetNewCodeValue(employeeByConstructionSite.CompanyId ?? 0); employeeByConstructionSite.Active = true; employeeByConstructionSite.UpdatedAt = DateTime.Now; employeeByConstructionSite.CreatedAt = DateTime.Now; context.EmployeeByConstructionSites.Add(employeeByConstructionSite); return(employeeByConstructionSite); } else { // Load employeeByConstructionSite that will be updated EmployeeByConstructionSite dbEntry = context.EmployeeByConstructionSites .FirstOrDefault(x => x.Identifier == employeeByConstructionSite.Identifier && x.Active == true); if (dbEntry != null) { dbEntry.EmployeeId = employeeByConstructionSite.EmployeeId ?? null; dbEntry.BusinessPartnerId = employeeByConstructionSite.BusinessPartnerId ?? null; dbEntry.CompanyId = employeeByConstructionSite.CompanyId ?? null; dbEntry.CreatedById = employeeByConstructionSite.CreatedById ?? null; // Set properties dbEntry.Code = employeeByConstructionSite.Code; dbEntry.StartDate = employeeByConstructionSite.StartDate; dbEntry.EndDate = employeeByConstructionSite.EndDate; dbEntry.RealEndDate = employeeByConstructionSite.RealEndDate; dbEntry.EmployeeCount = employeeByConstructionSite.EmployeeCount; // Set timestamp dbEntry.UpdatedAt = DateTime.Now; } return(dbEntry); } }
public EmployeeByConstructionSiteResponse Delete(EmployeeByConstructionSiteViewModel re) { EmployeeByConstructionSiteResponse response = new EmployeeByConstructionSiteResponse(); try { EmployeeByConstructionSite deletedEmployeeByConstructionSite = unitOfWork.GetEmployeeByConstructionSiteRepository().Delete(re.ConvertToEmployeeByConstructionSite()); Employee employee = unitOfWork.GetEmployeeRepository().GetEmployeeEntity((int)deletedEmployeeByConstructionSite.EmployeeId); ConstructionSite constructionSite = unitOfWork.GetConstructionSiteRepository().GetConstructionSite((int)deletedEmployeeByConstructionSite.ConstructionSiteId); employee.ConstructionSiteCode = ""; employee.ConstructionSiteName = ""; employee.UpdatedAt = DateTime.Now; EmployeeCard ec = new EmployeeCard() { Identifier = Guid.NewGuid(), EmployeeId = deletedEmployeeByConstructionSite.Employee.Id, CardDate = (DateTime)deletedEmployeeByConstructionSite.RealEndDate, Description = "Radnik " + employee?.Name + " " + employee.SurName + " je prestao da radi na gradilištu " + constructionSite?.Name + ". Prestanak je od: " + ((DateTime)deletedEmployeeByConstructionSite.RealEndDate).ToString("dd.MM.yyyy"), CreatedById = deletedEmployeeByConstructionSite.CreatedById, PlusMinus = "-", CompanyId = deletedEmployeeByConstructionSite.CompanyId, CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now }; unitOfWork.GetEmployeeCardRepository().Create(ec); unitOfWork.Save(); response.EmployeeByConstructionSite = deletedEmployeeByConstructionSite.ConvertToEmployeeByConstructionSiteViewModel(); response.Success = true; } catch (Exception ex) { response.EmployeeByConstructionSite = new EmployeeByConstructionSiteViewModel(); response.Success = false; response.Message = ex.Message; } return(response); }
public static EmployeeByConstructionSiteViewModel ConvertToEmployeeByConstructionSiteViewModelLite(this EmployeeByConstructionSite employeeByConstructionSite) { EmployeeByConstructionSiteViewModel remedyViewModel = new EmployeeByConstructionSiteViewModel() { Id = employeeByConstructionSite.Id, Identifier = employeeByConstructionSite.Identifier, Code = employeeByConstructionSite.Code, StartDate = employeeByConstructionSite.StartDate, EndDate = employeeByConstructionSite.EndDate, RealEndDate = employeeByConstructionSite.RealEndDate, EmployeeCount = employeeByConstructionSite.EmployeeCount, BusinessPartnerCount = employeeByConstructionSite.BusinessPartnerCount, IsActive = employeeByConstructionSite.Active, UpdatedAt = employeeByConstructionSite.UpdatedAt, CreatedAt = employeeByConstructionSite.CreatedAt }; return(remedyViewModel); }
public List <EmployeeByConstructionSite> GetEmployeeByConstructionSites(int companyId) { List <EmployeeByConstructionSite> EmployeeByConstructionSites = new List <EmployeeByConstructionSite>(); string queryString = "SELECT EmployeeByConstructionSiteId, EmployeeByConstructionSiteIdentifier, EmployeeByConstructionSiteCode, StartDate, EndDate, RealEndDate, " + "EmployeeId, EmployeeIdentifier, EmployeeCode, EmployeeName, EmployeeEmployeeCode, " + "EmployeeCount, " + "BusinessPartnerId, BusinessPartnerIdentifier, BusinessPartnerCode, BusinessPartnerName, " + "BusinessPartnerCount, " + "ConstructionSiteId, ConstructionSiteIdentifier, ConstructionSiteCode, ConstructionSiteName, " + "Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " + "FROM vEmployeeByConstructionSites " + "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()) { EmployeeByConstructionSite employeeByConstructionSite; while (reader.Read()) { employeeByConstructionSite = new EmployeeByConstructionSite(); employeeByConstructionSite.Id = Int32.Parse(reader["EmployeeByConstructionSiteId"].ToString()); employeeByConstructionSite.Identifier = Guid.Parse(reader["EmployeeByConstructionSiteIdentifier"].ToString()); employeeByConstructionSite.Code = reader["EmployeeByConstructionSiteCode"].ToString(); if (reader["StartDate"] != DBNull.Value) { employeeByConstructionSite.StartDate = DateTime.Parse(reader["StartDate"].ToString()); } if (reader["EndDate"] != DBNull.Value) { employeeByConstructionSite.EndDate = DateTime.Parse(reader["EndDate"].ToString()); } if (reader["RealEndDate"] != DBNull.Value) { employeeByConstructionSite.RealEndDate = DateTime.Parse(reader["RealEndDate"]?.ToString()); } if (reader["EmployeeId"] != DBNull.Value) { employeeByConstructionSite.Employee = new Employee(); employeeByConstructionSite.EmployeeId = Int32.Parse(reader["EmployeeId"].ToString()); employeeByConstructionSite.Employee.Id = Int32.Parse(reader["EmployeeId"].ToString()); employeeByConstructionSite.Employee.Identifier = Guid.Parse(reader["EmployeeIdentifier"].ToString()); employeeByConstructionSite.Employee.Code = reader["EmployeeCode"].ToString(); employeeByConstructionSite.Employee.Name = reader["EmployeeName"].ToString(); employeeByConstructionSite.Employee.EmployeeCode = reader["EmployeeEmployeeCode"].ToString(); } if (reader["EmployeeCount"] != DBNull.Value) { employeeByConstructionSite.EmployeeCount = Int32.Parse(reader["EmployeeCount"].ToString()); } if (reader["BusinessPartnerId"] != DBNull.Value) { employeeByConstructionSite.BusinessPartner = new BusinessPartner(); employeeByConstructionSite.BusinessPartnerId = Int32.Parse(reader["BusinessPartnerId"].ToString()); employeeByConstructionSite.BusinessPartner.Id = Int32.Parse(reader["BusinessPartnerId"].ToString()); employeeByConstructionSite.BusinessPartner.Identifier = Guid.Parse(reader["BusinessPartnerIdentifier"].ToString()); employeeByConstructionSite.BusinessPartner.Code = reader["BusinessPartnerCode"].ToString(); employeeByConstructionSite.BusinessPartner.Name = reader["BusinessPartnerName"].ToString(); } if (reader["BusinessPartnerCount"] != DBNull.Value) { employeeByConstructionSite.BusinessPartnerCount = Int32.Parse(reader["BusinessPartnerCount"].ToString()); } if (reader["ConstructionSiteId"] != DBNull.Value) { employeeByConstructionSite.ConstructionSite = new ConstructionSite(); employeeByConstructionSite.ConstructionSiteId = Int32.Parse(reader["ConstructionSiteId"].ToString()); employeeByConstructionSite.ConstructionSite.Id = Int32.Parse(reader["ConstructionSiteId"].ToString()); employeeByConstructionSite.ConstructionSite.Identifier = Guid.Parse(reader["ConstructionSiteIdentifier"].ToString()); employeeByConstructionSite.ConstructionSite.Code = reader["ConstructionSiteCode"].ToString(); employeeByConstructionSite.ConstructionSite.Name = reader["ConstructionSiteName"].ToString(); } employeeByConstructionSite.Active = bool.Parse(reader["Active"].ToString()); employeeByConstructionSite.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString()); if (reader["CreatedById"] != DBNull.Value) { employeeByConstructionSite.CreatedBy = new User(); employeeByConstructionSite.CreatedById = Int32.Parse(reader["CreatedById"].ToString()); employeeByConstructionSite.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString()); employeeByConstructionSite.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString(); employeeByConstructionSite.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString(); } if (reader["CompanyId"] != DBNull.Value) { employeeByConstructionSite.Company = new Company(); employeeByConstructionSite.CompanyId = Int32.Parse(reader["CompanyId"].ToString()); employeeByConstructionSite.Company.Id = Int32.Parse(reader["CompanyId"].ToString()); employeeByConstructionSite.Company.Name = reader["CompanyName"].ToString(); } EmployeeByConstructionSites.Add(employeeByConstructionSite); } } } //List<EmployeeByConstructionSite> EmployeeByConstructionSites = context.EmployeeByConstructionSites // .Include(x => x.Employee) // .Include(x => x.BusinessPartner) // .Include(x => x.ConstructionSite) // .Include(x => x.Company) // .Include(x => x.CreatedBy) // .Where(x => x.Active == true && x.CompanyId == companyId) // .OrderByDescending(x => x.CreatedAt) // .AsNoTracking() // .ToList(); return(EmployeeByConstructionSites); }