protected void cvDuplicateMealsAllowanceFooter_ServerValidate(object source, ServerValidateEventArgs args)
{
int employeeId = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEmployeesFooter")).SelectedValue);
bool isMealsAllowance = false;// ((CheckBox)grdProjectTime.FooterRow.FindControl("ckbxMealsAllowanceFooter")).Checked;
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
bool validMealsAllowance1 = teamProjectTime2DetailTemp.ValidateMealsAllowance(employeeId, isMealsAllowance);
args.IsValid = true;
if (!validMealsAllowance1)
{
args.IsValid = false;
}
}
protected void cvAlreadyRegisteredMealsAllowanceFooter_ServerValidate(object source, ServerValidateEventArgs args)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int employeeId = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEmployeesFooter")).SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
bool isMealsAllowance = false;// ((CheckBox)grdProjectTime.FooterRow.FindControl("ckbxMealsAllowanceFooter")).Checked;
string mealsCountry = hdfMealsCountry.Value;
int projectTimeId = -1;
args.IsValid = true;
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
bool validMealsAllowance1 = teamProjectTime2DetailTemp.ValidateMealsAllowance(employeeId, isMealsAllowance);
if (validMealsAllowance1)
{
if ((mealsCountry != "-1") && (isMealsAllowance))
{
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway();
if (projectTimeId == -1)
{
if (projectTimeGateway.ExistsMealsAllowanceByEmployeIdDate(employeeId, date_, companyId))
{
args.IsValid = false;
}
}
else
{
if (projectTimeGateway.ExistsMealsAllowanceByProjectTimeIdEmployeIdDate(projectTimeId, employeeId, date_, companyId))
{
args.IsValid = false;
}
}
}
}
}
protected void cvDuplicateMealsAllowanceEdit_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
if (grdProjectTime.Rows.Count > 0)
{
foreach (GridViewRow row in grdProjectTime.Rows)
{
if ((row.RowType == DataControlRowType.DataRow) && ((row.RowState == DataControlRowState.Edit) || (row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int employeeId = Int32.Parse(((DropDownList)row.FindControl("ddlEmployeesEdit")).SelectedValue);
bool isMealsAllowance = false;// ((CheckBox)row.FindControl("ckbxMealsAllowanceEdit")).Checked;
int projectTimeId2 = Int32.Parse(((Label)row.FindControl("lblDetailIdEdit")).Text);
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
bool validMealsAllowance1 = teamProjectTime2DetailTemp.ValidateMealsAllowanceEdit(employeeId, isMealsAllowance, projectTimeId2);
args.IsValid = true;
if (!validMealsAllowance1)
{
args.IsValid = false;
}
}
}
}
}
private void PostStepDataChanges()
{
int teamProjectTimeId = (int)ViewState["teamProjectTimeId"];
string templateName = "";
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
string workingDetails = ""; if (tbxWorkingDetails.Text != "(Select)") workingDetails = tbxWorkingDetails.Text;
string work_ = ddlTypeOfWork.SelectedValue;
string function_ = ddlFunction.SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
DateTime? startTime = null;
if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != "") )
{
startTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlStartTimeHour.SelectedValue), Int32.Parse(ddlStartTimeMinute.SelectedValue), 0);
}
DateTime? endTime = null;
if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != "") )
{
endTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlEndTimeHour.SelectedValue), Int32.Parse(ddlEndTimeMinute.SelectedValue), 0);
}
double? offset = 0; if (ddlLunch.SelectedValue != "0") offset = double.Parse(ddlLunch.SelectedValue);
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string mealsAllowanceType = ""; //if (cbxMealsAllowance.Checked) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, false, "Full Day");
string comments = "";
string type = "Template";
string state = "Done";
int loginId = Convert.ToInt32(Session["loginID"]);
bool deleted = false;
int? unitId = null;
int? towedUnitId = null;
bool fairWage = false; if (hdfFairWage.Value == "True") fairWage = true;
// New template check
TeamProjectTime2 teamProjectTime2 = new TeamProjectTime2(teamProjectTime2TDS);
if (((int)ViewState["teamProjectTimeId"] == 0) && ((string)ViewState["StepFrom"] != "Employees"))
{
// ... Insert team project time
teamProjectTime2.Insert(teamProjectTimeId, templateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage);
}
else
{
// ... Update team project time
teamProjectTime2.Update(teamProjectTimeId, templateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage);
}
// Store date in date edit for employees step
tbxDate.Text = tkrdpDate_.SelectedDate.Value.ToString();
hdfDate.Value = tkrdpDate_.SelectedDate.Value.ToString();
// Store data in hidden components for employees step
hdfTeamProjectTimeID.Value = teamProjectTimeId.ToString();
hdfCompaniesID.Value = companiesId.ToString();
hdfProjectID.Value = projectId.ToString();
string startTimeForNextStep = "";
if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != ""))
{
startTimeForNextStep = ddlStartTimeHour.SelectedValue.Trim() + ":" + ddlStartTimeMinute.SelectedValue.Trim();
}
hdfStartTime.Value = startTimeForNextStep;
string endTimeForNextStep = "";
if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != ""))
{
endTimeForNextStep = ddlEndTimeHour.SelectedValue.Trim() + ":" + ddlEndTimeMinute.SelectedValue.Trim();
}
hdfEndTime.Value = endTimeForNextStep;
if (offset != null) hdfOffset.Value = offset.ToString(); else hdfOffset.Value = "";
hdfWorkingDetails.Value = workingDetails.ToString();
hdfLocation.Value = location.ToString();
hdfMealsCountry.Value = ddlMealsCountry.SelectedValue;
hdfIsMealsAllowance.Value = "false";// cbxMealsAllowance.Checked.ToString();
hdfMealsAllowance.Value = mealsAllowance.ToString();
hdfProjectTimeState.Value = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") hdfProjectTimeState.Value = "Approved";
//if (cbxClearUnitAssigment.Checked)
hdfClearUnitAssigment.Value = "false";
// ... For work and function string
hdfWork_.Value = work_;
hdfFunction_.Value = function_;
hdfWorkFunctionConcat.Value = work_ + " . " + function_;
// Clear Unit Assigment validation
//if (cbxClearUnitAssigment.Checked)
//{
// // ... Update detail
// TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
// teamProjectTime2DetailTemp.UpdateAll(teamProjectTimeId);
//}
//else
//{
// ... Update detail
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
teamProjectTime2DetailTemp.UpdateAll(teamProjectTimeId, false);
//}
// Store datasets
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
}
// ////////////////////////////////////////////////////////////////////////
// STEP3 - DATA - METHODS
//
private void StepDataIn()
{
// Set instruction
mWizard2 master = (mWizard2)this.Master;
master.WizardInstruction = "Please define global data, it will be applied to your team members on the next step.";
// Wizard type & step from check
if ((hdfNewOrTemplate.Value == "New") && ((string)ViewState["StepFrom"] != "Employees"))
{
// Prepare initial data
ddlClient.Enabled = true;
ddlProject.Enabled = true;
ProjectTimeWorkList projectTimeWorkList = new ProjectTimeWorkList(new DataSet());
projectTimeWorkList.LoadAndAddItem("(Select a Type)");
ddlTypeOfWork.DataSource = projectTimeWorkList.Table;
ddlTypeOfWork.DataValueField = "Work_";
ddlTypeOfWork.DataTextField = "Work_";
ddlTypeOfWork.DataBind();
ddlTypeOfWork.SelectedIndex = 0;
ProjectTimeWorkFunctionList projectTimeWorkFunctionList = new ProjectTimeWorkFunctionList(new DataSet());
projectTimeWorkFunctionList.LoadActiveForAddAndAddItem("(Select a Function)", "-1");
ddlFunction.DataSource = projectTimeWorkFunctionList.Table;
ddlFunction.DataValueField = "Function_";
ddlFunction.DataTextField = "Function_";
ddlFunction.DataBind();
ddlFunction.SelectedIndex = 0;
}
else
{
TeamProjectTime2Gateway teamProjectTime2Gateway = new TeamProjectTime2Gateway(teamProjectTime2TDS);
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
// Prepare initial data
if ((string)ViewState["StepFrom"] == "Template")
{
ViewState["teamProjectTimeId"] = Int32.Parse(hdfSelectedIdTemplate.Value);
// ... for TeamProjectTime
teamProjectTime2Gateway.LoadByTeamProjectTimeId((int)ViewState["teamProjectTimeId"]);
// ... for TeamProjectTimeDetailTemp
teamProjectTime2DetailTemp.LoadAllByTeamProjectTimeId((int)ViewState["teamProjectTimeId"]);
}
// ... for Client
string companiesId = teamProjectTime2Gateway.GetCompaniesId((int)ViewState["teamProjectTimeId"]).ToString();
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(Int32.Parse(companiesId), companyId);
// ... If Company is active
bool deleted = companiesGateway.GetDeleted(Int32.Parse(companiesId));
if (deleted)
{
ddlClient.SelectedIndex = -1;
}
else
{
ddlClient.SelectedValue = companiesId;
}
if (ddlClient.SelectedValue.Length == 0)
{
odsClient.DataBind();
ddlClient.DataSourceID = "odsClient";
ddlClient.DataValueField = "COMPANIES_ID";
ddlClient.DataTextField = "Name";
ddlClient.DataBind();
if (deleted)
{
ddlClient.SelectedIndex = -1;
}
else
{
ddlClient.SelectedValue = companiesId;
}
}
if (!deleted)
{
// ... for project
odsProjectsInternalProjectsBallparkProjects.SelectParameters.RemoveAt(2);
odsProjectsInternalProjectsBallparkProjects.SelectParameters.Add("ClientId", ddlClient.SelectedValue);
odsProjectsInternalProjectsBallparkProjects.Select();
odsProjectsInternalProjectsBallparkProjects.DataBind();
ddlProject.DataSourceID = "odsProjectsInternalProjectsBallparkProjects";
ddlProject.DataValueField = "ProjectID";
ddlProject.DataTextField = "NAME";
ddlProject.DataBind();
try
{
ddlProject.SelectedValue = teamProjectTime2Gateway.GetProjectId((int)ViewState["teamProjectTimeId"]).ToString();
}
catch
{
ddlProject.SelectedIndex = -1;
}
}
else
{
ddlProject.SelectedIndex = -1;
}
// ... for Date
if ((string)ViewState["StepFrom"] == "Employees")
{
tkrdpDate_.SelectedDate = teamProjectTime2Gateway.GetDate_((int)ViewState["teamProjectTimeId"]);
}
// ... for Type of work
ProjectTimeWorkList projectTimeWorkList = new ProjectTimeWorkList(new DataSet());
projectTimeWorkList.LoadAndAddItem("(Select a Type)");
ddlTypeOfWork.DataSource = projectTimeWorkList.Table;
ddlTypeOfWork.DataValueField = "Work_";
ddlTypeOfWork.DataTextField = "Work_";
ddlTypeOfWork.DataBind();
if (teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]).ToString() == "")
{
ddlTypeOfWork.SelectedValue = "(Select a Type)";
}
else
{
ddlTypeOfWork.SelectedValue = (string)teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]);
}
// ... for function
ProjectTimeWorkFunctionList projectTimeWorkFunctionList = new ProjectTimeWorkFunctionList(new DataSet());
if (teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]).ToString() == "")
{
// ... If there is no type of Work, no function should be loaded
projectTimeWorkFunctionList.LoadActiveForAddAndAddItem("(Select a Function)", "-1");
}
else
{
projectTimeWorkFunctionList.LoadActiveForAddAndAddItem("(Select a Function)", teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]));
}
ddlFunction.DataSource = projectTimeWorkFunctionList.Table;
ddlFunction.DataValueField = "Function_";
ddlFunction.DataTextField = "Function_";
ddlFunction.DataBind();
if (teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]).ToString() == "")
{
ddlFunction.SelectedValue = "(Select a Function)";
}
else
{
ddlFunction.SelectedValue = (string)teamProjectTime2Gateway.GetFunction((int)ViewState["teamProjectTimeId"]);
}
// ... for working details
if (!deleted)
{
tbxWorkingDetails.Text = teamProjectTime2Gateway.GetWorkingDetails((int)ViewState["teamProjectTimeId"]);
}
else
{
tbxWorkingDetails.Text = "";
}
// ... for start time
if (teamProjectTime2Gateway.GetStartTime((int)ViewState["teamProjectTimeId"]).HasValue)
{
string startTime = ((DateTime)teamProjectTime2Gateway.GetStartTime((int)ViewState["teamProjectTimeId"])).ToString("H:mm");
string[] hoursMin1 = startTime.Split(':');
ddlStartTimeHour.SelectedValue = hoursMin1[0].Trim();
ddlStartTimeMinute.SelectedValue = hoursMin1[1].Trim();
}
// ... for end time
if (teamProjectTime2Gateway.GetEndTime((int)ViewState["teamProjectTimeId"]).HasValue)
{
string endTime = ((DateTime)teamProjectTime2Gateway.GetEndTime((int)ViewState["teamProjectTimeId"])).ToString("H:mm");
string[] endHoursMin1 = endTime.Split(':');
ddlEndTimeHour.SelectedValue = endHoursMin1[0].Trim();
ddlEndTimeMinute.SelectedValue = endHoursMin1[1].Trim();
}
// ... for offset
if (teamProjectTime2Gateway.GetOffset((int)ViewState["teamProjectTimeId"]).HasValue) ddlLunch.SelectedValue = Math.Round(teamProjectTime2Gateway.GetOffset((int)ViewState["teamProjectTimeId"]).Value, 2).ToString();
// ... for meals country
if (!deleted)
{
if (teamProjectTime2Gateway.GetMealsCountry((int)ViewState["teamProjectTimeId"]).HasValue)
{
ddlMealsCountry.SelectedValue = teamProjectTime2Gateway.GetMealsCountry((int)ViewState["teamProjectTimeId"]).Value.ToString();
}
else
{
ddlMealsCountry.SelectedIndex = 0;
}
}
else
{
ddlMealsCountry.SelectedIndex = -1;
}
// ... for meals allowance
//if (teamProjectTime2Gateway.GetMealsAllowance((int)ViewState["teamProjectTimeId"]) > 0) cbxMealsAllowance.Checked = true;
// ... for fair wage
if (teamProjectTime2Gateway.GetFairWage((int)ViewState["teamProjectTimeId"])) hdfFairWage.Value = "True";
// Store datasets
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
template = teamProjectTime2TDS.Template;
Session["template"] = teamProjectTime2TDS.Template;
}
//cbxClearUnitAssigment.Checked = false;
}
protected void cvAlreadyRegisteredMealsAllowanceEdit_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
if (grdProjectTime.Rows.Count > 0)
{
foreach (GridViewRow row in grdProjectTime.Rows)
{
if ((row.RowType == DataControlRowType.DataRow) && ((row.RowState == DataControlRowState.Edit) || (row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int employeeId = Int32.Parse(((DropDownList)row.FindControl("ddlEmployeesEdit")).SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
bool isMealsAllowance = false;// ((CheckBox)row.FindControl("ckbxMealsAllowanceEdit")).Checked;
int projectTimeId2 = Int32.Parse(((Label)row.FindControl("lblDetailIdEdit")).Text);
string mealsCountry = hdfMealsCountry.Value;
int projectTimeId = -1;
args.IsValid = true;
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
bool validMealsAllowance1 = teamProjectTime2DetailTemp.ValidateMealsAllowanceEdit(employeeId, isMealsAllowance, projectTimeId2);
if (validMealsAllowance1)
{
if ((mealsCountry != "-1") && (isMealsAllowance))
{
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway();
if (projectTimeId == -1)
{
if (projectTimeGateway.ExistsMealsAllowanceByEmployeIdDate(employeeId, date_, companyId))
{
args.IsValid = false;
}
}
else
{
if (projectTimeGateway.ExistsMealsAllowanceByProjectTimeIdEmployeIdDate(projectTimeId, employeeId, date_, companyId))
{
args.IsValid = false;
}
}
}
}
}
}
}
}
private void GrdTeamProjectTimeDetailAdd()
{
Page.Validate();
if (Page.IsValid)
{
Page.Validate("footerValidData");
if (Page.IsValid)
{
Page.Validate("footerData");
if (Page.IsValid)
{
int teamProjectTimeId = Int32.Parse(hdfTeamProjectTimeID.Value);
int employeeId = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEmployeesFooter")).SelectedValue);
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTimeFooter = "";
string startHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue != "") startHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue.Trim();
string startMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue != "") startMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue.Trim();
if ((startHoursFooter != "") && (startMinutesFooter != ""))
{
startTimeFooter = startHoursFooter + ":" + startMinutesFooter;
}
string endTimeFooter = "";
string endHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue != "") endHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue.Trim();
string endMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue != "") endMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue.Trim();
if ((endHoursFooter != "") && (endMinutesFooter != ""))
{
endTimeFooter = endHoursFooter + ":" + endMinutesFooter;
}
decimal? offsetFooter = 0; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue != "0") offsetFooter = Decimal.Round(decimal.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue), 2);
double? offsetFooterFinal = null; if (offsetFooter.HasValue) offsetFooterFinal = double.Parse(((decimal)offsetFooter).ToString());
string typeOfWorkFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTypeOfWorkFooter")).SelectedValue;
int? unitIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue != "-1") unitIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue);
int? towedIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue != "-1") towedIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue);
string workingDetailsFooter = tbxWorkingDetails.Text;
bool isMealsAllowanceFooter = false;// ((CheckBox)grdProjectTime.FooterRow.FindControl("ckbxMealsAllowanceFooter")).Checked;
string commentsFooter = ((TextBox)grdProjectTime.FooterRow.FindControl("tbxCommentsFooter")).Text;
int companyId = Int32.Parse(hdfCompanyId.Value);
bool fairWageFooter = false; if (hdfFairWage.Value == "True") fairWageFooter = true;
string jobClassTypeFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue;
string projectTimeState = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") projectTimeState = "Approved";
string work_ = "";
string function_ = "";
if (typeOfWorkFooter != "(Select)")
{
string[] workFunction = typeOfWorkFooter.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
// Insert Data
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
teamProjectTime2DetailTemp.Insert(teamProjectTimeId, employeeId, companiesId, projectId, date_, startTimeFooter, endTimeFooter, offsetFooterFinal, workingDetailsFooter, location, mealsCountry, isMealsAllowanceFooter, unitIdFooter, towedIdFooter, projectTimeState, commentsFooter, work_, function_, typeOfWorkFooter, fairWageFooter, jobClassTypeFooter);
// Store Dataset
Session.Remove("teamProjectTimeDetailTempDummy");
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; ;
grdProjectTime.DataBind();
grdProjectTime.PageIndex = grdProjectTime.PageCount - 1;
}
}
}
}
protected void grdProjectTime_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("editValidData");
if (Page.IsValid)
{
Page.Validate("editData");
if (Page.IsValid)
{
int teamProjectTimeId = (int)e.Keys["TeamProjectTimeID"];
int detailId = (int)e.Keys["DetailID"];
DateTime date_ = DateTime.Parse(hdfDate.Value);
int employeeId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlEmployeesEdit")).SelectedValue);
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTime = "";
string startHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlStartTimeHourEdit")).SelectedValue.Trim();
string startMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlStartTimeMinuteEdit")).SelectedValue.Trim();
if ((startHoursEdit != "") && (startMinutesEdit != ""))
{
startTime = startHoursEdit + ":" + startMinutesEdit;
}
string endTime = "";
string endHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlEndTimeHourEdit")).SelectedValue.Trim();
string endMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlEndTimeMinuteEdit")).SelectedValue.Trim();
if ((endHoursEdit != "") && (endMinutesEdit != ""))
{
endTime = endHoursEdit + ":" + endMinutesEdit;
}
decimal? offset = 0; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlLunchEdit")).SelectedValue != "0") offset = decimal.Round(Decimal.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlLunchEdit")).SelectedValue), 2);
double? offsetFinal = null; if (offset.HasValue) offsetFinal = double.Parse(((decimal)offset).ToString());
string workingDetails = tbxWorkingDetails.Text;
bool isMealsAllowance = false;// ((CheckBox)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ckbxMealsAllowanceEdit")).Checked;
int? unitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlUnitEdit")).SelectedValue != "-1") unitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlUnitEdit")).SelectedValue);
int? towedUnitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlTowedEdit")).SelectedValue != "-1") towedUnitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlTowedEdit")).SelectedValue);
string comments = ((TextBox)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("tbxCommentsEdit")).Text;
string workFunctionConcat = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue;
string work_ = "";
string function_ = "";
if (workFunctionConcat != "(Select)")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
bool fairWage = false; if (hdfFairWage.Value == "True") fairWage = true;
string jobClassType = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[3].FindControl("ddlJobClassTypeEdit")).SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
// Update data
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
teamProjectTime2DetailTemp.Update(teamProjectTimeId, detailId, employeeId, date_, startTime, endTime, offsetFinal, workingDetails, location, mealsCountry, isMealsAllowance, unitId, towedUnitId, comments, work_, function_, workFunctionConcat, fairWage, jobClassType);
// Store dataset
Session.Remove("teamProjectTimeDetailTempDummy");
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP4 - EMPLOYEES
//
// ////////////////////////////////////////////////////////////////////////
// STEP4 - EMPLOYEES - EVENTS
//
protected void grdProjectTime_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Project Time Gridview, if the gridview is edition mode
if (grdProjectTime.EditIndex >= 0)
{
grdProjectTime.UpdateRow(grdProjectTime.EditIndex, true);
}
// Delete project time
int teamProjectTimeId = (int)e.Keys["TeamProjectTimeID"];
int detailId = (int)e.Keys["DetailID"];
// Delete team project time details
TeamProjectTime2DetailTemp teamProjectTime2Detail = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
teamProjectTime2Detail.Delete(teamProjectTimeId, detailId);
// Store dataset
Session["teamProjectTime2TDS"] = teamProjectTime2TDS;
Session.Remove("teamProjectTimeDetailTempDummy");
teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP;
}
protected void cvValidTimesFooter_ServerValidate(object source, ServerValidateEventArgs args)
{
if (hdfBtnNext.Value == "True")
{
args.IsValid = true;
}
else
{
args.IsValid = false;
ProjectTimeGateway projectTimeGatewayForVerify = new ProjectTimeGateway();
int employeeId = 0; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEmployeesFooter")).SelectedValue.Trim() != "") employeeId = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEmployeesFooter")).SelectedValue.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value);
DateTime date_ = DateTime.Parse(tbxDate.Text);
string startTimeFooter = "";
string startHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue != "") startHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue.Trim();
string startMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue != "") startMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue.Trim();
string endTimeFooter = "";
string endHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue != "") endHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue.Trim();
string endMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue != "") endMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue.Trim();
if ((startHoursFooter != "") && (startMinutesFooter != "") && (endHoursFooter != "") && (endMinutesFooter != ""))
{
startTimeFooter = startHoursFooter + ":" + startMinutesFooter;
endTimeFooter = endHoursFooter + ":" + endMinutesFooter;
// Verify if the time not exists at DB
if (projectTimeGatewayForVerify.NotExistsByEmployeIdDate_StartTimeEndTime(employeeId, date_, startTimeFooter, endTimeFooter, companyId))
{
args.IsValid = true;
}
if (args.IsValid)
{
// Verify if it exist at last entered rows
TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS);
if (teamProjectTime2DetailTemp.NotExistsByEmployeIdDate_StartTime(employeeId, date_, startTimeFooter, endTimeFooter))
{
args.IsValid = true;
}
else
{
args.IsValid = false;
}
}
}
}
}
