protected void Page_Load(object sender, EventArgs e) { try { MergeGridviewHeader_Info objVetMerge = new MergeGridviewHeader_Info(); if (GetSessionUserID() == 0) { Response.Redirect("~/account/login.aspx"); } String msgretv = String.Format("setTimeout(getOperatingSystem,500);"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgret6v", msgretv, true); UserAccessValidation(); setDateFormat(); if (!IsPostBack) { BindVesselDDL(); VET_Get_VettingTypeList(); Add_VettingStatus(); VET_Get_OilMajorList(); Add_JobStatus(); Bind_VettingIndex(); VET_Get_InspectorList(); } objVetMerge.AddMergedColumns(new int[] { 9, 10, 11, 12 }, "Report", "GroupHeaderStyle-css HeaderStyle-css"); objVetMerge.AddMergedColumns(new int[] { 13, 14, 15, 16 }, "Jobs", "GroupHeaderStyle-css HeaderStyle-css"); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
public static void SetProperty(MergeGridviewHeader_Info columnInfo) { MergeGridviewHeader.MergedColumns = columnInfo.MergedColumns; MergeGridviewHeader.StartColumns = columnInfo.StartColumns; MergeGridviewHeader.Titles = columnInfo.Titles; MergeGridviewHeader.MergedColumnCss = columnInfo.MergedColumnCss; }
public void BindOverDueJobs() { mergeheadgvOverdue = new MergeGridviewHeader_Info(); mergeheadgvOverdue.AddMergedColumns(new int[] { 7, 8 }, "Frequency", "PMSGridHeaderStyle-css"); mergeheadgvOverdue.AddMergedColumns(new int[] { 9, 10 }, "Last Done", "PMSGridHeaderStyle-css"); mergeheadgvOverdue.AddMergedColumns(new int[] { 14, 15 }, "M/C R. Hrs.", "PMSGridHeaderStyle-css"); int rowcount = ucCustomPagerItems.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataSet ds = objJobStatus.TecJobOverDueSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), ucf_DDLVessel.SelectedValues, ucf_DLLLocation.SelectedValues, ucf_DDLSubCatalogue.SelectedValues , UDFLib.ConvertIntegerToNull(DDLJobDepartment.SelectedValue), ucf_DDLRank.SelectedValues, UDFLib.ConvertStringToNull(ucf_txtSearchJobTitle.FilterText), ucf_txtSearchJobTitle.FilterType , UDFLib.ConvertIntegerToNull(ucf_txtSearchJobID.FilterNumber), ucf_txtSearchJobID.FilterType, ucf_optCritical.SelectedValues, ucf_optCMS.SelectedValues, null, null , UDFLib.ConvertIntegerToNull(ddlMonth.SelectedValue), UDFLib.ConvertIntegerToNull(ddlYear.SelectedValue), UDFLib.ConvertStringToNull(optStatus.SelectedValue) , sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { gvOverDueJobs.DataSource = ds.Tables[0]; gvOverDueJobs.DataBind(); if (ViewState["Jobid"] == null) { ViewState["Jobid"] = ds.Tables[0].Rows[0]["JOB_ID"].ToString(); ViewState["Job_OverDue_ID"] = ds.Tables[0].Rows[0]["OverDue_ID"].ToString(); ViewState["Vessel_ID"] = ds.Tables[0].Rows[0]["Vessel_ID"].ToString(); gvOverDueJobs.SelectedIndex = 0; //BindJobsOverdueHistory(Convert.ToInt32(ViewState["Jobid"].ToString())); } SetJobOverdueRowSelection(); } else { gvOverDueJobs.SelectedIndex = -1; gvOverDueJobs.DataSource = ds.Tables[0]; gvOverDueJobs.DataBind(); gvJobHistory.DataSource = ds.Tables[0]; gvJobHistory.DataBind(); } }
protected void gvVettingIndex_RowCreated(object sender, GridViewRowEventArgs e) { try { MergeGridviewHeader_Info objVetMerge = new MergeGridviewHeader_Info(); if (e.Row.RowType == DataControlRowType.Header) { MergeGridviewHeader.SetProperty(objVetMerge); e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
public void BindJobsOverdueHistory(int?Jobid) { BLL_PMS_Job_Status objJobStatus = new BLL_PMS_Job_Status(); mergeheadgvOverdueHistory = new MergeGridviewHeader_Info(); mergeheadgvOverdueHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css"); //mergeheadgvJobHistory = new MergeGridviewHeader_Info(); //mergeheadgvOverdueHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css"); int rowcount = ucCustomPagerItems.isCountRecord; int?jobid = null; if (ViewState["Jobid"] != null) { jobid = Convert.ToInt32(ViewState["Jobid"].ToString()); } DataSet ds = objJobStatus.TecJobsOverdueHistorySearch(jobid, null , null, null, null, null, null, null, null, null , null, null, null, null, null, null , null, null, ref rowcount); if (ds.Tables[0].Rows.Count > 0) { gvOverDueJobHistory.DataSource = ds.Tables[0]; gvOverDueJobHistory.DataBind(); //mergeheadgvJobHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css"); gvJobHistory.DataSource = ds.Tables[1]; gvJobHistory.DataBind(); } else { gvOverDueJobHistory.DataSource = ds.Tables[0]; gvOverDueJobHistory.DataBind(); // mergeheadgvJobHistory.AddMergedColumns(new int[] { 6, 7 }, "Frequency", "PMSGridHeaderStyle-css"); gvJobHistory.DataSource = ds.Tables[0]; gvJobHistory.DataBind(); } }
protected void gvVettingIndex_RowDataBound(object sender, GridViewRowEventArgs e) { try { MergeGridviewHeader_Info objVetMerge = new MergeGridviewHeader_Info(); if (e.Row.RowType == DataControlRowType.DataRow) { Label lblVettingId = (Label)e.Row.FindControl("lblVetting_Id"); Label lblOverDueRespondDate = (Label)e.Row.FindControl("lblOverDueRespondDate"); Label lblOverDueValidDate = (Label)e.Row.FindControl("lblOverDueValidDate"); Label lblVettingStatus = (Label)e.Row.FindControl("lblVetStatus"); Label lblOpenCloseResponse = (Label)e.Row.FindControl("lblResponse"); Label lblVettingDate = (Label)e.Row.FindControl("lblVetDate"); Label lblRespondDate = (Label)e.Row.FindControl("lblRespondDate"); Label lblValidDate = (Label)e.Row.FindControl("lblValidDate"); HyperLink hplinkPendingJob = (HyperLink)e.Row.FindControl("hplnkJobPending"); HyperLink hplinkJobCompleted = (HyperLink)e.Row.FindControl("hplnkJobCompleted"); HyperLink hplinkJobVerified = (HyperLink)e.Row.FindControl("hplnkJobVerified"); HyperLink hplinkJobDeffered = (HyperLink)e.Row.FindControl("hplnkJobDeffered"); HyperLink hplinkOpenJob = (HyperLink)e.Row.FindControl("hplnkOpenObs"); HyperLink hplinkCloseJob = (HyperLink)e.Row.FindControl("hplnkClosedObs"); HyperLink hplinkNote = (HyperLink)e.Row.FindControl("hplnkNote"); if (lblOverDueRespondDate.Text == "Y") { e.Row.Cells[5].BackColor = System.Drawing.Color.Red; e.Row.Cells[5].ForeColor = System.Drawing.Color.White; e.Row.Cells[5].Font.Bold = true; } if (lblOverDueValidDate.Text == "Y") { e.Row.Cells[6].BackColor = System.Drawing.Color.Red; e.Row.Cells[6].ForeColor = System.Drawing.Color.White; e.Row.Cells[6].Font.Bold = true; } ImageButton ImgDelete = (ImageButton)e.Row.FindControl("ImgDelete"); HyperLink ImgReport = (HyperLink)e.Row.FindControl("ImgReport"); if (lblVettingStatus.Text == "Planned") { ImgDelete.Visible = true; ImgReport.Visible = false; } else { ImgDelete.Visible = false; ImgReport.Visible = true; } ImageButton ImgRework = (ImageButton)e.Row.FindControl("ImgRework"); if (lblVettingStatus.Text == "Completed" || lblVettingStatus.Text == "Failed") { ImgRework.Visible = true; } else { ImgRework.Visible = false; } HyperLink ImgDetail = (HyperLink)e.Row.FindControl("ImgDetails"); ImgDetail.NavigateUrl = "../Vetting/Vetting_Details.aspx?Vetting_Id=" + DataBinder.Eval(e.Row.DataItem, "Vetting_ID").ToString(); if (lblVettingDate.Text != "") { lblVettingDate.Text = UDFLib.ConvertUserDateFormat(lblVettingDate.Text, UDFLib.GetDateFormat()); } if (lblRespondDate.Text != "") { lblRespondDate.Text = UDFLib.ConvertUserDateFormat(lblRespondDate.Text, UDFLib.GetDateFormat()); } if (lblValidDate.Text != "") { lblValidDate.Text = UDFLib.ConvertUserDateFormat(lblValidDate.Text, UDFLib.GetDateFormat()); } // if extra column is added need to changed in this condition for (int j = 0; j < 9; j++) { // Row should be clickable e.Row.Cells[j].Attributes.Add("onclick", "window.open('Vetting_Details.aspx?Vetting_Id=" + DataBinder.Eval(e.Row.DataItem, "Vetting_ID").ToString() + "','_blank');"); e.Row.Cells[j].Attributes.Add("style", "cursor:pointer;"); e.Row.Cells[j].Attributes["onmousedown"] = ClientScript.GetPostBackClientHyperlink(this.gvVettingIndex, "Select$" + e.Row.RowIndex); } // added hyperlink for response column e.Row.Cells[12].Attributes.Add("onclick", "window.open('Vetting_Details.aspx?Vetting_Id=" + DataBinder.Eval(e.Row.DataItem, "Vetting_ID").ToString() + "','_blank');"); e.Row.Cells[12].Attributes.Add("style", "cursor:pointer;"); e.Row.Cells[12].Attributes["onmousedown"] = ClientScript.GetPostBackClientHyperlink(this.gvVettingIndex, "Select$" + e.Row.RowIndex); for (int i = 9; i < e.Row.Controls.Count; i++) { string ObsOpenCount, ObsCloseCount, NotesCount, ResponseCount, PendJobCount, CompJobCount, VerifiedJobCount, DefferedJobCount; DataTable dtObservationCount = (DataTable)ViewState["dtObservationCount"]; string filteropnobsexpression = " Observation_Type_ID=2 and Status='Open' and Vetting_ID=" + lblVettingId.Text; DataRow[] drObsOpenCount = dtObservationCount.Select(filteropnobsexpression); if (drObsOpenCount.Length <= 0) { ObsOpenCount = "0"; hplinkOpenJob.Text = ObsOpenCount; } else { ObsOpenCount = drObsOpenCount[0][0].ToString(); hplinkOpenJob.Text = ObsOpenCount; } string filterclosedobsexpression = " Observation_Type_ID=2 and Status='Closed' and Vetting_ID=" + lblVettingId.Text; DataRow[] drObsCloseCount = dtObservationCount.Select(filterclosedobsexpression); if (drObsCloseCount.Length <= 0) { ObsCloseCount = "0"; hplinkCloseJob.Text = ObsCloseCount; } else { ObsCloseCount = drObsCloseCount[0][0].ToString(); hplinkCloseJob.Text = ObsCloseCount; } DataTable dtNotesCount = (DataTable)ViewState["dtNotesCount"]; string filternoteexpression = " Observation_Type_ID=1 and Vetting_ID=" + lblVettingId.Text; DataRow[] drNotesCount = dtNotesCount.Select(filternoteexpression); if (drNotesCount.Length <= 0) { NotesCount = "0"; hplinkNote.Text = NotesCount; } else { NotesCount = drNotesCount[0][0].ToString(); hplinkNote.Text = NotesCount; } DataTable dtResponseCount = (DataTable)ViewState["dtResponse"]; string filterresponseexpression = "Vetting_ID=" + lblVettingId.Text; DataRow[] drResponseCount = dtResponseCount.Select(filterresponseexpression); if (drResponseCount.Length <= 0) { ResponseCount = "0"; lblOpenCloseResponse.Text = ResponseCount; } else { ResponseCount = drResponseCount[0][0].ToString(); lblOpenCloseResponse.Text = ResponseCount; } DataTable dtJobCount = (DataTable)ViewState["dtJobsCount"]; string filterpendjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='PENDING'"; DataRow[] drPendJobCount = dtJobCount.Select(filterpendjobexpression); if (drPendJobCount.Length <= 0) { PendJobCount = "0"; hplinkPendingJob.Text = PendJobCount; } else { PendJobCount = drPendJobCount[0][0].ToString(); hplinkPendingJob.Text = PendJobCount; } string filtercompletedjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='COMPLETED'"; DataRow[] drComplJobCount = dtJobCount.Select(filtercompletedjobexpression); if (drComplJobCount.Length <= 0) { CompJobCount = "0"; hplinkJobCompleted.Text = CompJobCount; } else { CompJobCount = drComplJobCount[0][0].ToString(); hplinkJobCompleted.Text = CompJobCount; } string filterverifiedjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='VERIFY'"; DataRow[] drVerifiedJobCount = dtJobCount.Select(filterverifiedjobexpression); if (drVerifiedJobCount.Length <= 0) { VerifiedJobCount = "0"; hplinkJobVerified.Text = VerifiedJobCount; } else { VerifiedJobCount = drVerifiedJobCount[0][0].ToString(); hplinkJobVerified.Text = VerifiedJobCount; } string filterdefferedjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='DEFERRED'"; DataRow[] drDefferedJobCount = dtJobCount.Select(filterdefferedjobexpression); if (drDefferedJobCount.Length <= 0) { DefferedJobCount = "0"; hplinkJobDeffered.Text = DefferedJobCount; } else { DefferedJobCount = drDefferedJobCount[0][0].ToString(); hplinkJobDeffered.Text = DefferedJobCount; } } } if (e.Row.RowType == DataControlRowType.Header) { MergeGridviewHeader.SetProperty(objVetMerge); e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader); ViewState["DynamicHeaderCSS"] = "GroupHeaderStyle-css HeaderStyle-css"; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }