private DataTable GenerateFlowColumns() { DataTable table = new DataTable(); JobFlow jobflow = new JobFlow(); JobTypeFlow jobtypeflow = new JobTypeFlow(); jobflowList = jobflow.GetJobOverviewJobFlow(); DataColumn hwCol = new DataColumn("HW No", typeof(System.String)); DataColumn swCol = new DataColumn("SW No", typeof(System.String)); DataColumn cusCol = new DataColumn("Customer", typeof(System.String)); DataColumn jdCol = new DataColumn("Description", typeof(System.String)); table.Columns.Add(hwCol); table.Columns.Add(swCol); table.Columns.Add(cusCol); table.Columns.Add(jdCol); BoundField bfHw = new BoundField(); bfHw.HeaderText = "HW No"; bfHw.DataField = "HW No"; BoundField bfSw = new BoundField(); bfSw.HeaderText = "SW No"; bfSw.DataField = "SW No"; BoundField bfCus = new BoundField(); bfCus.HeaderText = "Customer"; bfCus.DataField = "Customer"; BoundField bfDes = new BoundField(); bfDes.HeaderText = "Description"; bfDes.DataField = "Description"; gridViewJobFlow.Columns.Add(bfHw); gridViewJobFlow.Columns.Add(bfSw); gridViewJobFlow.Columns.Add(bfCus); gridViewJobFlow.Columns.Add(bfDes); jobtypeflowlist = new List<List<JobTypeFlow>>(); for (int x = 0; x < jobflowList.Count;x++ ) //Creates the columns { var jobtypes = jobtypeflow.GetJobTypeFlowListByJobFlow(jobflowList[x].Id); jobtypeflowlist.Add(jobtypes); for (int i = 0; i < jobtypes.Count; i++) { string deptacro = ""; if (jobtypes[i].DepartmentId != null) deptacro = jobtypes[i].departmentAcronym; DataColumn col = new DataColumn(jobtypes[i].jobtypeAcronym + deptacro + "" + jobflowList[x].Id, typeof(System.String)); table.Columns.Add(col); TemplateField tfield = new TemplateField(); string sdept = ""; if (jobtypes[i].DepartmentId != null) sdept = jobtypes[i].departmentAcronym + "-"; tfield.HeaderText = sdept + jobtypes[i].jobtypeAcronym; gridViewJobFlow.Columns.Add(tfield); } } return table; }
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); } }
private void Parse(T_JobTypeFlow t_jobtypeflow, JobTypeFlow jobtypeflow) { t_jobtypeflow.JobTypeId = jobtypeflow.JobTypeId; t_jobtypeflow.JobFlowId = jobtypeflow.JobFlowId; t_jobtypeflow.Position = jobtypeflow.Position; t_jobtypeflow.DepartmentId = jobtypeflow.DepartmentId; }
protected void gridViewJobFlow_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) { GridViewRow gvr = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); TableHeaderCell thc = new TableHeaderCell(); thc.ColumnSpan = 4; thc.Text = "General Info"; //thc.BackColor = System.Drawing.Color.Yellow; gvr.Cells.Add(thc); System.Drawing.Color backcolor = System.Drawing.ColorTranslator.FromHtml("#164BDB"); System.Drawing.Color forecolor = System.Drawing.Color.White; JobFlow jobflow = new JobFlow(); JobTypeFlow jobtypeflow = new JobTypeFlow(); //var jobflows = jobflow.GetJobOverviewJobFlow(); int rowIndex = 4; for (int i = 0; i < jobflowList.Count; i++) { if (i % 2 != 0) { backcolor = System.Drawing.ColorTranslator.FromHtml("#0D72FF"); //forecolor = System.Drawing.ColorTranslator.FromHtml("#2e6e9e"); forecolor = System.Drawing.Color.White; } else { backcolor = System.Drawing.ColorTranslator.FromHtml("#164BDB"); forecolor = System.Drawing.Color.White; } //var jobtypes = jobtypeflow.GetJobTypeFlowListByJobFlow(jobflowList[i].Id); if (jobtypeflowlist[i].Count > 0) { thc = new TableHeaderCell(); thc.BackColor = backcolor; thc.ForeColor = forecolor; thc.ColumnSpan = jobtypeflowlist[i].Count; thc.Text = jobflowList[i].Description; gvr.Cells.Add(thc); } for (int x = 0; x < jobtypeflowlist[i].Count; x++) { e.Row.Cells[rowIndex].BackColor = backcolor; e.Row.Cells[rowIndex].ForeColor = forecolor; rowIndex++; } } gridViewJobFlow.Controls[0].Controls.AddAt(0, gvr); } }
public void Update(JobTypeFlow jobtypeflow) { using (TimeTrackerEntities db = new TimeTrackerEntities()) { try { T_JobTypeFlow t_jobtypeflow = db.T_JobTypeFlow.FirstOrDefault(f => f.Id == jobtypeflow.Id); Parse(t_jobtypeflow, jobtypeflow); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } } }
public void Insert(JobTypeFlow jobtypeflow) { T_JobTypeFlow t_jobtypeflow = new T_JobTypeFlow(); Parse(t_jobtypeflow, jobtypeflow); using (TimeTrackerEntities db = new TimeTrackerEntities()) { try { db.T_JobTypeFlow.Add(t_jobtypeflow); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } } }
private void InitializeModalGridView() { JobTypeFlow jobtypeflow = new JobTypeFlow(); int jobflowid = 0; if (modalLabelJobFlowId.Text.Trim() != "") { jobflowid = Convert.ToInt32(modalLabelJobFlowId.Text); } var data = jobtypeflow.GetJobTypeFlowListByJobFlow(jobflowid); gridViewModal.DataSource = data; gridViewModal.DataBind(); for (int i = 0; i < gridViewModal.Rows.Count; i++) { CheckBox cb = (CheckBox)gridViewModal.Rows[i].FindControl("modalChkJobType"); Label labelJobTypeId = (Label)gridViewModal.Rows[i].FindControl("modalLabelJobTypeId"); Label labelDeptId = (Label)gridViewModal.Rows[i].FindControl("modalLabelDepartmentId"); if (labelDeptId.Text.Trim() == "") { Label labelDept = (Label)gridViewModal.Rows[i].FindControl("modalLabelDepartment"); labelDept.Text = "All"; labelDeptId.Text = "0"; } labelJobTypeId.ToolTip = data[i].Id.ToString(); labelDeptId.ToolTip = data[i].Id.ToString(); } Session["JobFlows"] = data; }
protected void modalBtnSubmit_Command(object sender, CommandEventArgs e) { if (gridViewModal.Rows.Count == 0 ||(modalLabelJobFlowId.Text.Trim() != "" && IsCheckBoxEmpty())) { modalLabelError.Visible = true; modalLabelError.Text += " Please add atleast one department."; this.programmaticModalPopup.Show(); } else if (modalLabelError.Visible == true) this.programmaticModalPopup.Show(); else { JobFlow jobflow = new JobFlow(); if (modalLabelJobFlowId.Text.Trim() != "") { jobflow = jobflow.GetJobFlow(Convert.ToInt32(modalLabelJobFlowId.Text)); } jobflow.Description = modalTxtBoxDescription.Text.Trim(); jobflow.Acronym = modalTxtBoxAcronym.Text.Trim(); jobflow.Position = modalTxtBoxPosition.Text.Trim() == "" ? 0 : Convert.ToInt32(modalTxtBoxPosition.Text); if (modalLabelJobFlowId.Text.Trim() == "") { jobflow.Insert(jobflow); jobflow = jobflow.GetJobFlowByDescription(jobflow.Description); } else { jobflow.Update(jobflow); } for (int i = 0; i < gridViewModal.Rows.Count; i++) { JobTypeFlow jobTypeFlow = new JobTypeFlow(); CheckBox cb = (CheckBox)gridViewModal.Rows[i].FindControl("modalChkJobType"); Label labelJobTypeId = (Label)gridViewModal.Rows[i].FindControl("modalLabelJobTypeId"); Label labelDeptId = (Label)gridViewModal.Rows[i].FindControl("modalLabelDepartmentId"); TextBox txtBoxPosition = (TextBox)gridViewModal.Rows[i].FindControl("modalInnerTxtBoxPostion"); int jobtypeid = Convert.ToInt32(labelJobTypeId.Text); int? deptid = Convert.ToInt32(labelDeptId.Text.Trim() == "" ? "0" : labelDeptId.Text); if(deptid == 0) deptid = null; jobTypeFlow = jobTypeFlow.GetJobTypeFlow(jobflow.Id,jobtypeid,deptid); if (cb.Checked) { if (jobTypeFlow == null) { jobTypeFlow = new JobTypeFlow(); jobTypeFlow.JobFlowId = jobflow.Id; jobTypeFlow.JobTypeId = jobtypeid; jobTypeFlow.DepartmentId = deptid; jobTypeFlow.Position = txtBoxPosition.Text.Trim() == "" ? 0 : Convert.ToInt32(txtBoxPosition.Text.Trim()); jobTypeFlow.Insert(jobTypeFlow); } else { jobTypeFlow.Position = txtBoxPosition.Text.Trim() == "" ? 0 : Convert.ToInt32(txtBoxPosition.Text.Trim()); jobTypeFlow.Update(jobTypeFlow); } } else { if (jobTypeFlow != null) { jobTypeFlow.Delete(jobTypeFlow.Id); } } } if(IsCheckBoxEmpty()) { jobflow.Delete(jobflow.Id); } Session["JobFlows"] = null; InitializeMainGrid(); } }
protected void modalBtnAdd_Click(object sender, EventArgs e) { List<JobTypeFlow> jobflows = new List<JobTypeFlow>(); if (Session["JobFlows"] != null) { jobflows = (List<JobTypeFlow>)Session["JobFlows"]; } JobTypeFlow jobflow = new JobTypeFlow(); jobflow.JobTypeId = Convert.ToInt32(modalDropDownJobType.SelectedItem.Value); jobflow.jobtype = modalDropDownJobType.SelectedItem.Text.Trim(); jobflow.DepartmentId = Convert.ToInt32(modalDropDownDepartment.SelectedItem.Value); jobflow.department = modalDropDownDepartment.SelectedItem.Text.Trim(); jobflows.Add(jobflow); gridViewModal.DataSource = jobflows; gridViewModal.DataBind(); InitializeModalDepartment(); Session["JobFlows"] = jobflows; modalLabelError.Text = modalLabelError.Text.Replace("Please add atleast one department.", "").Trim(); if (modalLabelError.Text.Trim().Length == 0) { modalLabelError.Visible = false; } programmaticModalPopup.Show(); }