public int Close(PromotionsRecords PromotionRecordObj)
{
try
{
using (var db = new HCMEntities())
{
PromotionsRecords PromotionRecord = db.PromotionsRecords.Find(PromotionRecordObj.PromotionRecordID);
PromotionRecord.PromotionRecordStatusID = PromotionRecordObj.PromotionRecordStatusID;
PromotionRecord.ClosingBy = PromotionRecordObj.ClosingBy;
PromotionRecord.ClosingTime = PromotionRecordObj.ClosingTime;
PromotionRecord.LastUpdatedBy = PromotionRecordObj.LastUpdatedBy;
PromotionRecord.LastUpdatedDate = PromotionRecordObj.LastUpdatedDate;
foreach (PromotionsRecordsEmployees PromotionRecordEmployeeObj in PromotionRecordObj.PromotionsRecordsEmployees)
{
PromotionsRecordsEmployees PromotionRecordEmployee = db.PromotionsRecordsEmployees.Find(PromotionRecordEmployeeObj.PromotionRecordEmployeeID);
PromotionsRecordsJobsVacancies PromotionRecordJobVacancy = db.PromotionsRecordsJobsVacancies.Find(PromotionRecordEmployeeObj.PromotionsRecordsJobsVacancies.PromotionRecordJobVacancyID);
OrganizationsJobs OrganizationJobVacancy = db.OrganizationsJobs.Find(PromotionRecordEmployeeObj.PromotionsRecordsJobsVacancies.OrganizationsJobs.OrganizationJobID);
OrganizationJobVacancy.IsVacant = PromotionRecordEmployeeObj.PromotionsRecordsJobsVacancies.OrganizationsJobs.IsVacant;
OrganizationJobVacancy.IsReserved = PromotionRecordEmployeeObj.PromotionsRecordsJobsVacancies.OrganizationsJobs.IsReserved;
OrganizationJobVacancy.LastUpdatedBy = PromotionRecordEmployeeObj.PromotionsRecordsJobsVacancies.OrganizationsJobs.LastUpdatedBy.Value;
OrganizationJobVacancy.LastUpdatedDate = PromotionRecordEmployeeObj.PromotionsRecordsJobsVacancies.OrganizationsJobs.LastUpdatedDate;
EmployeesCareersHistory CurrentEmployeeCareerHistory = db.EmployeesCareersHistory.Find(PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.EmployeeCareerHistoryID);
CurrentEmployeeCareerHistory.IsActive = PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.IsActive;
CurrentEmployeeCareerHistory.LastUpdatedBy = PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.LastUpdatedBy.Value;
CurrentEmployeeCareerHistory.LastUpdatedDate = PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.LastUpdatedDate;
OrganizationsJobs CurrentOrganizationJob = db.OrganizationsJobs.Find(PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.OrganizationsJobs.OrganizationJobID);
CurrentOrganizationJob.IsVacant = PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.OrganizationsJobs.IsVacant;
CurrentOrganizationJob.LastUpdatedBy = PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.OrganizationsJobs.LastUpdatedBy.Value;
CurrentOrganizationJob.LastUpdatedDate = PromotionRecordEmployeeObj.CurrentEmployeesCareersHistory.OrganizationsJobs.LastUpdatedDate;
EmployeesCareersHistory NewEmployeeCareerHistory = new EmployeesCareersHistory();
NewEmployeeCareerHistory.EmployeeCodeID = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.EmployeeCodeID;
NewEmployeeCareerHistory.CareerHistoryTypeID = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.CareerHistoryTypeID;
NewEmployeeCareerHistory.OrganizationJobID = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.OrganizationJobID;
NewEmployeeCareerHistory.JoinDate = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.JoinDate;
NewEmployeeCareerHistory.CareerDegreeID = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.CareerDegreeID;
NewEmployeeCareerHistory.TransactionStartDate = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.TransactionStartDate;
NewEmployeeCareerHistory.CreatedBy = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.CreatedBy;
NewEmployeeCareerHistory.CreatedDate = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.CreatedDate;
NewEmployeeCareerHistory.IsActive = PromotionRecordEmployeeObj.NewEmployeesCareersHistory.IsActive;
PromotionRecordEmployee.NewEmployeesCareersHistory = NewEmployeeCareerHistory;
}
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int Insert(PromotionsRecordsEmployees PromotionRecordEmployee)
{
try
{
using (var db = new HCMEntities())
{
db.PromotionsRecordsEmployees.Add(PromotionRecordEmployee);
db.SaveChanges();
return(PromotionRecordEmployee.PromotionRecordEmployeeID);
}
}
catch
{
throw;
}
}
public int Delete(int PromotionRecordEmployeeID, int UserIdentity)
{
try
{
using (var db = new HCMEntities())
{
PromotionsRecordsEmployees PromotionRecordEmployeeObj = db.PromotionsRecordsEmployees.FirstOrDefault(x => x.PromotionRecordEmployeeID.Equals(PromotionRecordEmployeeID));
db.PromotionsRecordsEmployees.Remove(PromotionRecordEmployeeObj);
return(db.SaveChanges(UserIdentity));
}
}
catch
{
throw;
}
}
public int UpdateExamResult(int PromotionRecordEmployeeID, decimal?ExamResult, int LastUpdatedBy)
{
try
{
using (var db = new HCMEntities())
{
PromotionsRecordsEmployees PromotionsRecordsEmployeesObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(PromotionRecordEmployeeID));
PromotionsRecordsEmployeesObj.ByExamResult = ExamResult;
PromotionsRecordsEmployeesObj.LastUpdatedBy = LastUpdatedBy;
PromotionsRecordsEmployeesObj.LastUpdatedDate = DateTime.Now;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int UpdateActualTaskPerformancePoints(int PromotionRecordEmployeeID, decimal ActualTaskPerformancePoints, int LastUpdatedBy)
{
try
{
using (var db = new HCMEntities())
{
PromotionsRecordsEmployees PromotionsRecordsEmployeesObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(PromotionRecordEmployeeID));
PromotionsRecordsEmployeesObj.ActualTaskPerformancePoints = ActualTaskPerformancePoints;
PromotionsRecordsEmployeesObj.LastUpdatedBy = LastUpdatedBy;
PromotionsRecordsEmployeesObj.LastUpdatedDate = DateTime.Now;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int UpdateDeserveExtraBonus(PromotionsRecordsEmployees PromotionRecordEmployee)
{
try
{
using (var db = new HCMEntities())
{
PromotionsRecordsEmployees PromotionsRecordsEmployeesObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(PromotionRecordEmployee.PromotionRecordEmployeeID));
PromotionsRecordsEmployeesObj.IsDeserveExtraBonus = PromotionRecordEmployee.IsDeserveExtraBonus;
PromotionsRecordsEmployeesObj.LastUpdatedBy = PromotionRecordEmployee.LastUpdatedBy;
PromotionsRecordsEmployeesObj.LastUpdatedDate = PromotionRecordEmployee.LastUpdatedDate;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int RemoveAndRedistributeJobs(List <PromotionsRecordsEmployees> PromotionRecordEmployeeList, int UserIdentity)
{
try
{
int result = 0;
using (var db = new HCMEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
foreach (var PromotionRecordEmployee in PromotionRecordEmployeeList.OrderBy(e => e.PromotionRecordJobVacancyID.HasValue ? e.PromotionRecordJobVacancyID.Value : 0))
{
PromotionsRecordsEmployees PromotionsRecordsEmployeesObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(PromotionRecordEmployee.PromotionRecordEmployeeID));
PromotionsRecordsEmployeesObj.PromotionRecordJobVacancyID = PromotionRecordEmployee.PromotionRecordJobVacancyID;
if (PromotionRecordEmployee.RemovingBy != null)
{
PromotionsRecordsEmployeesObj.RemovingBy = PromotionRecordEmployee.RemovingBy;
PromotionsRecordsEmployeesObj.RemovingReason = PromotionRecordEmployee.RemovingReason;
}
PromotionsRecordsEmployeesObj.IsRemovedAfterIncluding = PromotionRecordEmployee.IsRemovedAfterIncluding;
PromotionsRecordsEmployeesObj.PromotionDecisionID = PromotionRecordEmployee.PromotionDecisionID;
PromotionsRecordsEmployeesObj.LastUpdatedBy = PromotionRecordEmployee.LastUpdatedBy;
PromotionsRecordsEmployeesObj.LastUpdatedDate = PromotionRecordEmployee.LastUpdatedDate;
result = db.SaveChanges(UserIdentity);// db.PromotionsRecordsEmployees.AddOrUpdate(PromotionsRecordsEmployeesObj);
}
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
throw;
}
}
return(result);
}
}
catch
{
throw;
}
}
public int IncludeAgainAfterRemoved(int PromotionRecordEmployeeID, int LastUpdatedBy)
{
try
{
using (var db = new HCMEntities())
{
PromotionsRecordsEmployees PromotionsRecordsEmployeesObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(PromotionRecordEmployeeID));
PromotionsRecordsEmployeesObj.PromotionRecordJobVacancyID = null;
PromotionsRecordsEmployeesObj.RemovingBy = null;
PromotionsRecordsEmployeesObj.RemovingReason = string.Empty;
PromotionsRecordsEmployeesObj.IsRemovedAfterIncluding = (bool?)null;
PromotionsRecordsEmployeesObj.PromotionDecisionID = null;
PromotionsRecordsEmployeesObj.LastUpdatedBy = LastUpdatedBy;
PromotionsRecordsEmployeesObj.LastUpdatedDate = DateTime.Now;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}
public int ResetByExamResults(List <PromotionsRecordsEmployees> PromotionRecordEmployeeList)
{
try
{
int result = 0;
using (var db = new HCMEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
foreach (var PromotionRecordEmployee in PromotionRecordEmployeeList.OrderBy(e => e.PromotionRecordJobVacancyID.HasValue ? e.PromotionRecordJobVacancyID.Value : 0))
{
PromotionsRecordsEmployees PromotionsRecordsEmployeesObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(PromotionRecordEmployee.PromotionRecordEmployeeID));
PromotionsRecordsEmployeesObj.ByExamResult = PromotionRecordEmployee.ByExamResult;
PromotionsRecordsEmployeesObj.LastUpdatedBy = PromotionRecordEmployee.LastUpdatedBy;
PromotionsRecordsEmployeesObj.LastUpdatedDate = PromotionRecordEmployee.LastUpdatedDate;
result = db.SaveChanges();// db.PromotionsRecordsEmployees.AddOrUpdate(PromotionsRecordsEmployeesObj);
}
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
throw;
}
}
return(result);
}
}
catch
{
throw;
}
}
public int ShuffleJob(PromotionsRecordsEmployees CurrentEmployee, PromotionsRecordsEmployees NewEmployee)
{
try
{
int result = 0;
using (var db = new HCMEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
int?CurrentPromotionRecordJobVacancyID = CurrentEmployee.PromotionRecordJobVacancyID;
int?NewPromotionRecordJobVacancyID = NewEmployee.PromotionRecordJobVacancyID;
// first make both objects vacancyID = null
PromotionsRecordsEmployees CurrentEmployeeObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(CurrentEmployee.PromotionRecordEmployeeID));
CurrentEmployeeObj.PromotionRecordJobVacancyID = null;
CurrentEmployeeObj.LastUpdatedBy = CurrentEmployee.LastUpdatedBy;
CurrentEmployeeObj.LastUpdatedDate = DateTime.Now;
PromotionsRecordsEmployees NewEmployeeObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(NewEmployee.PromotionRecordEmployeeID));
NewEmployeeObj.PromotionRecordJobVacancyID = null;
NewEmployeeObj.LastUpdatedBy = NewEmployeeObj.LastUpdatedBy;
NewEmployeeObj.LastUpdatedDate = DateTime.Now;
db.PromotionsRecordsEmployees.AddOrUpdate(CurrentEmployeeObj);
db.PromotionsRecordsEmployees.AddOrUpdate(NewEmployeeObj);
result = db.SaveChanges();
// now shuffle the vacancy ID
CurrentEmployeeObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(CurrentEmployee.PromotionRecordEmployeeID));
CurrentEmployeeObj.PromotionRecordJobVacancyID = NewPromotionRecordJobVacancyID;
CurrentEmployeeObj.LastUpdatedBy = CurrentEmployee.LastUpdatedBy;
CurrentEmployeeObj.LastUpdatedDate = DateTime.Now;
NewEmployeeObj = db.PromotionsRecordsEmployees.SingleOrDefault(x => x.PromotionRecordEmployeeID.Equals(NewEmployee.PromotionRecordEmployeeID));
NewEmployeeObj.PromotionRecordJobVacancyID = CurrentPromotionRecordJobVacancyID;
NewEmployeeObj.LastUpdatedBy = NewEmployeeObj.LastUpdatedBy;
NewEmployeeObj.LastUpdatedDate = DateTime.Now;
db.PromotionsRecordsEmployees.AddOrUpdate(CurrentEmployeeObj);
db.PromotionsRecordsEmployees.AddOrUpdate(NewEmployeeObj);
result = db.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
throw;
}
}
return(result);
}
}
catch
{
throw;
}
}