public EmployeeProfession Create(EmployeeProfession EmployeeProfession)
{
if (context.EmployeeProfessions.Where(x => x.Identifier != null && x.Identifier == EmployeeProfession.Identifier).Count() == 0)
{
EmployeeProfession.Id = 0;
EmployeeProfession.Active = true;
EmployeeProfession.UpdatedAt = DateTime.Now;
EmployeeProfession.CreatedAt = DateTime.Now;
context.EmployeeProfessions.Add(EmployeeProfession);
return(EmployeeProfession);
}
else
{
// Load item that will be updated
EmployeeProfession dbEntry = context.EmployeeProfessions
.FirstOrDefault(x => x.Identifier == EmployeeProfession.Identifier && x.Active == true);
if (dbEntry != null)
{
dbEntry.ProfessionId = EmployeeProfession.ProfessionId ?? null;
dbEntry.CountryId = EmployeeProfession.CountryId ?? null;
dbEntry.CompanyId = EmployeeProfession.CompanyId ?? null;
dbEntry.CreatedById = EmployeeProfession.CreatedById ?? null;
dbEntry.ItemStatus = EmployeeProfession.ItemStatus;
// Set timestamp
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
}
public IActionResult DeleteEmployeeProfession(EmployeeProfession employeeProfession)
{
return(this.RunWithErrorHandling(() =>
{
databaseProvider.Execute("base.employeeprofession_delete", employeeProfession);
return Ok(true);
}));
}
public IActionResult InsertEmployeeProfession(EmployeeProfession employeeProfession)
{
return(this.RunWithErrorHandling(() =>
{
return Ok
(
databaseProvider.Query <EmployeeProfession>("base.employeeprofession_insert", employeeProfession).FirstOrDefault()
);
}));
}
public EmployeeProfession Delete(Guid identifier)
{
EmployeeProfession dbEntry = context.EmployeeProfessions
.Union(context.ChangeTracker.Entries()
.Where(x => x.State == EntityState.Added && x.Entity.GetType() == typeof(EmployeeProfession))
.Select(x => x.Entity as EmployeeProfession))
.FirstOrDefault(x => x.Identifier == identifier);
if (dbEntry != null)
{
dbEntry.Active = false;
dbEntry.UpdatedAt = DateTime.Now;
}
return(dbEntry);
}
public static EmployeeProfession ConvertToEmployeeProfession(this EmployeeProfessionItemViewModel EmployeeItemViewModel)
{
EmployeeProfession EmployeeItem = new EmployeeProfession()
{
Id = EmployeeItemViewModel.Id,
Identifier = EmployeeItemViewModel.Identifier,
EmployeeId = EmployeeItemViewModel.Employee?.Id ?? null,
ProfessionId = EmployeeItemViewModel.Profession?.Id ?? null,
CountryId = EmployeeItemViewModel.Country?.Id ?? null,
ItemStatus = EmployeeItemViewModel.ItemStatus,
Active = EmployeeItemViewModel.IsActive,
CreatedById = EmployeeItemViewModel.CreatedBy?.Id ?? null,
CompanyId = EmployeeItemViewModel.Company?.Id ?? null,
CreatedAt = EmployeeItemViewModel.CreatedAt,
UpdatedAt = EmployeeItemViewModel.UpdatedAt
};
return(EmployeeItem);
}
public List <EmployeeProfession> GetEmployeeItems(int companyId)
{
List <EmployeeProfession> EmployeeProfessions = new List <EmployeeProfession>();
string queryString =
"SELECT EmployeeProfessionId, EmployeeProfessionIdentifier, " +
"EmployeeId, EmployeeIdentifier, EmployeeCode, EmployeeName, " +
"ProfessionId, ProfessionIdentifier, ProfessionCode, ProfessionName, ProfessionSecondCode, " +
"CountryId, CountryIdentifier, CountryCode, CountryName, " +
"ItemStatus, Active, UpdatedAt, CreatedById, CreatedByFirstName, CreatedByLastName, CompanyId, CompanyName " +
"FROM vEmployeeProfessions " +
"WHERE CompanyId = @CompanyId;";
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())
{
EmployeeProfession employeeProfession;
while (reader.Read())
{
employeeProfession = new EmployeeProfession();
employeeProfession.Id = Int32.Parse(reader["EmployeeProfessionId"].ToString());
employeeProfession.Identifier = Guid.Parse(reader["EmployeeProfessionIdentifier"].ToString());
if (reader["EmployeeId"] != DBNull.Value)
{
employeeProfession.Employee = new Employee();
employeeProfession.EmployeeId = Int32.Parse(reader["EmployeeId"].ToString());
employeeProfession.Employee.Id = Int32.Parse(reader["EmployeeId"].ToString());
employeeProfession.Employee.Identifier = Guid.Parse(reader["EmployeeIdentifier"].ToString());
employeeProfession.Employee.Code = reader["EmployeeCode"].ToString();
employeeProfession.Employee.Name = reader["EmployeeName"].ToString();
}
if (reader["ProfessionId"] != DBNull.Value)
{
employeeProfession.Profession = new Profession();
employeeProfession.ProfessionId = Int32.Parse(reader["ProfessionId"].ToString());
employeeProfession.Profession.Id = Int32.Parse(reader["ProfessionId"].ToString());
employeeProfession.Profession.Identifier = Guid.Parse(reader["ProfessionIdentifier"].ToString());
employeeProfession.Profession.Code = reader["ProfessionCode"].ToString();
employeeProfession.Profession.Name = reader["ProfessionName"].ToString();
employeeProfession.Profession.SecondCode = reader["ProfessionSecondCode"].ToString();
}
if (reader["CountryId"] != DBNull.Value)
{
employeeProfession.Country = new Country();
employeeProfession.CountryId = Int32.Parse(reader["CountryId"].ToString());
employeeProfession.Country.Id = Int32.Parse(reader["CountryId"].ToString());
employeeProfession.Country.Identifier = Guid.Parse(reader["CountryIdentifier"].ToString());
employeeProfession.Country.Mark = reader["CountryCode"].ToString();
employeeProfession.Country.Name = reader["CountryName"].ToString();
}
if (reader["ItemStatus"] != DBNull.Value)
{
employeeProfession.ItemStatus = Int32.Parse(reader["ItemStatus"].ToString());
}
employeeProfession.Active = bool.Parse(reader["Active"].ToString());
employeeProfession.UpdatedAt = DateTime.Parse(reader["UpdatedAt"].ToString());
if (reader["CreatedById"] != DBNull.Value)
{
employeeProfession.CreatedBy = new User();
employeeProfession.CreatedById = Int32.Parse(reader["CreatedById"].ToString());
employeeProfession.CreatedBy.Id = Int32.Parse(reader["CreatedById"].ToString());
employeeProfession.CreatedBy.FirstName = reader["CreatedByFirstName"]?.ToString();
employeeProfession.CreatedBy.LastName = reader["CreatedByLastName"]?.ToString();
}
if (reader["CompanyId"] != DBNull.Value)
{
employeeProfession.Company = new Company();
employeeProfession.CompanyId = Int32.Parse(reader["CompanyId"].ToString());
employeeProfession.Company.Id = Int32.Parse(reader["CompanyId"].ToString());
employeeProfession.Company.Name = reader["CompanyName"].ToString();
}
EmployeeProfessions.Add(employeeProfession);
}
}
}
return(EmployeeProfessions);
//List<EmployeeProfession> EmployeeProfessions = context.EmployeeProfessions
// .Include(x => x.Employee)
// .Include(x => x.Profession)
// .Include(x => x.Country)
// .Include(x => x.Company)
// .Include(x => x.CreatedBy)
// .Where(x => x.Active == true && x.CompanyId == companyId)
// .AsNoTracking()
// .ToList();
//return EmployeeProfessions;
}
public static EmployeeProfessionItemViewModel ConvertToEmployeeProfessionViewModelLite(this EmployeeProfession EmployeeItem)
{
EmployeeProfessionItemViewModel EmployeeItemViewModel = new EmployeeProfessionItemViewModel()
{
Id = EmployeeItem.Id,
Identifier = EmployeeItem.Identifier,
ItemStatus = EmployeeItem.ItemStatus,
IsActive = EmployeeItem.Active,
UpdatedAt = EmployeeItem.UpdatedAt,
CreatedAt = EmployeeItem.CreatedAt
};
return(EmployeeItemViewModel);
}
public static EmployeeProfessionItemViewModel ConvertToEmployeeProfessionViewModel(this EmployeeProfession EmployeeItem)
{
EmployeeProfessionItemViewModel EmployeeItemViewModel = new EmployeeProfessionItemViewModel()
{
Id = EmployeeItem.Id,
Identifier = EmployeeItem.Identifier,
Employee = EmployeeItem.Employee?.ConvertToEmployeeViewModelLite(),
Profession = EmployeeItem.Profession?.ConvertToProfessionViewModelLite(),
Country = EmployeeItem.Country?.ConvertToCountryViewModelLite(),
ItemStatus = EmployeeItem.ItemStatus,
IsActive = EmployeeItem.Active,
CreatedBy = EmployeeItem.CreatedBy?.ConvertToUserViewModelLite(),
Company = EmployeeItem.Company?.ConvertToCompanyViewModelLite(),
UpdatedAt = EmployeeItem.UpdatedAt,
CreatedAt = EmployeeItem.CreatedAt
};
return(EmployeeItemViewModel);
}