/// <summary>
/// Update
/// </summary>
/// <param name="teamProjectTimeId">teamProjectTimeId</param>
/// <param name="teamProjectTimeIdForReplace">teamProjectTimeIdForReplace</param>
/// <param name="teamProjectTime2TDSToSave">teamProjectTime2TDSToSave</param>
public void Update(int teamProjectTimeId, int teamProjectTimeIdForReplace, TeamProjectTime2TDS teamProjectTime2TDSToSave)
{
// Update existing row
TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIMERow masterRow = GetRow(teamProjectTimeId);
int companiesId = masterRow.CompaniesID;
int projectId = masterRow.ProjectID;
DateTime date_ = masterRow.Date_;
DateTime? startTime = null; if (!masterRow.IsNull("StartTime")) startTime = masterRow.StartTime;
DateTime? endTime = null; if (!masterRow.IsNull("EndTime")) endTime = masterRow.EndTime;
double? offset = null; if (!masterRow.IsNull("Offset")) offset = masterRow.Offset;
string workingDetails = ""; if (!masterRow.IsNull("WorkingDetails")) workingDetails = masterRow.WorkingDetails;
string location = ""; if (!masterRow.IsNull("Location")) location = masterRow.Location;
Int64? mealsCountry = null; if (!masterRow.IsNull("MealsCountry")) mealsCountry = masterRow.MealsCountry;
String mealsAllowanceType = ""; if (!masterRow.IsNull("MealsAllowanceType")) mealsAllowanceType = masterRow.MealsAllowanceType;
decimal mealsAllowance = masterRow.MealsAllowance;
int? unitId = null; if (!masterRow.IsNull("UnitID")) unitId = masterRow.UnitID;
int? towedUnitId = null; if (!masterRow.IsNull("TowedUnitID")) towedUnitId = masterRow.TowedUnitID;
string comments = ""; if (!masterRow.IsNull("Comments")) comments = masterRow.Comments;
string type = "Template";
string state = "Done";
int loginId = masterRow.LoginID;
bool deleted = false;
string work_ = masterRow.Work_;
string function_ = masterRow.Function_;
bool fairWage = masterRow.FairWage;
// ... Load existing row
TeamProjectTime2Gateway teamProjectTime2Gateway = new TeamProjectTime2Gateway(teamProjectTime2TDSToSave);
teamProjectTime2Gateway.LoadByTeamProjectTimeId(teamProjectTimeIdForReplace);
// ... Replace existing row
TeamProjectTime2 teamProjectTime2ToSave = new TeamProjectTime2(teamProjectTime2TDSToSave);
teamProjectTime2ToSave.Update(teamProjectTimeIdForReplace, teamProjectTime2Gateway.GetTemplateName(teamProjectTimeIdForReplace), companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage);
// Update or delete detail rows
TeamProjectTime2Detail teamProjectTime2Detail = new TeamProjectTime2Detail(Data);
teamProjectTime2Detail.Update(teamProjectTimeId, teamProjectTimeIdForReplace, teamProjectTime2TDSToSave);
}
/// <summary>
/// Update TeamProjectTimeDetailTemp
/// </summary>
/// <param name="teamProjectTimeId">teamProjectTimeId</param>
/// <param name="detailId">detailId</param>
/// <param name="employeeId">employeeId</param>
/// <param name="date_">date_</param>
/// <param name="startTime">startTime</param>
/// <param name="endTime">endTime</param>
/// <param name="offset">offset</param>
/// <param name="workingDetails">workingDetails</param>
/// <param name="location">location</param>
/// <param name="mealsCountry">mealsCountry</param>
/// <param name="mealsAllowance">mealsAllowance</param>
/// <param name="unitId">unitId</param>
/// <param name="towedUnitId">towedUnitId</param>
/// <param name="comments">comments</param>
/// <param name="work_">work_</param>
/// <param name="function_">function_</param>
/// <param name="workFunctionConcat">workFunctionConcat</param>
/// <param name="fairWage">fairWage</param>
public void Update(int teamProjectTimeId, int detailId, int employeeId, DateTime date_, string startTime, string endTime, double? offset, string workingDetails, string location, Int64? mealsCountry, bool mealsAllowance, int? unitId, int? towedUnitId, string comments, string work_, string function_, string workFunctionConcat, bool fairWage, string jobClassType)
{
TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMPRow teamProjectTimeDetailRow = GetRow(teamProjectTimeId, detailId);
teamProjectTimeDetailRow.Date_ = date_;
teamProjectTimeDetailRow.EmployeeID = employeeId;
if (startTime != "") teamProjectTimeDetailRow.StartTime = startTime; else teamProjectTimeDetailRow.SetStartTimeNull();
if (endTime != "") teamProjectTimeDetailRow.EndTime = endTime; else teamProjectTimeDetailRow.SetEndTimeNull();
if (offset.HasValue) teamProjectTimeDetailRow.Offset = (double)offset; else teamProjectTimeDetailRow.SetOffsetNull();
if (workingDetails != "") teamProjectTimeDetailRow.WorkingDetails = workingDetails; else teamProjectTimeDetailRow.SetWorkingDetailsNull();
if (location != "") teamProjectTimeDetailRow.Location = location; else teamProjectTimeDetailRow.SetLocationNull();
if (mealsCountry.HasValue) teamProjectTimeDetailRow.MealsCountry = (Int64)mealsCountry; else teamProjectTimeDetailRow.SetMealsCountryNull();
teamProjectTimeDetailRow.MealsAllowance = mealsAllowance;
if (unitId.HasValue) teamProjectTimeDetailRow.UnitID = (int)unitId; else teamProjectTimeDetailRow.SetUnitIDNull();
if (towedUnitId.HasValue) teamProjectTimeDetailRow.TowedUnitID = (int)towedUnitId; else teamProjectTimeDetailRow.SetTowedUnitIDNull();
teamProjectTimeDetailRow.ProjectTime = 0;
if (comments != "") teamProjectTimeDetailRow.Comments = comments; else teamProjectTimeDetailRow.SetCommentsNull();
teamProjectTimeDetailRow.Work_ = work_;
teamProjectTimeDetailRow.Function_ = function_;
teamProjectTimeDetailRow.WorkFunctionConcat = workFunctionConcat;
teamProjectTimeDetailRow.FairWage = fairWage;
if (jobClassType != "") teamProjectTimeDetailRow.JobClassType = jobClassType; else teamProjectTimeDetailRow.SetJobClassTypeNull();
// Update real detail
string mealsAllowanceType2 = ""; if (mealsAllowance) mealsAllowanceType2 = "Full Day";
decimal mealsAllowance2 = MealsAllowance.GetMealsAllowance(mealsCountry, mealsAllowance, mealsAllowanceType2);
TeamProjectTime2Detail teamProjectTimeDetail = new TeamProjectTime2Detail(Data);
teamProjectTimeDetail.Update(teamProjectTimeId, detailId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType2, mealsAllowance2, unitId, towedUnitId, teamProjectTimeDetailRow.ProjectTimeState, comments, work_, function_, fairWage, jobClassType);
}
/// <summary>
/// Update
/// </summary>
/// <param name="teamProjectTimeId">teamProjectTimeId</param>
/// <param name="teamProjectTimeIdForReplace">teamProjectTimeIdForReplace</param>
/// <param name="teamProjectTime2TDSToSave">teamProjectTime2TDSToSave</param>
public void Update(int teamProjectTimeId, int teamProjectTimeIdForReplace, TeamProjectTime2TDS teamProjectTime2TDSToSave)
{
// Load existing rows
TeamProjectTime2DetailGateway teamProjectTime2DetailGateway = new TeamProjectTime2DetailGateway(teamProjectTime2TDSToSave);
teamProjectTime2DetailGateway.LoadAllByTeamProjectTimeId(teamProjectTimeIdForReplace);
// Delete existing rows
foreach (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAILRow detailExistingRow in ((TeamProjectTime2TDS)teamProjectTime2DetailGateway.Data).LFS_TEAM_PROJECT_TIME_DETAIL)
{
detailExistingRow.Deleted = true;
}
// Insert or update detail rows
foreach (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAILRow detailRow in ((TeamProjectTime2TDS)Data).LFS_TEAM_PROJECT_TIME_DETAIL)
{
int detailId = detailRow.DetailID;
int employeeId = detailRow.EmployeeID;
int companiesId = detailRow.CompaniesID;
int projectId = detailRow.ProjectID;
DateTime date_ = detailRow.Date_;
string startTimeDetail = ""; if (!detailRow.IsNull("StartTime")) startTimeDetail = detailRow.StartTime;
string endTimeDetail = null; if (!detailRow.IsNull("EndTime")) endTimeDetail = detailRow.EndTime;
double? offset = null; if (!detailRow.IsNull("Offset")) offset = detailRow.Offset;
double projectTime = detailRow.ProjectTime;
string workingDetails = ""; if (!detailRow.IsNull("WorkingDetails")) workingDetails = detailRow.WorkingDetails;
string location = ""; if (!detailRow.IsNull("Location")) location = detailRow.Location;
Int64? mealsCountry = null; if (!detailRow.IsNull("MealsCountry")) mealsCountry = detailRow.MealsCountry;
string mealsAllowanceType = ""; if (!detailRow.IsNull("MealsAllowanceType")) mealsAllowanceType = detailRow.MealsAllowanceType;
decimal mealsAllowance = detailRow.MealsAllowance;
int? unitId = null; if (!detailRow.IsNull("UnitID")) unitId = detailRow.UnitID;
int? towedUnitId = null; if (!detailRow.IsNull("TowedUnitID")) towedUnitId = detailRow.TowedUnitID;
string ProjectTimeState = detailRow.ProjectTimeState;
string comments = ""; if (!detailRow.IsNull("Comments")) comments = detailRow.Comments;
bool deleted = detailRow.Deleted;
bool fairWage = detailRow.FairWage;
string jobClassType = ""; if (!detailRow.IsNull("JobClassType")) jobClassType = detailRow.JobClassType;
// ... Get row if exists
TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAILRow oldDetailRow = null;
try
{
oldDetailRow = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAILRow)teamProjectTime2DetailGateway.GetRow(teamProjectTimeIdForReplace, detailId);
}
catch
{
oldDetailRow = null;
}
// ... Row check
TeamProjectTime2Detail teamProjectTime2DetailToSave = new TeamProjectTime2Detail(teamProjectTime2TDSToSave);
if (oldDetailRow != null)
{
teamProjectTime2DetailToSave.Update(teamProjectTimeIdForReplace, detailId, employeeId, companiesId, projectId, date_, startTimeDetail, endTimeDetail, offset, projectTime, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, ProjectTimeState, comments, deleted, fairWage, jobClassType);
}
else
{
teamProjectTime2DetailToSave.Insert(teamProjectTimeIdForReplace, employeeId, companiesId, projectId, date_, startTimeDetail, endTimeDetail, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, ProjectTimeState, comments, fairWage, jobClassType);
}
}
}
