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);
}
}
