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 ConnectToCAP() { JobTracker jobtracker = new JobTracker(); PanelLogin.Visible = jobtracker.CanConnectToCAP(); Panel_Error.Visible = !jobtracker.CanConnectToCAP(); }
public JobTrackerHistory ConvertToHistory(JobTracker jobtracker) { JobTrackerHistory jthist = new JobTrackerHistory(); jthist.JobTrackerId = jobtracker.Id; jthist.JobIdNumber = jobtracker.JobIdNumber; jthist.JobTypeId = jobtracker.JobTypeId; jthist.Remarks = jobtracker.Remarks; jthist.Description = jobtracker.Description; jthist.StartTime = jobtracker.StartTime; jthist.EndTime = jobtracker.EndTime; jthist.ApprovedBy = jobtracker.ApprovedBy; jthist.CreatedBy = jobtracker.CreatedBy; jthist.LastUpdateDate = jobtracker.LastUpdateDate; jthist.LastUpdatedBy = jobtracker.LastUpdatedBy; jthist.CreateDate = jobtracker.CreateDate; jthist.Status = jobtracker.Status; jthist.SupervisorRemarks = jobtracker.SupervisorRemarks; jthist.UserId = jobtracker.UserId; jthist.ScheduleDate = jobtracker.ScheduleDate; jthist.Action = jobtracker.ActionRequest; jthist.JobStatus = jobtracker.JobStatus; jthist.HWNo = jobtracker.HWNo; jthist.SWNo = jobtracker.SWNo; jthist.Customer = jobtracker.Customer; jthist.EvalNo = jobtracker.EvalNo; return jthist; }
protected void InitializeRepError() { JobTracker jobtracker = new JobTracker(); var data = jobtracker.GetUnclosedJobs(Convert.ToInt32(Session["UserId"])); List<string> openjobs = new List<string>(); foreach (JobTracker j in data) { openjobs.Add("Unclosed job: "+j.jobtype+", opened last "+Convert.ToDateTime(j.StartTime).ToString("dd-MMM-yyyy hh:mm")); } RepError.DataSource = openjobs; RepError.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { JobTracker jobtracker = new JobTracker(); if (!isValidUser() || (!jobtracker.CanConnectToCAP())) Response.Redirect("Login.aspx"); if (!HasAccess()) Response.Redirect("Dashboard.aspx"); HttpContext.Current.Session["siteSubHeader"] = "Report"; HttpContext.Current.Session["selectedTab"] = "Report"; if (!IsPostBack) { InitializeRepeater(); } }
protected void Page_Load(object sender, EventArgs e) { JobTracker jobtracker = new JobTracker(); if (!isValidUser() || (!jobtracker.CanConnectToCAP())) Response.Redirect("Login.aspx"); GetMyAccessRights(); if (myAccessRights == null) Response.Redirect("Dashboard.aspx"); HttpContext.Current.Session["siteSubHeader"] = "Setup"; HttpContext.Current.Session["selectedTab"] = "Setup"; if (!IsPostBack) { modalTxtBoxMessage.Attributes.Add("onchange", "DefaultValue();"); } }
protected void BtnBreak_Click(object sender, EventArgs e) { int userid = Convert.ToInt32(Session["UserId"]); JobType jobtype = new JobType(); jobtype = jobtype.GetDefaultBreak(); DateTime selectedDate = DateTime.Parse(txtBoxDate.Text); JobTracker jobtracker = new JobTracker(); bool noError = true; User user = new User(); user = user.GetUser(userid, selectedDate); if (jobtracker.HasPreviousUnclosedJobs(userid,DateTime.Today)) //check if user has unclosed jobs { noError = false; panelAlertHeader2.CssClass = "modalAlertHeader"; alertModalBtnOK2.CssClass = "buttonalert"; labelAlertHeader2.Text = "Error"; labelAlertMessage2.Text = "Please close all jobs before adding a new one."; programmaticAlertModalPopup2.Show(); } else { string errMsg = ""; errMsg = jobtracker.GetError(userid, selectedDate, 30); //check if there is an error if (errMsg.Trim() != "") { noError = false; panelAlertHeader2.CssClass = "modalAlertHeader"; alertModalBtnOK2.CssClass = "buttonalert"; labelAlertHeader2.Text = "Error"; labelAlertMessage2.Text = errMsg.Trim() + " Please settle error first."; programmaticAlertModalPopup2.Show(); } } if (noError) { if (TimeSpan.Parse(user.startTime) > TimeSpan.Parse(user.endTime)) //check if user has shifting hours { RunBreakButtonActionForShifting(); } else { RunBreakButtonAction(); } } }
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."; }
public List<Analysis> GetAnalysis(int departmentid, DateTime startdate, DateTime enddate, string stringjobid,string customer,int roleid) { List<Analysis> data = new List<Analysis>(); JobTracker jobtracker = new JobTracker(); List<JobTracker> joblist = new List<JobTracker>(); JobTypeDepartment jobtypeDepartment = new JobTypeDepartment(); List<JobType> jobtypelist = new List<JobType>(); if (departmentid == 0) { //joblist = jobtracker.GetJobTrackerForAnalysis(startdate, enddate); JobType jobtype = new JobType(); jobtypelist = jobtype.GetJobTypeListByRoleId(roleid); } else { //joblist = jobtracker.GetJobTrackerForAnalysis(departmentid, startdate, enddate); jobtypelist = jobtypeDepartment.GetJobTypeList(departmentid); } for (int i = 0; i < jobtypelist.Count; i++) { Analysis newAnalysis = new Analysis(); newAnalysis.jobtype = jobtypelist[i].Description; newAnalysis.jobtypeid = jobtypelist[i].Id.ToString(); newAnalysis.totalworktime = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "Approved", departmentid, stringjobid,customer); newAnalysis.totalforapproval = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "For Approval", departmentid, stringjobid,customer); newAnalysis.totaljobTime = ""; if (stringjobid.Trim() != "" || customer.Trim() != "") { newAnalysis.totaljobTime = jobtracker.GetTotalHours(jobtypelist[i].Id, Convert.ToDateTime("1900-01-01"), DateTime.Now, "Approved", departmentid, stringjobid, customer); } //newAnalysis.totalrejectedtime = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "Rejected", departmentid, stringjobid,customer); //newAnalysis.totalunclosedjobs = jobtracker.GetTotalUnclosedJobs(jobtypelist[i].Id, startdate, enddate, "Pending", departmentid, stringjobid).ToString(); data.Add(newAnalysis); } return data; }
protected void Page_Load(object sender, EventArgs e) { JobTracker jobtracker = new JobTracker(); if (!isValidUser() || (!jobtracker.CanConnectToCAP())) Response.Redirect("Login.aspx"); GetMyAccessRights(); if (myAccessRights == null) Response.Redirect("Dashboard.aspx"); HttpContext.Current.Session["siteSubHeader"] = "Setup"; HttpContext.Current.Session["selectedTab"] = "Setup"; if (!IsPostBack) { modalTxtBoxStartDate.Attributes.Add("readonly", "readonly"); //prevents user from typing on calendar textbox InitializeDropDownDepartment(); InitializeGridUser(); calendarExtenderStartDate.EndDate = DateTime.Today; calendarExtenderPatternStartDate.EndDate = DateTime.Today; } }
protected void Page_Load(object sender, EventArgs e) { JobTracker jobtracker = new JobTracker(); if (!isValidUser() || (!jobtracker.CanConnectToCAP())) Response.Redirect("Login.aspx"); GetMyAccessRights(); if (myAccessRights == null) Response.Redirect("Dashboard.aspx"); HttpContext.Current.Session["siteSubHeader"] = "Setup"; HttpContext.Current.Session["selectedTab"] = "Setup"; if (!IsPostBack) { InitializeDropDownDepartment(); InitializeGridUser(); } }
protected void InitializeGridViewBottom2() { JobTracker jobTracker = new JobTracker(); List<JobTracker> data = new List<JobTracker>(); gridViewBottom2.EmptyDataText = "No data found"; if (ddlBottomPersonel.Items.Count > 0) { //if (ddlBottomPersonel.SelectedItem.Text.Trim() != "All") //{ // gridViewBottom2.EmptyDataText = "No Data Found"; // int personelid = Convert.ToInt32(ddlBottomPersonel.SelectedItem.Value); // DateTime startdate = Convert.ToDateTime(txtBoxBottomFromDate.Text.Trim() + " 00:00:00"); // DateTime enddate = Convert.ToDateTime(txtBoxBottomToDate.Text.Trim() + " 23:59:59"); // data = jobTracker.GetJobTrackerListExcludeRejected(personelid, startdate, enddate, false); //} //else //{ DateTime startdate = Convert.ToDateTime(txtBoxBottomFromDate.Text.Trim() + " 00:00:00"); DateTime enddate = Convert.ToDateTime(txtBoxBottomToDate.Text.Trim() + " 23:59:59"); int deptid = Convert.ToInt32(ddlBottomDepartment.SelectedValue); string jobid = txtBoxBottomJobId.Text.Trim(); string customer = txtBoxBottomCustomer.Text.Trim(); int userid = Convert.ToInt32(ddlBottomPersonel.SelectedItem.Value); data = jobTracker.GetJobTrackerListExcludeRejected(startdate, enddate, userid, deptid, jobid, customer,true); //} } gridViewBottom2.DataSource = data; gridViewBottom2.DataBind(); }
private void GenerateSummaryRows(ref DataTable table) { Department dept = new Department(); JobTypeDepartment jobtypeDepartment = new JobTypeDepartment(); JobTracker jobtracker = new JobTracker(); //joboverviewDepartment = dept.GetJobOverviewDepartment(); distincProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim()); joboverviewRow = new List<List<List<JobTracker>>>(); for (int y = 0; y < distincProjectList.Count;y++ ) { joboverviewRow.Add(new List<List<JobTracker>>()); DataRow row = table.NewRow(); row["HW No"] = distincProjectList[y].HWNo == null ? "" : distincProjectList[y].HWNo.Trim(); row["SW No"] = distincProjectList[y].SWNo == null ? "" : distincProjectList[y].SWNo.Trim(); row["Customer"] = distincProjectList[y].Customer == null ? "" : distincProjectList[y].Customer.Trim(); row["Description"] = distincProjectList[y].Description == null ? "" : distincProjectList[y].Description.Trim(); for (int x = 0; x < joboverviewDepartment.Count; x++) { List<JobTracker> jtlist = new List<JobTracker>(); for (int i = 0; i < joboverviewJobType[x].Count; i++) { JobTracker l = jobtracker.GetJobTrackerJobOverview(joboverviewJobType[x][i].Id, distincProjectList[y].SWNo, distincProjectList[y].HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), joboverviewDepartment[x].Id); jtlist.Add(l); } joboverviewRow[y].Add(jtlist); JobTracker j = new JobTracker(); string curstatus = ""; int curindex = -1; for (int i = 0; i < jtlist.Count; i++) { if (jtlist[i] == null) continue; else if (jtlist[i].JobStatus.IndexOf("On Hold") > -1) { curstatus = "On Hold"; curindex = i; break; } else if (jtlist[i].JobStatus.IndexOf("In Progress") > -1) { if (curstatus != "In Progress") { curstatus = "In Progress"; curindex = i; } } else if (jtlist[i].JobStatus.IndexOf("Completed") > -1 && curindex < 0) { if (curstatus == "") { curstatus = "Completed"; curindex = i; } } } if (curindex != -1) { j = jtlist[curindex]; } //JobTracker j = jobtracker.GetJobTrackerJobOverview(p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), d.Id); if (j == null) { row[joboverviewDepartment[x].Acronym + "" + joboverviewDepartment[x].Id] = ""; } else { row[joboverviewDepartment[x].Acronym + "" + joboverviewDepartment[x].Id] = joboverviewDepartment[x].Id + "|" + j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy") + "|" + distincProjectList[y].HWNo + "|" + distincProjectList[y].SWNo; } } table.Rows.Add(row); } }
private void ParseJobTracker(T_JobTracker data,JobTracker jobtracker) { data.Id = jobtracker.Id; data.JobIdNumber = jobtracker.JobIdNumber; data.JobTypeId = jobtracker.JobTypeId; data.Remarks = jobtracker.Remarks; data.Description = jobtracker.Description; data.StartTime = jobtracker.StartTime; data.EndTime = jobtracker.EndTime; data.ApprovedBy = jobtracker.ApprovedBy; data.CreatedBy = jobtracker.CreatedBy; data.LastUpdateDate = jobtracker.LastUpdateDate; data.LastUpdatedBy = jobtracker.LastUpdatedBy; data.CreateDate = jobtracker.CreateDate; data.Status = jobtracker.Status; data.SupervisorRemarks = jobtracker.SupervisorRemarks; data.UserId = jobtracker.UserId; data.ScheduleDate = jobtracker.ScheduleDate; data.ActionRequest = jobtracker.ActionRequest; data.HWNo = jobtracker.HWNo; data.SWNo = jobtracker.SWNo; data.JobStatus = jobtracker.JobStatus; data.Customer = jobtracker.Customer; data.EvalNo = jobtracker.EvalNo; }
//Get Jobtracker data for Overview Tab public JobTracker GetJobTrackerJobOverview(string SW, string HW, DateTime sdate, DateTime edate, int departmentid) { TimeTrackerEntities db = new TimeTrackerEntities(); var data = (from j in db.T_JobTracker where j.M_User.DepartmentId == departmentid && //((j.StartTime >= sdate //&& j.StartTime <= edate) //|| //(j.EndTime >= sdate && j.EndTime <= edate)) j.EndTime <= edate && j.Status == "Approved" && j.SWNo == SW && j.HWNo == HW orderby j.EndTime descending select new JobTracker() { Id = j.Id, UserId = j.UserId, StartTime = j.StartTime, EndTime = j.EndTime, Description = j.Description, JobTypeId = j.JobTypeId, JobIdNumber = j.JobIdNumber, jobtype = j.M_JobType.Description, Remarks = j.Remarks, ApprovedBy = j.ApprovedBy, CreateDate = j.CreateDate, LastUpdateDate = j.LastUpdateDate, CreatedBy = j.CreatedBy, LastUpdatedBy = j.LastUpdatedBy, Status = j.Status, SupervisorRemarks = j.SupervisorRemarks, ActionRequest = j.ActionRequest, ScheduleDate = j.ScheduleDate, SWNo = j.SWNo, HWNo = j.HWNo, JobStatus = j.JobStatus, fullname = j.M_User.Firstname + " " + j.M_User.Lastname, Customer = j.Customer, EvalNo = j.EvalNo }).ToList(); db.Dispose(); JobTracker result = new JobTracker(); string curstatus = ""; int curindex = -1; for (int i = 0; i < data.Count; i++) { if (data[i].JobStatus.IndexOf("On Hold") > -1) { curstatus = "On Hold"; curindex = i; break; } else if (data[i].JobStatus.IndexOf("In Progress") > -1) { if (curstatus != "In Progress") { curstatus = "In Progress"; curindex = i; } } else if (data[i].JobStatus.IndexOf("Completed") > -1 && curindex < 0) { if (curstatus == "") { curstatus = "Completed"; curindex = i; } } } if (curindex != -1) { result = data[curindex]; } return result; }
public JobTracker GenerateHWAndSWOld(string jobidnumber) { JobTracker jobtracker = new JobTracker(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc,SO_TotalSolSO,SO.SO_EvalNo from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.Customer = reader["CO_Name"].ToString(); jobtracker.Description = reader["SO_PCBdesc"].ToString(); jobtracker.HWNo = reader["SO_Num"].ToString(); jobtracker.SWNo = reader["SO_TotalSolSO"].ToString(); jobtracker.EvalNo = reader["SO_EvalNo"].ToString(); } } if (jobtracker.HWNo == null || jobtracker.HWNo.Trim() == "") { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc,SO_TotalSolSO,SO.SO_EvalNo from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.Customer = reader["CO_Name"].ToString(); jobtracker.Description = reader["SO_PCBdesc"].ToString(); jobtracker.SWNo = reader["SO_Num"].ToString(); jobtracker.HWNo = reader["SO_TotalSolSO"].ToString(); jobtracker.EvalNo = reader["SO_EvalNo"].ToString(); } } } return jobtracker; }
public void Update(JobTracker jobtracker) { using (TimeTrackerEntities db = new TimeTrackerEntities()) { try { T_JobTracker t_jobtracker = db.T_JobTracker.FirstOrDefault(j => j.Id == jobtracker.Id); UpdateParse(t_jobtracker, jobtracker); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } } }
protected void Page_Load(object sender, EventArgs e) { JobTracker jobtracker = new JobTracker(); if (!isValidUser() || (!jobtracker.CanConnectToCAP())) Response.Redirect("Login.aspx"); HttpContext.Current.Session["siteSubHeader"] = "Dashboard"; HttpContext.Current.Session["selectedTab"] = "Dashboard"; if (!IsPostBack) { txtBoxBottomFromDate.Attributes.Add("readonly", "readonly"); txtBoxBottomToDate.Attributes.Add("readonly", "readonly"); calExtBottomFromDate.SelectedDate = DateTime.Now; calExtBottomFromDate.EndDate = DateTime.Now; txtBoxBottomFromDate.Text = DateTime.Now.ToString("dd MMM yyyy"); calExtBottomToDate.SelectedDate = DateTime.Now; calExtBottomToDate.StartDate = DateTime.Now; calExtBottomToDate.EndDate = DateTime.Now; txtBoxBottomToDate.Text = DateTime.Now.ToString("dd MMM yyyy"); if (!isSupervisor()) { gridLeftChkBoxSelectAll.Checked = false; tabPanelLeft1.Visible = false; } InitializeGridViewLeftPanel1(new List<string>()); InitializeGridViewLeftPanel2(); InitializeGridViewLeftPanel3(); InitializeBottomDropDownDepartment(); InitializeBottomDropDownPersonel(); InitializeGridViewBottom(); InitializeGridViewBottom2(); } }
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 linkButtonBottom_Command(object sender, CommandEventArgs e) { if (ddlBottomPersonel.Items.Count > 0) { JobTracker jobTracker = new JobTracker(); string jobtypeid = e.CommandArgument.ToString(); List<JobTracker> data = new List<JobTracker>(); string[] argument = jobtypeid.Split('|'); DateTime startdate = Convert.ToDateTime(txtBoxBottomFromDate.Text.Trim() + " 00:00:00"); DateTime enddate = Convert.ToDateTime(txtBoxBottomToDate.Text.Trim() + " 23:59:59"); if (argument.Count() > 3) { startdate = Convert.ToDateTime("1900-01-01"); enddate = DateTime.Now; } LinkButton lb = (LinkButton)sender; int deptid = Convert.ToInt32(ddlBottomDepartment.SelectedValue); string jobid = txtBoxBottomJobId.Text.Trim(); string customer = txtBoxBottomCustomer.Text.Trim(); int userid = Convert.ToInt32(ddlBottomPersonel.SelectedItem.Value); data = jobTracker.GetJobTrackerList(startdate, enddate,Convert.ToInt32(argument[0]),argument[2].Trim(), userid, deptid, jobid, customer,true); labelmodalBottom.Text = argument[1] + " - " + lb.Text+" - "+argument[2]; gridViewModalBottom.DataSource = data; gridViewModalBottom.DataBind(); programmaticModalPopupBottom.Show(); } }
protected void InitializeGridViewLeftPanel3() { int userid = Convert.ToInt32(Session["UserId"]); JobTracker jobTracker = new JobTracker(); List<JobTracker> data = new List<JobTracker>(); data = jobTracker.GetRejectedRequest(userid,false); Converter model = new Converter(); DataTable table = model.ConvertToDataTable(data); gridViewLeftPanel3.DataSource = table; gridViewLeftPanel3.DataBind(); }
protected void InitializeGridViewLeftPanel1(List<string> selectedjobtrack) { int userid = Convert.ToInt32(Session["UserId"]); JobTracker jobTracker = new JobTracker(); List<JobTracker> data = new List<JobTracker>(); data = jobTracker.GetRequestNeededApproval(userid,false); Converter model = new Converter(); DataTable table = model.ConvertToDataTable(data); gridViewLeftPanel1.DataSource = table; gridViewLeftPanel1.DataBind(); if (selectedjobtrack.Count > 0) { for (int i = 0; i < selectedjobtrack.Count; i++) { foreach (GridViewRow row in gridViewLeftPanel1.Rows) { string jobtrackId = ((Label)row.FindControl("gridLeftlblJobTrackId")).Text.Trim(); if (selectedjobtrack[i] == jobtrackId) { CheckBox cb = (CheckBox)row.FindControl("gridLeftChkBoxSelect"); cb.Checked = true; selectedjobtrack.RemoveAt(i); --i; break; } } } } }
//private JobTracker GetCustomer(string jobid) //{ // JobTracker jobTracker = new JobTracker(); // using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString())) // { // SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobid.Trim() + "'", con); // con.Open(); // SqlDataReader reader = cmd.ExecuteReader(); // while (reader.Read()) // { // jobTracker.Customer = reader["CO_Name"].ToString(); // jobTracker.Description = reader["SO_PCBdesc"].ToString(); // } // } // if (jobTracker.Customer == null || jobTracker.Customer == "") // { // using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString())) // { // SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobid.Trim() + "'", con); // con.Open(); // SqlDataReader reader = cmd.ExecuteReader(); // while (reader.Read()) // { // jobTracker.Customer = reader["CO_Name"].ToString(); // jobTracker.Description = reader["SO_PCBdesc"].ToString(); // } // } // } // return jobTracker; //} //private void GetCustomer(JobTracker jobtracker) //{ // if (jobtracker.HWNo != null && jobtracker.HWNo.Trim() != "") // { // using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString())) // { // SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobtracker.HWNo.Trim() + "'", con); // con.Open(); // SqlDataReader reader = cmd.ExecuteReader(); // while (reader.Read()) // { // jobtracker.Customer = reader["CO_Name"].ToString(); // jobtracker.Description = reader["SO_PCBdesc"].ToString(); // } // } // } // else if ((jobtracker.SWNo != null && jobtracker.SWNo.Trim() != "") && (jobtracker.Customer == null || jobtracker.Customer.Trim() == "")) // { // using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString())) // { // SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobtracker.SWNo.Trim() + "'", con); // con.Open(); // SqlDataReader reader = cmd.ExecuteReader(); // while (reader.Read()) // { // jobtracker.Customer = reader["CO_Name"].ToString(); // jobtracker.Description = reader["SO_PCBdesc"].ToString(); // } // } // } //} public void Insert(JobTracker jobtracker) { T_JobTracker j = new T_JobTracker(); ParseJobTracker(j, jobtracker); using (TimeTrackerEntities db = new TimeTrackerEntities()) { try { db.T_JobTracker.Add(j); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } } }
protected void lnkBtn_Command(object sender, CommandEventArgs e) { if (e.CommandName == "JobOverviewDetails") { JobTracker j = new JobTracker(); j = j.GetJobTracker(Convert.ToInt32(e.CommandArgument),false); modalDetailLabelName.Text = j.fullname; modalDetailLabelJobType.Text = j.jobtype; modalDetailLabelJobStatus.Text = j.JobStatus; modalDetailLabelDate.Text = Convert.ToDateTime(j.ScheduleDate).ToString("dd-MMM-yyyy"); modalDetailLabelStartTime.Text = Convert.ToDateTime(j.StartTime).ToString("hh:mm tt"); modalDetailLabelEndTime.Text = Convert.ToDateTime(j.EndTime).ToString("hh:mm tt"); modalDetailTxtBoxRemarks.Text = j.Remarks; this.programmaticModalPopupDetail.Show(); } else if (e.CommandName == "JobOverviewSummary") { JobTypeDepartment jobtypeDepartment = new JobTypeDepartment(); JobTracker jobtracker = new JobTracker(); string argument = e.CommandArgument.ToString(); string[] s = argument.Split('|'); var jobtypes = jobtypeDepartment.GetJobOverviewJobType(Convert.ToInt32(s[0])); Dictionary<string, string> repeaterdata = new Dictionary<string, string>(); for (int i = 0; i < jobtypes.Count; i++) { JobTracker j = jobtracker.GetJobTrackerJobOverview(jobtypes[i].Id, s[2], s[1], Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), Convert.ToInt32(s[0])); if (j == null) { repeaterdata.Add(jobtypes[i].Description, ""); } else { repeaterdata.Add(jobtypes[i].Description, j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy")); } } modalSummaryRepeater.DataSource = repeaterdata; modalSummaryRepeater.DataBind(); programmaticModalPopupSummary.Show(); } }
public JobTracker GenerateHWAndSWOld2(string jobidnumber) { JobTracker jobtracker = new JobTracker(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.Customer = reader["CO_Name"].ToString(); jobtracker.Description = reader["SO_PCBdesc"].ToString(); jobtracker.HWNo = reader["SO_Num"].ToString(); } } if (jobtracker.HWNo == null || jobtracker.HWNo.Trim() == "") { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.Customer = reader["CO_Name"].ToString(); jobtracker.Description = reader["SO_PCBdesc"].ToString(); jobtracker.SWNo = reader["SO_Num"].ToString(); } } if (jobtracker.SWNo != null && jobtracker.SWNo.Trim() != "") { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where '" + jobtracker.Description.Trim() + "' Like '%'+CAST(SO_Num as varchar(20))+'%' ORDER BY SO_NUM Desc", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.HWNo = reader["SO_Num"].ToString(); } } if (jobtracker.HWNo == null || jobtracker.HWNo.Trim() == "") { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where SO_PCBdesc Like '%" + jobtracker.SWNo.Trim() + "%' ORDER BY SO_NUM Desc", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.HWNo = reader["SO_Num"].ToString(); } } } } } else { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where '" + jobtracker.Description.Trim() + "' Like '%'+CAST(SO_Num as varchar(20))+'%' ORDER BY SO_NUM Desc", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.SWNo = reader["SO_Num"].ToString(); } } if (jobtracker.SWNo == null || jobtracker.SWNo.Trim() == "") { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString())) { SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where SO_PCBdesc Like '%" + jobtracker.HWNo.Trim() + "%' ORDER BY SO_NUM Desc", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobtracker.SWNo = reader["SO_Num"].ToString(); } } } } return jobtracker; }
private void GenerateDetailsRows(ref DataTable table) { Department dept = new Department(); JobTypeDepartment jobtypeDepartment = new JobTypeDepartment(); JobTracker jobtracker = new JobTracker(); //var departments = dept.GetJobOverviewDepartment(); //var distinctProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim()); for (int y = 0; y < distincProjectList.Count;y++ ) { DataRow row = table.NewRow(); row["HW No"] = distincProjectList[y].HWNo == null ? "" : distincProjectList[y].HWNo.Trim(); row["SW No"] = distincProjectList[y].SWNo == null ? "" : distincProjectList[y].SWNo.Trim(); row["Customer"] = distincProjectList[y].Customer == null ? "" : distincProjectList[y].Customer.Trim(); row["Description"] = distincProjectList[y].Description == null ? "" : distincProjectList[y].Description.Trim(); for (int x = 0; x < joboverviewDepartment.Count; x++) { //var jobtypes = jobtypeDepartment.GetJobOverviewJobType(d.Id); for (int i = 0; i < joboverviewJobType[x].Count; i++) { //JobTracker j = jobtracker.GetJobTrackerJobOverview(joboverviewJobType[x][i].Id, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), joboverviewDepartment[x].Id); if (joboverviewRow[y][x][i] == null) { row[joboverviewJobType[x][i].Acronym + "" + joboverviewDepartment[x].Id] = ""; } else { row[joboverviewJobType[x][i].Acronym + "" + joboverviewDepartment[x].Id] = joboverviewRow[y][x][i].Id + "|" + joboverviewRow[y][x][i].JobStatus + " " + Convert.ToDateTime(joboverviewRow[y][x][i].EndTime).ToString("dd-MMM-yyyy"); } } } table.Rows.Add(row); } }
private void UpdateParse(T_JobTracker t_jobtracker, JobTracker jobtracker) { t_jobtracker.JobIdNumber = jobtracker.JobIdNumber; t_jobtracker.JobTypeId = jobtracker.JobTypeId; t_jobtracker.Remarks = jobtracker.Remarks; t_jobtracker.Description = jobtracker.Description; t_jobtracker.StartTime = jobtracker.StartTime; t_jobtracker.EndTime = jobtracker.EndTime; t_jobtracker.ApprovedBy = jobtracker.ApprovedBy; t_jobtracker.LastUpdateDate = jobtracker.LastUpdateDate; t_jobtracker.LastUpdatedBy = jobtracker.LastUpdatedBy; t_jobtracker.Status = jobtracker.Status; t_jobtracker.SupervisorRemarks = jobtracker.SupervisorRemarks; t_jobtracker.UserId = jobtracker.UserId; t_jobtracker.ScheduleDate = jobtracker.ScheduleDate; t_jobtracker.ActionRequest = jobtracker.ActionRequest; t_jobtracker.HWNo = jobtracker.HWNo; t_jobtracker.SWNo = jobtracker.SWNo; t_jobtracker.JobStatus = jobtracker.JobStatus; t_jobtracker.Customer = jobtracker.Customer; t_jobtracker.EvalNo = jobtracker.EvalNo; }
private void GenerateFlowRows(ref DataTable table) { JobFlow jobflow = new JobFlow(); JobTypeFlow jobtypeFlow = new JobTypeFlow(); JobTracker jobtracker = new JobTracker(); //var jobflows = jobflow.GetJobOverviewJobFlow(); //var distinctProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim()); foreach (JobTracker p in distincProjectList) { DataRow row = table.NewRow(); row["HW No"] = p.HWNo == null ? "" : p.HWNo.Trim(); row["SW No"] = p.SWNo == null ? "" : p.SWNo.Trim(); row["Customer"] = p.Customer == null ? "" : p.Customer.Trim(); row["Description"] = p.Description == null ? "" : p.Description.Trim(); for (int x = 0; x < jobflowList.Count; x++) { //var jobtypes = jobtypeFlow.GetJobTypeFlowListByJobFlow(jobflowList[x].Id); for (int i = 0; i < jobtypeflowlist[x].Count; i++) { JobTracker j = new JobTracker(); string deptacro = ""; if (jobtypeflowlist[x][i].DepartmentId != null) deptacro = jobtypeflowlist[x][i].departmentAcronym; if (jobtypeflowlist[x][i].DepartmentId != null) { j = jobtracker.GetJobTrackerJobOverview(jobtypeflowlist[x][i].JobTypeId, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), Convert.ToInt32(jobtypeflowlist[x][i].DepartmentId)); } else { j = jobtracker.GetJobTrackerJobOverview(jobtypeflowlist[x][i].JobTypeId, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59")); } if (j == null) { row[jobtypeflowlist[x][i].jobtypeAcronym + deptacro + "" + jobflowList[x].Id] = ""; } else { row[jobtypeflowlist[x][i].jobtypeAcronym + deptacro + "" + jobflowList[x].Id] = j.Id + "|" + j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy"); } } } table.Rows.Add(row); } }
protected void Page_Load(object sender, EventArgs e) { JobTracker jobtracker = new JobTracker(); if (!isValidUser() || (!jobtracker.CanConnectToCAP())) Response.Redirect("Login.aspx"); HttpContext.Current.Session["siteSubHeader"] = "JobOverview"; HttpContext.Current.Session["selectedTab"] = "JobOverview"; if (!IsPostBack) { txtBoxStartDate.Attributes.Add("readonly", "readonly"); txtBoxEndDate.Attributes.Add("readonly", "readonly"); InitializeStartDate(); InitializeEndDate(); //GenerateDynamicGrid(); } GenerateDynamicGrid(); }
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(); } }