/// <summary>
///
/// </summary>
/// <param name="HeadCount"></param>
/// <returns></returns>
public int UpdateHeadCount(List <HeadCountDTO> target, int typeID, int year, int projectID)
{
var source = GetHeadCountByType(typeID, year, projectID);
EmployeeRoleRepository employeeRepository = new EmployeeRoleRepository(BaseRepository.SystemUserID);
CountryRepository countryRepository = new CountryRepository(BaseRepository.SystemUserID);
// find and insert new items.
var newItems = target.Except(source, new HeadCountDTOComparer());
foreach (HeadCountDTO headCountDTO in newItems)
{
HeadCount HeadCount = new HeadCount();
HeadCount.ProjectID = projectID;
HeadCount.EmployeeRoleTypeID = typeID;
HeadCount.Year = year;
HeadCount.EmployeeRoleID = employeeRepository.GetEmployeeRole(headCountDTO.EmployeeRole).ID;
HeadCount.CountryID = countryRepository.GetCountry(headCountDTO.Country).ID;
HeadCount.Incremental = DataUtility.GetBooleanString(headCountDTO.Incremental);
HeadCount.Comment = headCountDTO.Comment;
HeadCount.Month01 = DataUtility.GetDecimalValue(headCountDTO.Month01);
HeadCount.Month02 = DataUtility.GetDecimalValue(headCountDTO.Month02);
HeadCount.Month03 = DataUtility.GetDecimalValue(headCountDTO.Month03);
HeadCount.Month04 = DataUtility.GetDecimalValue(headCountDTO.Month04);
HeadCount.Month05 = DataUtility.GetDecimalValue(headCountDTO.Month05);
HeadCount.Month06 = DataUtility.GetDecimalValue(headCountDTO.Month06);
HeadCount.Month07 = DataUtility.GetDecimalValue(headCountDTO.Month07);
HeadCount.Month08 = DataUtility.GetDecimalValue(headCountDTO.Month08);
HeadCount.Month09 = DataUtility.GetDecimalValue(headCountDTO.Month09);
HeadCount.Month10 = DataUtility.GetDecimalValue(headCountDTO.Month10);
HeadCount.Month11 = DataUtility.GetDecimalValue(headCountDTO.Month11);
HeadCount.Month12 = DataUtility.GetDecimalValue(headCountDTO.Month12);
CreateHeadCount(HeadCount);
}
// find and insert new items.
var updateItems = target.Union(source, new HeadCountDTOComparer());
foreach (HeadCountDTO headCountDTO in updateItems)
{
int employeeRoleID = employeeRepository.GetEmployeeRole(headCountDTO.EmployeeRole).ID;
HeadCount HeadCount = GetHeadCount(typeID, year, projectID, employeeRoleID);
HeadCount.EmployeeRoleTypeID = typeID;
HeadCount.Year = year;
HeadCount.ProjectID = projectID;
HeadCount.EmployeeRoleID = employeeRoleID;
HeadCount.CountryID = countryRepository.GetCountry(headCountDTO.Country).ID;
HeadCount.Incremental = DataUtility.GetBooleanString(headCountDTO.Incremental);
HeadCount.Comment = headCountDTO.Comment;
HeadCount.Month01 = DataUtility.GetDecimalValue(headCountDTO.Month01);
HeadCount.Month02 = DataUtility.GetDecimalValue(headCountDTO.Month02);
HeadCount.Month03 = DataUtility.GetDecimalValue(headCountDTO.Month03);
HeadCount.Month04 = DataUtility.GetDecimalValue(headCountDTO.Month04);
HeadCount.Month05 = DataUtility.GetDecimalValue(headCountDTO.Month05);
HeadCount.Month06 = DataUtility.GetDecimalValue(headCountDTO.Month06);
HeadCount.Month07 = DataUtility.GetDecimalValue(headCountDTO.Month07);
HeadCount.Month08 = DataUtility.GetDecimalValue(headCountDTO.Month08);
HeadCount.Month09 = DataUtility.GetDecimalValue(headCountDTO.Month09);
HeadCount.Month10 = DataUtility.GetDecimalValue(headCountDTO.Month10);
HeadCount.Month11 = DataUtility.GetDecimalValue(headCountDTO.Month11);
HeadCount.Month12 = DataUtility.GetDecimalValue(headCountDTO.Month12);
UpdateHeadCount(HeadCount);
}
// find and delete items
var deleteItems = source.Except(target, new HeadCountDTOComparer());
foreach (HeadCountDTO HeadCountDTO in deleteItems)
{
int employeeRoleID = employeeRepository.GetEmployeeRole(HeadCountDTO.EmployeeRole).ID;
HeadCount HeadCount = GetHeadCount(typeID, year, projectID, employeeRoleID);
DeleteHeadCount(HeadCount.ID);
}
ctx.SaveChanges();
return(0);
}
/// <summary>
///
/// </summary>
/// <param name="ExpenseDetail"></param>
/// <returns></returns>
public int UpdateExpenseDetail(List <ExpenseDetailDTO> target, int typeID, int year, int projectID)
{
var source = GetExpenseDetailByType(typeID, year, projectID);
ExpenseRepository expenseRepository = new ExpenseRepository(BaseRepository.SystemUserID);
CountryRepository countryRepository = new CountryRepository(BaseRepository.SystemUserID);
// find and insert new items.
var newItems = target.Except(source, new ExpenseDetailDTOComparer());
foreach (ExpenseDetailDTO ExpenseDetailDTO in newItems)
{
ExpenseDetail ExpenseDetail = new ExpenseDetail();
ExpenseDetail.ProjectID = projectID;
ExpenseDetail.ExpenseTypeID = typeID;
ExpenseDetail.Year = year;
ExpenseDetail.ExpenseID = expenseRepository.GetExpense(ExpenseDetailDTO.Expense).ID;
ExpenseDetail.CountryID = countryRepository.GetCountry(ExpenseDetailDTO.Country).ID;
ExpenseDetail.Comment = ExpenseDetailDTO.Comment;
ExpenseDetail.Month01 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month01);
ExpenseDetail.Month02 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month02);
ExpenseDetail.Month03 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month03);
ExpenseDetail.Month04 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month04);
ExpenseDetail.Month05 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month05);
ExpenseDetail.Month06 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month06);
ExpenseDetail.Month07 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month07);
ExpenseDetail.Month08 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month08);
ExpenseDetail.Month09 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month09);
ExpenseDetail.Month10 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month10);
ExpenseDetail.Month11 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month11);
ExpenseDetail.Month12 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month12);
CreateExpenseDetail(ExpenseDetail);
}
// find and insert new items.
var updateItems = target.Union(source, new ExpenseDetailDTOComparer());
foreach (ExpenseDetailDTO ExpenseDetailDTO in updateItems)
{
int expenseID = expenseRepository.GetExpense(ExpenseDetailDTO.Expense).ID;
ExpenseDetail ExpenseDetail = GetExpenseDetail(typeID, year, projectID, expenseID);
ExpenseDetail.ExpenseTypeID = typeID;
ExpenseDetail.Year = year;
ExpenseDetail.ProjectID = projectID;
ExpenseDetail.ExpenseID = expenseID;
ExpenseDetail.CountryID = countryRepository.GetCountry(ExpenseDetailDTO.Country).ID;
ExpenseDetail.Comment = ExpenseDetailDTO.Comment;
ExpenseDetail.Month01 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month01);
ExpenseDetail.Month02 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month02);
ExpenseDetail.Month03 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month03);
ExpenseDetail.Month04 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month04);
ExpenseDetail.Month05 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month05);
ExpenseDetail.Month06 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month06);
ExpenseDetail.Month07 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month07);
ExpenseDetail.Month08 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month08);
ExpenseDetail.Month09 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month09);
ExpenseDetail.Month10 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month10);
ExpenseDetail.Month11 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month11);
ExpenseDetail.Month12 = DataUtility.GetDecimalValue(ExpenseDetailDTO.Month12);
UpdateExpenseDetail(ExpenseDetail);
}
// find and delete items
var deleteItems = source.Except(target, new ExpenseDetailDTOComparer());
foreach (ExpenseDetailDTO ExpenseDetailDTO in deleteItems)
{
int expenseID = expenseRepository.GetExpense(ExpenseDetailDTO.Expense).ID;
ExpenseDetail ExpenseDetail = GetExpenseDetail(typeID, year, projectID, expenseID);
DeleteExpenseDetail(ExpenseDetail.ID);
}
ctx.SaveChanges();
return(0);
}