protected void cvValidTimesFooter_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = false; ProjectTimeGateway projectTimeGatewayForVerify = new ProjectTimeGateway(); int employeeId = Int32.Parse(hdfEmployeeID.Value); int companyId = Int32.Parse(hdfCompanyId.Value); DateTime date_ = tkrdpStartDate.SelectedDate.Value; 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 already 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 ProjectTimeTemp modelForReview = new ProjectTimeTemp(projectTimeTDS); if (modelForReview.NotExistsByEmployeIdDate_StartTimeEndTime(employeeId, date_, startTimeFooter, endTimeFooter)) { args.IsValid = true; } else { args.IsValid = false; } } } }
private bool StepEndFinish() { lblError.Visible = false; lblError2.Visible = false; int companyId = Int32.Parse(hdfCompanyId.Value); if (ValidateStepEnd()) { if (cbxEndConfirm.Checked) { // Review all times if (rbtnBeginTemplate.Checked) { if (grdProjectTime.Rows.Count > 0) { foreach (GridViewRow row in grdProjectTime.Rows) { if ((row.RowType == DataControlRowType.DataRow) && ((row.RowState == DataControlRowState.Normal) || (row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { ProjectTimeGateway projectTimeGatewayForVerify = new ProjectTimeGateway(); int employeeId = 0; if (((HiddenField)row.FindControl("hdfEmployeeId")).Value.Trim() != "") employeeId = Int32.Parse(((HiddenField)row.FindControl("hdfEmployeeId")).Value.Trim()); DateTime date_ = DateTime.Parse(tbxDate.Text); string startTime = ""; if (((TextBox)row.FindControl("tbxStartTime")).Text.Trim() != "") startTime = ((TextBox)row.FindControl("tbxStartTime")).Text.Trim(); string endTime = ""; if (((TextBox)row.FindControl("tbxEndTime")).Text.Trim() != "") endTime = ((TextBox)row.FindControl("tbxEndTime")).Text.Trim(); // Verify if the time not exists at DB if (projectTimeGatewayForVerify.NotExistsByEmployeIdDate_StartTimeEndTime(employeeId, date_, startTime, endTime, companyId)) { // Verify Job Class EmployeeGateway employee = new EmployeeGateway(); employee.LoadByEmployeeId(employeeId); string jobClass = employee.GetJobClassType(employeeId); if (jobClass == "") { lblError2.Visible = true; lblError2.Text = lblError2.Text + ((TextBox)row.FindControl("tbxTeamMember")).Text.Trim() + ", "; } } else { lblError.Visible = true; lblError.Text = lblError.Text + ((TextBox)row.FindControl("tbxTeamMember")).Text.Trim() + ", "; } } } } } } if ((lblError.Visible)||(lblError2.Visible)) { return false; } else { if (PostStepEndChanges(companyId)) { UpdateDatabase(); return true; } else { return false; } } } else { return false; } }
protected void cvValidTimesEdit_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = false; 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)))) { ProjectTimeGateway projectTimeGatewayForVerify = new ProjectTimeGateway(); int employeeId = Int32.Parse(hdfEmployeeID.Value); int companyId = Int32.Parse(hdfCompanyId.Value); DateTime date_ = tkrdpStartDate.SelectedDate.Value; string startTime = ""; string startHoursEdit = ""; if (((DropDownList)row.FindControl("ddlStartTimeHourEdit")).SelectedValue.Trim() != "") startHoursEdit = ((DropDownList)row.FindControl("ddlStartTimeHourEdit")).SelectedValue.Trim(); string startMinutesEdit = ""; if (((DropDownList)row.FindControl("ddlStartTimeMinuteEdit")).SelectedValue.Trim() != "") startMinutesEdit = ((DropDownList)row.FindControl("ddlStartTimeMinuteEdit")).SelectedValue.Trim(); if ((startHoursEdit != "") && (startMinutesEdit != "")) { startTime = startHoursEdit + ":" + startMinutesEdit; } string endTime = ""; string endHoursEdit = ""; if (((DropDownList)row.FindControl("ddlEndTimeHourEdit")).SelectedValue.Trim() != "") endHoursEdit = ((DropDownList)row.FindControl("ddlEndTimeHourEdit")).SelectedValue.Trim(); string endMinutesEdit = ""; if (((DropDownList)row.FindControl("ddlEndTimeMinuteEdit")).SelectedValue.Trim() != "") endMinutesEdit = ((DropDownList)row.FindControl("ddlEndTimeMinuteEdit")).SelectedValue.Trim(); if ((endHoursEdit != "") && (endMinutesEdit != "")) { endTime = endHoursEdit + ":" + endMinutesEdit; } // Verify if the time already exists at DB if (projectTimeGatewayForVerify.NotExistsByEmployeIdDate_StartTimeEndTime(employeeId, date_, startTime, endTime, companyId)) { args.IsValid = true; } int cant = 0; if (args.IsValid) { // Verify if it exist at last entered rows if (grdProjectTime.Rows.Count > 0) { foreach (GridViewRow rowTemp in grdProjectTime.Rows) { if ((rowTemp.RowType == DataControlRowType.DataRow) && ((rowTemp.RowState == DataControlRowState.Normal) || (rowTemp.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { TimeSpan spanGridStartTime = TimeSpan.Parse(((TextBox)rowTemp.FindControl("tbxStartTime")).Text.Trim()); TimeSpan spanGridEndTime = TimeSpan.Parse(((TextBox)rowTemp.FindControl("tbxEndTime")).Text.Trim()); TimeSpan spanStartTime = TimeSpan.Parse(startTime); TimeSpan spanEndTime = TimeSpan.Parse(endTime); string twentyForHours = "23:59"; TimeSpan midNight = TimeSpan.Parse(twentyForHours); if ((Int32.Parse(hdfEmployeeID.Value) == employeeId) && (tkrdpStartDate.SelectedDate.Value == date_)) { // When End Time < StartTime (when they finish work the next day) if ((spanGridEndTime < spanGridStartTime) && (spanEndTime > spanStartTime)) { if (((spanStartTime >= spanGridStartTime) && (spanStartTime <= midNight)) || ((spanEndTime >= spanGridStartTime) && (spanEndTime <= midNight))) { cant++; } } else { if ((spanEndTime < spanStartTime) && (spanGridEndTime > spanGridStartTime)) { if (((spanGridStartTime >= spanStartTime) && (midNight <= spanStartTime)) || ((spanGridStartTime >= spanEndTime) && (midNight <= spanEndTime))) { cant++; } } else { if (((spanGridEndTime < spanGridStartTime) && (spanEndTime < spanStartTime))) { cant++; } else { // When End Time > Start Time. (times in the same day) // ... If it's a valid entry if (((spanStartTime < spanGridStartTime) && (spanEndTime <= spanGridStartTime)) || (spanStartTime >= spanGridEndTime) && (spanEndTime > spanGridEndTime)) { } else { // If the range exists cant++; } } } } } } } } if (cant == 0) { args.IsValid = true; } else { args.IsValid = false; } } } } } }
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; } } } } }