protected void gridLeftBtnAcceptAll_Click(object sender, EventArgs e) { foreach (GridViewRow row in gridViewLeftPanel1.Rows) { CheckBox cb = (CheckBox)row.FindControl("gridLeftChkBoxSelect"); if (cb.Checked) { int userid = Convert.ToInt32(Session["UserId"]); JobTracker jobtracker = new JobTracker(); JobTrackerHistory jtHist = new JobTrackerHistory(); //var data = jobtracker.GetRequestNeededApproval(userid); Label jobtrackId = (Label)row.FindControl("gridLeftlblJobTrackId"); jobtracker = jobtracker.GetJobTracker(Convert.ToInt32(jobtrackId.Text), false); if (jobtracker.ActionRequest == "Delete") { jobtracker.Status = "Approved"; jtHist = jtHist.ConvertToHistory(jobtracker); jobtracker.Delete(jobtracker.Id); } else { jobtracker.Status = "Approved"; jobtracker.Update(jobtracker); jtHist = jtHist.ConvertToHistory(jobtracker); } jtHist.Insert(jtHist); } } gridLeftChkBoxSelectAll.Checked = false; InitializeGridViewLeftPanel1(new List<string>()); InitializeGridViewLeftPanel2(); InitializeGridViewLeftPanel3(); }
protected void modalBtnSync_Command(object sender, CommandEventArgs e) { modalTxtBoxMessage.Text = "Initializing...."; modalTxtBoxMessage.Text = modalTxtBoxMessage.Text + Environment.NewLine + "Gathering Data...."; JobTracker jobtracker = new JobTracker(); var data = jobtracker.GetJobTrackerListWithJobId(false); for (int i = 0; i < data.Count; i++) { modalTxtBoxMessage.Text = modalTxtBoxMessage.Text + Environment.NewLine + "Synchronizing "+(i + 1)+" of "+ data.Count; jobtracker = jobtracker.GenerateHWAndSW(data[i].JobIdNumber.ToString().Trim()); data[i].Customer = jobtracker.Customer; data[i].Description = jobtracker.Description; data[i].HWNo = jobtracker.HWNo; data[i].SWNo = jobtracker.SWNo; data[i].EvalNo = jobtracker.EvalNo; jobtracker.Update(data[i]); } modalTxtBoxMessage.Text = modalTxtBoxMessage.Text + Environment.NewLine + "Synchronization Complete."; }
protected void modalBtnConfirm_Command(object sender, CommandEventArgs e) { string[] remarks = modalTxtBoxRemarks.Text.Replace("\n"," ").Trim().Split(' '); int counter = 0; Regex rgx = new Regex("[^a-zA-Z0-9]"); for (int i = 0; i < remarks.Length; i++) { if (rgx.Replace(remarks[i],"").Trim() != "") { counter++; } } if (counter > 2) { int userid = Convert.ToInt32(Session["UserId"]); if (e.CommandName == "RejectAll") { foreach (GridViewRow row in gridViewLeftPanel1.Rows) { CheckBox cb = (CheckBox)row.FindControl("gridLeftChkBoxSelect"); if (cb.Checked) { JobTracker jobtracker = new JobTracker(); JobTrackerHistory jtHist = new JobTrackerHistory(); Label jobtrackId = (Label)row.FindControl("gridLeftlblJobTrackId"); jobtracker = jobtracker.GetJobTracker(Convert.ToInt32(jobtrackId.Text), false); jobtracker.ApprovedBy = userid; jobtracker.LastUpdatedBy = userid; jobtracker.LastUpdateDate = DateTime.Now; jobtracker.SupervisorRemarks = modalTxtBoxRemarks.Text; jobtracker.Status = "Rejected"; jobtracker.Update(jobtracker); jtHist = jtHist.ConvertToHistory(jobtracker); jtHist.Insert(jtHist); } } gridLeftChkBoxSelectAll.Checked = false; InitializeGridViewLeftPanel1(new List<string>()); } else { JobTracker jobtracker = new JobTracker(); JobTrackerHistory jtHist = new JobTrackerHistory(); int id = Convert.ToInt32(e.CommandArgument); jobtracker = jobtracker.GetJobTracker(id, false); jobtracker.ApprovedBy = userid; jobtracker.LastUpdatedBy = userid; jobtracker.LastUpdateDate = DateTime.Now; jobtracker.SupervisorRemarks = modalTxtBoxRemarks.Text; jobtracker.Status = "Rejected"; jobtracker.Update(jobtracker); jtHist = jtHist.ConvertToHistory(jobtracker); jtHist.Insert(jtHist); List<string> selectedJobtrackerId = GetGridViewLeftPanel1SelectedJobIds(); InitializeGridViewLeftPanel1(selectedJobtrackerId); } InitializeGridViewLeftPanel2(); InitializeGridViewLeftPanel3(); } else { modalBottomLabelError.Text = "Minimum Three(3) Words"; modalBottomLabelError.Visible = true; programmaticModalPopup.Show(); } }
protected void gridViewLeftPanel1_RowCommand(object sender, GridViewCommandEventArgs e) { int userid = Convert.ToInt32(Session["UserId"]); int index = Convert.ToInt32(e.CommandArgument); JobTracker jobtracker = new JobTracker(); JobTrackerHistory jtHist = new JobTrackerHistory(); //var data = jobtracker.GetRequestNeededApproval(userid); Label jobtrackId = (Label)gridViewLeftPanel1.Rows[index].FindControl("gridLeftlblJobTrackId"); jobtracker = jobtracker.GetJobTracker(Convert.ToInt32(jobtrackId.Text),false); //data[index].LastUpdateDate = DateTime.Now; //data[index].LastUpdatedBy = userid; jobtracker.ApprovedBy = userid; jobtracker.LastUpdateDate = DateTime.Now; jobtracker.LastUpdatedBy = userid; if(e.CommandName == "AcceptRequest") { if (jobtracker.ActionRequest == "Delete") { jobtracker.Status = "Approved"; jtHist = jtHist.ConvertToHistory(jobtracker); jobtracker.Delete(jobtracker.Id); } else { jobtracker.Status = "Approved"; jobtracker.Update(jobtracker); jtHist = jtHist.ConvertToHistory(jobtracker); } jtHist.Insert(jtHist); List<string> selectedJobtrackerId = GetGridViewLeftPanel1SelectedJobIds(); InitializeGridViewLeftPanel1(selectedJobtrackerId); InitializeGridViewLeftPanel2(); InitializeGridViewLeftPanel3(); } else if (e.CommandName == "RejectRequest") { //data[index].Status = "Rejected"; modalBottomLabelError.Visible = false; modalBottomLabelError.Text = ""; modalBtnConfirm.CommandArgument = jobtracker.Id.ToString(); modalBtnConfirm.CommandName = "Reject"; modalTxtBoxRemarks.Text = ""; programmaticModalPopup.Show(); //jobtracker.Update(data[index]); //InitializeGridViewLeft(); } }
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e) { bool haserror = false; string errormessage = ""; if (modalLabelError.Visible == true) { errormessage = modalLabelError.Text; haserror = true; } else if (modalReqJobStatus.Enabled == true && modalDropDownJobStatus.SelectedItem.Value == "Completed" && modalDropDownEndTimeHour.SelectedItem.Text == "--") { errormessage = "Cannot set job status as Completed without selecting End Time."; haserror = true; } if (haserror) { //System.Web.HttpContext.Current.Response.Write("<SCRIPT LANGUAGE='JavaScript'>alert('Error: "+errormessage+"')</SCRIPT>"); panelAlertHeader2.CssClass = "modalAlertHeader"; alertModalBtnOK2.CssClass = "buttonalert"; labelAlertHeader2.Text = "Error"; labelAlertMessage2.Text = errormessage; this.programmaticModalPopup.Show(); programmaticAlertModalPopup2.Show(); } else { DateTime selectedDate = DateTime.Parse(txtBoxDate.Text); int userid = Convert.ToInt32(Session["UserId"]); JobTracker jobTracker = new JobTracker(); JobTrackerHistory jtHist = new JobTrackerHistory(); //DateTime startTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownStartTime.SelectedValue + ":00"); DateTime startTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownStartTimeHour.SelectedValue+":"+modalDropDownStartTimeMin.SelectedValue + ":00"); //DateTime endTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownEndTime.SelectedValue + ":00"); DateTime endTime; if (modalDropDownEndTimeHour.SelectedValue == "24") //end date selected is 12:00 AM next day { endTime = DateTime.Parse((selectedDate.AddDays(1)).Year + "-" + (selectedDate.AddDays(1)).Month + "-" + (selectedDate.AddDays(1)).Day + " 00:00:00"); } else { endTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownEndTimeHour.SelectedValue + ":" + modalDropDownEndTimeMin.SelectedValue + ":00"); } jobTracker.StartTime = startTime; jobTracker.ScheduleDate = selectedDate; //if (modalDropDownEndTime.SelectedItem.Text != "Select End Time") if (modalDropDownEndTimeHour.SelectedItem.Text != "--") { jobTracker.EndTime = endTime; } jobTracker.JobTypeId = Convert.ToInt32(modalDropDownJobType.SelectedValue); jobTracker.JobIdNumber = modalTxtBoxJobId.Text.Trim(); jobTracker.Remarks = modalTxtBoxRemarks.Text.Trim(); jobTracker.LastUpdateDate = DateTime.Now; jobTracker.LastUpdatedBy = userid; jobTracker.UserId = userid; jobTracker.HWNo = modalLabelHWSW.Text; jobTracker.SWNo = modalLabelHWSW.ToolTip; jobTracker.Customer = modallabelCustomer.Text; jobTracker.EvalNo = modalLabelEvalNo.Text; jobTracker.Description = modallabelBoxJobDescription.Text; //if (jobTracker.JobIdNumber.Trim() != "") jobTracker.JobStatus = modalDropDownJobStatus.SelectedItem.Value; if (modalReqJobStatus.Enabled == false) // Put blank on task that does not require job status. jobTracker.JobStatus = ""; if (selectedDate.CompareTo(DateTime.Today) == 0) { jobTracker.ApprovedBy = userid; //if (modalDropDownEndTime.SelectedItem.Text != "Select End Time") if (modalDropDownEndTimeHour.SelectedItem.Text != "--") jobTracker.Status = "Approved"; else jobTracker.Status = "Pending"; } else { jobTracker.Status = "For Approval"; } if (e.CommandArgument.ToString() == "Add") { if (selectedDate.CompareTo(DateTime.Today) != 0) { if ((DateTime.Now.Subtract(startTime)).TotalHours < 24) { jobTracker.Status = "Approved"; jobTracker.ApprovedBy = userid; } } jobTracker.CreateDate = DateTime.Now; jobTracker.SupervisorRemarks = ""; jobTracker.CreatedBy = userid; jobTracker.ActionRequest = "Add"; jobTracker.Insert(jobTracker); jobTracker = jobTracker.GetJobTracker(Convert.ToInt32(jobTracker.CreatedBy), Convert.ToInt32(jobTracker.LastUpdatedBy), Convert.ToDateTime(jobTracker.StartTime), Convert.ToInt32(jobTracker.JobTypeId), jobTracker.ActionRequest, jobTracker.Status,false); } else { if (selectedDate.CompareTo(DateTime.Today) != 0) { if ((DateTime.Now.Subtract(startTime)).TotalHours < 2) { jobTracker.Status = "Approved"; jobTracker.ApprovedBy = userid; } } jobTracker.Id = Convert.ToInt32(e.CommandArgument); jobTracker.ActionRequest = "Update"; jobTracker.Update(jobTracker); } //jobTracker.CreateDate = DateTime.Now; jtHist = jtHist.ConvertToHistory(jobTracker); jtHist.Insert(jtHist); InitializeWorkingHours(); InitializeGrid(); this.programmaticModalPopup.Hide(); } }
protected void modalBtnDelete_Command(object sender, CommandEventArgs e) { DateTime selectedDate = DateTime.Parse(txtBoxDate.Text); int userid = Convert.ToInt32(Session["UserId"]); JobTracker jobTracker = new JobTracker(); JobTrackerHistory jtHist = new JobTrackerHistory(); jobTracker.Id = Convert.ToInt32(e.CommandArgument); jobTracker = jobTracker.GetJobTracker(jobTracker.Id,false); if (selectedDate.CompareTo(DateTime.Today) == 0 || (jobTracker.Status == "Rejected" && jobTracker.ActionRequest != "Delete")) { jobTracker.ActionRequest = "Delete"; jobTracker.Status = "Approved"; jobTracker.LastUpdateDate = DateTime.Now; jobTracker.LastUpdatedBy = userid; jtHist = jtHist.ConvertToHistory(jobTracker); jobTracker.Delete(jobTracker.Id); } else { jobTracker.ActionRequest = "Delete"; jobTracker.Status = "For Approval"; jobTracker.LastUpdateDate = DateTime.Now; jobTracker.LastUpdatedBy = userid; jobTracker.Update(jobTracker); jtHist = jtHist.ConvertToHistory(jobTracker); } jtHist.Insert(jtHist); InitializeWorkingHours(); InitializeGrid(); }
private void RunBreakButtonActionForShifting() { int userid = Convert.ToInt32(Session["UserId"]); JobType jobtype = new JobType(); jobtype = jobtype.GetDefaultBreak(); DateTime selectedDate = DateTime.Parse(txtBoxDate.Text); JobTracker jobtracker = new JobTracker(); int jobtrackid = 0; bool noError = true; User user = new User(); user = user.GetUser(userid, selectedDate); TimeSpan cutOffTime = user.GetMyCutOfTime(); if (BtnBreak.Text == "Take a break") { DateTime startTime = new DateTime(); if (gridJobTrack.Rows.Count > 0) { jobtrackid = Convert.ToInt32(((Label)gridJobTrack.Rows[gridJobTrack.Rows.Count - 1].FindControl("labelJobTrackId")).Text); jobtracker = jobtracker.GetJobTracker(jobtrackid, false); JobType jtype = jobtype.GetJobType(Convert.ToInt32(jobtracker.JobTypeId)); if (Convert.ToDateTime(jobtracker.StartTime).TimeOfDay < cutOffTime && DateTime.Now.TimeOfDay >= cutOffTime) { if (jobtracker.EndTime == null) { noError = false; TimeSetting tsetting = new TimeSetting(); tsetting = tsetting.GetTimeSetting(); panelAlertHeader2.CssClass = "modalAlertHeader"; alertModalBtnOK2.CssClass = "buttonalert"; labelAlertHeader2.Text = "Error"; labelAlertMessage2.Text = "Please close all task first."; } else { GenerateStartHour(); GenerateStartMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value)); startTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownStartTimeHour.SelectedValue + ":" + modalDropDownStartTimeMin.SelectedValue + ":00"); } } else { if (jobtracker.EndTime == null) { DateTime stime = Convert.ToDateTime(jobtracker.StartTime); GenerateEndHour(stime.Hour, stime.Minute, true); GenerateEndMin(stime.Hour, stime.Minute, "--"); modalDropDownEndTimeHour.SelectedIndex = (modalDropDownEndTimeHour.Items.Count - 1); GenerateEndMin(stime.Hour, stime.Minute, modalDropDownEndTimeHour.SelectedItem.Text.Trim(), modalDropDownEndTimeMin.Items.Count == 0 ? "" : modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text.Trim() + ":" + modalDropDownEndTimeMin.SelectedItem.Text.Trim()); if (modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text != "--") { if (modalDropDownEndTimeHour.SelectedValue == "24") //end date selected is 12:00 AM next day { jobtracker.EndTime = DateTime.Parse((selectedDate.AddDays(1)).Year + "-" + (selectedDate.AddDays(1)).Month + "-" + (selectedDate.AddDays(1)).Day + " 00:00:00"); } else { jobtracker.EndTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Value + ":" + modalDropDownEndTimeMin.Items[modalDropDownEndTimeMin.Items.Count - 1].Value + ":00"); } jobtracker.Status = "Approved"; jobtracker.ApprovedBy = userid; jobtracker.ActionRequest = "Update"; jobtracker.Update(jobtracker); startTime = Convert.ToDateTime(jobtracker.EndTime); InitializeGrid(); } else { noError = false; TimeSetting tsetting = new TimeSetting(); tsetting = tsetting.GetTimeSetting(); panelAlertHeader2.CssClass = "modalAlertHeader"; alertModalBtnOK2.CssClass = "buttonalert"; labelAlertHeader2.Text = "Error"; labelAlertMessage2.Text = "Cannot take a break without spending at least " + tsetting + " minutes on the last task."; } } else { startTime = Convert.ToDateTime(jobtracker.EndTime); } } } else { GenerateStartHour(); GenerateStartMin(Convert.ToInt32(modalDropDownStartTimeHour.SelectedItem.Value)); startTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownStartTimeHour.SelectedValue + ":" + modalDropDownStartTimeMin.SelectedValue + ":00"); } if (noError) { jobtracker = new JobTracker(); jobtracker.StartTime = startTime; jobtracker.Status = "Pending"; jobtracker.JobStatus = ""; jobtracker.ApprovedBy = userid; jobtracker.ActionRequest = "Add"; jobtracker.UserId = userid; jobtracker.CreateDate = DateTime.Now; jobtracker.CreatedBy = userid; jobtracker.LastUpdateDate = DateTime.Now; jobtracker.LastUpdatedBy = userid; jobtracker.Description = jobtype.Description; jobtracker.JobTypeId = jobtype.Id; jobtracker.ScheduleDate = selectedDate; jobtracker.Remarks = ""; jobtracker.Insert(jobtracker); InitializeGrid(); } else { programmaticAlertModalPopup2.Show(); } } else if (BtnBreak.Text == "End break") { jobtrackid = Convert.ToInt32(((Label)gridJobTrack.Rows[gridJobTrack.Rows.Count - 1].FindControl("labelJobTrackId")).Text); jobtracker = jobtracker.GetJobTracker(jobtrackid, false); jobtracker.LastUpdateDate = DateTime.Now; jobtracker.LastUpdatedBy = userid; if (jobtracker.JobTypeId == jobtype.Id) { DateTime stime = Convert.ToDateTime(jobtracker.StartTime); GenerateEndHour(stime.Hour, stime.Minute, true); GenerateEndMin(stime.Hour, stime.Minute, "--"); modalDropDownEndTimeHour.SelectedIndex = (modalDropDownEndTimeHour.Items.Count - 1); GenerateEndMin(stime.Hour, stime.Minute, modalDropDownEndTimeHour.SelectedItem.Text.Trim(), modalDropDownEndTimeMin.Items.Count == 0 ? "" : modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text.Trim() + ":" + modalDropDownEndTimeMin.SelectedItem.Text.Trim()); if (modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Text != "--") { if (modalDropDownEndTimeHour.SelectedValue == "24") //end date selected is 12:00 AM next day { jobtracker.EndTime = DateTime.Parse((selectedDate.AddDays(1)).Year + "-" + (selectedDate.AddDays(1)).Month + "-" + (selectedDate.AddDays(1)).Day + " 00:00:00"); } else { jobtracker.EndTime = DateTime.Parse(selectedDate.Year + "-" + selectedDate.Month + "-" + selectedDate.Day + " " + modalDropDownEndTimeHour.Items[modalDropDownEndTimeHour.Items.Count - 1].Value + ":" + modalDropDownEndTimeMin.Items[modalDropDownEndTimeMin.Items.Count - 1].Value + ":00"); } jobtracker.Status = "Approved"; jobtracker.ApprovedBy = userid; jobtracker.ActionRequest = "Update"; jobtracker.Update(jobtracker); InitializeGrid(); } else//delete break if start time and end time are the same { jobtracker.Delete(jobtracker.Id); InitializeGrid(); } } if (gridJobTrack.Rows.Count > 1) // continue the last created job { for (int i = gridJobTrack.Rows.Count - 1; i >= 0; i--) { jobtrackid = Convert.ToInt32(((Label)gridJobTrack.Rows[i].FindControl("labelJobTrackId")).Text); JobTracker jtracker = jobtracker.GetJobTracker(jobtrackid, false); JobType jtype = jobtype.GetJobType(Convert.ToInt32(jtracker.JobTypeId)); if (jtype.ComputeTime == true) { jtracker.StartTime = jobtracker.EndTime; jtracker.UserId = userid; jtracker.CreateDate = DateTime.Now; jtracker.CreatedBy = userid; jtracker.LastUpdateDate = DateTime.Now; jtracker.LastUpdatedBy = userid; jtracker.EndTime = null; jtracker.ActionRequest = "Add"; jtracker.Status = "Approved"; if(Convert.ToDateTime(jobtracker.EndTime).TimeOfDay != new TimeSpan(0,0,0)) //only insert if endtime is not equal to 24:00 (next day) jtracker.Insert(jtracker); InitializeGrid(); break; } } } } }