/// <summary>
/// Insert TeamProjectTimeDetailTemp
/// </summary>
/// <param name="teamProjectTimeId">teamProjectTimeId</param>
/// <param name="employeeId">employeeId</param>
/// <param name="companiesId">companiesId</param>
/// <param name="projectId">projectId</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="projectTimeState">projectTimeState</param>
/// <param name="comments">comments</param>
/// <param name="fairWage">fairWage</param>
public void Insert(int teamProjectTimeId, int employeeId, int companiesId, int projectId, DateTime date_, string startTime, string endTime, double? offset, string workingDetails, string location, Int64? mealsCountry, bool mealsAllowance, string projectTimeState, string comments, bool fairWage, string jobClassType)
{
TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMPRow teamProjectTimeDetailRow = ((TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMPDataTable)Table).NewLFS_TEAM_PROJECT_TIME_DETAIL_TEMPRow();
teamProjectTimeDetailRow.TeamProjectTimeID = teamProjectTimeId;
teamProjectTimeDetailRow.DetailID = GetNewDetailId();
teamProjectTimeDetailRow.EmployeeID = employeeId;
teamProjectTimeDetailRow.CompaniesID = companiesId;
teamProjectTimeDetailRow.ProjectID = projectId;
teamProjectTimeDetailRow.Date_ = date_;
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();
teamProjectTimeDetailRow.ProjectTime = 0;
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;
teamProjectTimeDetailRow.SetUnitIDNull();
teamProjectTimeDetailRow.SetTowedUnitIDNull();
teamProjectTimeDetailRow.ProjectTimeState = projectTimeState;
if (comments != "") teamProjectTimeDetailRow.Comments = comments; else teamProjectTimeDetailRow.SetCommentsNull();
teamProjectTimeDetailRow.Deleted = false;
teamProjectTimeDetailRow.FairWage = fairWage;
if (jobClassType != "") teamProjectTimeDetailRow.JobClassType = jobClassType; else teamProjectTimeDetailRow.SetJobClassTypeNull();
((TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMPDataTable)Table).AddLFS_TEAM_PROJECT_TIME_DETAIL_TEMPRow(teamProjectTimeDetailRow);
// Insert real detail
string mealsAllowanceType2 = ""; if (mealsAllowance) mealsAllowanceType2 = "Full Day";
decimal mealsAllowance2 = MealsAllowance.GetMealsAllowance(mealsCountry, mealsAllowance, mealsAllowanceType2);
TeamProjectTime2Detail teamProjectTime2Detail = new TeamProjectTime2Detail(Data);
teamProjectTime2Detail.Insert(teamProjectTimeId, employeeId, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType2, mealsAllowance2, projectTimeState, comments, 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);
}
}
}
/// <summary>
/// Insert
/// </summary>
/// <param name="teamProjectTimeId">teamProjectTimeId</param>
/// <param name="newTemplateName">newTemplateName</param>
/// <param name="teamProjectTime2TDSToSave">teamProjectTime2TDSToSave</param>
public void Insert(int teamProjectTimeId, string newTemplateName, TeamProjectTime2TDS teamProjectTime2TDSToSave)
{
// Insert master 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;
TeamProjectTime2 teamProjectTime2ToSave = new TeamProjectTime2(teamProjectTime2TDSToSave);
teamProjectTime2ToSave.Insert(0, newTemplateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage);
// Insert detail rows
TeamProjectTime2Detail teamProjectTime2Detail = new TeamProjectTime2Detail(Data);
teamProjectTime2Detail.Insert(teamProjectTimeId, teamProjectTime2TDSToSave);
}
/// <summary>
/// Insert
/// </summary>
/// <param name="teamProjectTimeId">teamProjectTimeId</param>
/// <param name="teamProjectTime2TDSToSave">teamProjectTime2TDSToSave</param>
public void Insert(int teamProjectTimeId, TeamProjectTime2TDS teamProjectTime2TDSToSave)
{
foreach (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAILRow detailRow in ((TeamProjectTime2TDS)Data).LFS_TEAM_PROJECT_TIME_DETAIL)
{
if (!detailRow.Deleted)
{
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;
string ProjectTimeState = detailRow.ProjectTimeState;
string comments = ""; if (!detailRow.IsNull("Comments")) comments = detailRow.Comments;
bool fairWage = detailRow.FairWage;
string jobClassType = ""; if (!detailRow.IsNull("JobClassType")) jobClassType = detailRow.JobClassType;
TeamProjectTime2Detail teamProjectTime2DetailToSave = new TeamProjectTime2Detail(teamProjectTime2TDSToSave);
teamProjectTime2DetailToSave.Insert(0, employeeId, companiesId, projectId, date_, startTimeDetail, endTimeDetail, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, ProjectTimeState, comments, fairWage, jobClassType);
}
}
}