private void BindDrillAttachments() { DataTable dt = BLL_SCM_Report.SCMGetDrillAttachment(Convert.ToInt32(Request.QueryString["DRILLID"].ToString()), Convert.ToInt32(Request.QueryString["Vessel_ID"].ToString())); if (dt.Rows.Count > 0) { //Bind the header txtVessel.Text = dt.Rows[0]["Vessel_Name"].ToString(); txtDrillDate.Text = dt.Rows[0]["DRILL_DATE"].ToString(); txtDrillType.Text = dt.Rows[0]["DRILLTYPE"].ToString(); txtImproSugg.Text = dt.Rows[0]["IMPROVEMENTSSUGGESTED"].ToString(); //Bind the Photos rptDrillImages.DataSource = dt; rptDrillImages.DataBind(); string FileName = dt.Rows[0]["PhotoUrl"].ToString(); string FilePath = "../../Uploads/SCM/" + Path.GetFileName(dt.Rows[0]["PhotoUrl"].ToString()); if (System.IO.File.Exists(Server.MapPath(FilePath)) == true) { Random r = new Random(); string ver = r.Next().ToString(); frmContract.Attributes.Add("src", FilePath + "?ver=" + ver); } } }
public void FillDDLYear() { try { DataTable dtyears = BLL_SCM_Report.GetVesselIssuesYears(); int minyear = int.MaxValue; int maxyear = int.MinValue; if (dtyears.Rows.Count > 0) { foreach (DataRow dr in dtyears.Rows) { int year = dr.Field <int>("ISSUE_CREATED_YEAR"); minyear = Math.Min(minyear, year); maxyear = Math.Max(maxyear, year); } Session["maxYear"] = maxyear.ToString(); } ddlYear.Items.Clear(); ddlYear.DataSource = dtyears; ddlYear.DataTextField = "ISSUE_CREATED_YEAR"; ddlYear.DataValueField = "ISSUE_CREATED_YEAR"; ddlYear.DataBind(); ListItem li = new ListItem("--SELECT ALL--", "0"); ddlYear.Items.Insert(0, li); } catch (Exception ex) { } }
protected void btnExport_Click(object sender, ImageClickEventArgs e) { int rowcount = ucCustomPagerItems.isCountRecord; string vesselcode = (ViewState["VesselCode"] == null) ? null : (ViewState["VesselCode"].ToString()); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataSet ds = BLL_SCM_Report.SCMReportMainSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(vesselcode) , UDFLib.ConvertDateToNull(txtFromDate.Text), UDFLib.ConvertDateToNull(txtToDate.Text), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, null, ref rowcount); string[] HeaderCaptions = { "Vessel", "Meeting Date", "Present Position", "Verified" }; string[] DataColumnsName = { "Vessel_Name", "MEETING_DATE_S", "PRESENT_POSITION", "IsVerified" }; ds.Tables[0].Columns.Add("MEETING_DATE_S"); foreach (DataRow item in ds.Tables[0].Rows) { item["MEETING_DATE_S"] = UDFLib.ConvertDateToNull(item["MEETING_DATE"]).Value.ToString("dd/MMM/yyyy"); } GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "SCM", "Safety Committee Meetings", HtmlFilterTable()); }
protected void divReleasebtnOk_Click(object sender, EventArgs e) { int rowscount = gvRelease.Rows.Count; for (int i = 0; i < rowscount; i++) { CheckBox chk = (CheckBox)gvRelease.Rows[i].FindControl("chkRelease"); Label lblmonth = (Label)gvRelease.Rows[i].FindControl("lblMonthNumber"); Label lblyear = (Label)gvRelease.Rows[i].FindControl("lblReleaseYear"); if (chk.Checked) { BLL_SCM_Report.SCMReportRealeaseResponseToShip(Convert.ToInt32(Session["userid"].ToString()), Convert.ToInt32(lblyear.Text), Convert.ToInt32(lblmonth.Text)); } } string msgDivReleaseHide = string.Format("hideModal('divRelease');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDivReleaseHide", msgDivReleaseHide, true); BindSCMResponseSearch(); UpdPnlFilter.Update(); UpdPnlGrid.Update(); }
protected void btnUnMarkSMSReview_Click(object sender, EventArgs e) { int rowscount = gvIssueAssign.Rows.Count; int?responseid = null; int?smsreviewflag = null; for (int i = 0; i < rowscount; i++) { CheckBox chk = (CheckBox)gvIssueAssign.Rows[i].FindControl("ChkSMSReview"); Label lblResponse = (Label)gvIssueAssign.Rows[i].FindControl("lblResponseID"); if (chk.Checked) { if (lblResponse.Text != "") { responseid = Convert.ToInt32(lblResponse.Text); smsreviewflag = 1; BLL_SCM_Report.SCMReportSMSReviewFlagUpdate(responseid, smsreviewflag); } } else { if (lblResponse.Text != "") { responseid = Convert.ToInt32(lblResponse.Text); smsreviewflag = null; BLL_SCM_Report.SCMReportSMSReviewFlagUpdate(responseid, smsreviewflag); } } } }
public void BindSCMOfficeRespresentativeSearch() { DataSet ds = BLL_SCM_Report.SCMOfficeRepresentativeSearch(null, null, null, null); if (ds.Tables[0].Rows.Count > 0) { gvOffRespresentative.DataSource = ds.Tables[0]; gvOffRespresentative.DataBind(); } }
public void BindSCMReport() { int rowcount = ucCustomPagerItems.isCountRecord; string vesselcode = (ViewState["VesselCode"] == null) ? null : (ViewState["VesselCode"].ToString()); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataSet ds = BLL_SCM_Report.SCMReportMainSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(vesselcode) , UDFLib.ConvertDateToNull(txtFromDate.Text), UDFLib.ConvertDateToNull(txtToDate.Text), 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) { gvSCMReport.DataSource = ds.Tables[0]; gvSCMReport.DataBind(); if (ViewState["ID"] == null) { ViewState["ID"] = ds.Tables[0].Rows[0]["ID"].ToString(); gvSCMReport.SelectedIndex = 0; } SetRowSelection(); } else { gvSCMReport.DataSource = ds.Tables[0]; gvSCMReport.DataBind(); } if (ds.Tables[0].Rows.Count == 0) { btnExport.Visible = false; } else { btnExport.Visible = true; } }
protected void divResponsebtnResponse_Click(object sender, EventArgs e) { BLL_SCM_Report.SCMReportOfficeResponseSave(Convert.ToInt32(Session["userid"].ToString()), Convert.ToInt32(ViewState["ResponseID"].ToString()), divResponsetxtOfficeResponse.Text); string msgDivResponseHide = string.Format("hideModal('divResponse');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDivResponseHide", msgDivResponseHide, true); BindSCMResponseSearch(); UpdPnlFilter.Update(); UpdPnlGrid.Update(); }
protected void btnExport_Click(object sender, ImageClickEventArgs e) { DataSet ds = BLL_SCM_Report.SCMReportDetailsSearch(Convert.ToInt32(Request.QueryString["SCMID"]), TabSCM.ActiveTab.TabIndex, Convert.ToInt32(Request.QueryString["VesselID"])); string[] HeaderCaptions = { "Staff Code", "Staff Name", "Staff Rank", "Sigature" }; string[] DataColumnsName = { "STAFF_CODE", "Staff_Name", "Rank_Short_Name", "Sigature" }; ds.Tables[0].Columns.Add("Sigature"); foreach (DataRow item in ds.Tables[0].Rows) { item["Sigature"] = ""; } GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "SCM", "Safety Committee Meeting Attendance"); }
public void IssueAssignToDepartment(string deptid, string tabname, string strresponseid, string tabpkid, string vesselid, string link) { int?responseid = null; if (strresponseid != "") { responseid = Convert.ToInt32(strresponseid); } int retval = BLL_SCM_Report.SCMReportOfficeIssueAssigned(Convert.ToInt32(Session["userid"].ToString()) , Convert.ToInt32(deptid), tabname , responseid, Convert.ToInt32(tabpkid) , Convert.ToInt32(vesselid), Convert.ToInt32(link)); }
protected void BindSCMList() { DataSet ds = BLL_SCM_Report.SCMReportList(Convert.ToInt32(Request.QueryString["SCMID"]), Convert.ToInt32(Request.QueryString["VesselID"])); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; txtVessel.Text = dr["Vessel_Name"].ToString(); txtVesselPosition.Text = dr["PRESENT_POSITION"].ToString(); txtMeetingDate.Text = Request.QueryString["MeetingDate"].ToString(); ViewState["Fleet_ID"] = dr["FleetCode"].ToString(); ViewState["Vessel_ID"] = dr["Vessel_ID"].ToString(); } }
public void FillDDLYear() { try { DataTable dtyears = BLL_SCM_Report.GetVesselIssuesYears(); ddlYear.Items.Clear(); ddlYear.DataSource = dtyears; ddlYear.DataTextField = "ISSUE_CREATED_YEAR"; ddlYear.DataValueField = "ISSUE_CREATED_YEAR"; ddlYear.DataBind(); ListItem li = new ListItem("--SELECT ALL--", "0"); ddlYear.Items.Insert(0, li); } catch (Exception ex) { } }
public void BindDrillTypeDDL() { try { DataTable dt = BLL_SCM_Report.SCMGetDrillTYPE(); DDLDrillType.Items.Clear(); DDLDrillType.DataSource = dt; DDLDrillType.DataTextField = "DRILL_NAME"; DDLDrillType.DataValueField = "ID"; DDLDrillType.DataBind(); ListItem li = new ListItem("--SELECT ALL--", "0"); DDLDrillType.Items.Insert(0, li); } catch (Exception ex) { } }
protected void btnExport_Click(object sender, ImageClickEventArgs e) { int rowcount = ucCustomPagerItems.isCountRecord; string vesselcode = (ViewState["VesselCode"] == null) ? null : (ViewState["VesselCode"].ToString()); int?deptcode = null; if (DDLOfficeDept.SelectedValue != "0") { deptcode = Int32.Parse(DDLOfficeDept.SelectedValue); } int?year = null; if (ddlYear.SelectedValue != "0") { year = Int32.Parse(ddlYear.SelectedValue.ToString()); } int?month = null; if (ddlMonth.SelectedValue != "0") { month = Int32.Parse(ddlMonth.SelectedValue.ToString()); } int?assigndeptstatus = null; if (optAssignDept.SelectedValue != "2") { assigndeptstatus = Int32.Parse(optAssignDept.SelectedValue); } int?smsnextreview = null; if (optSMSReview.SelectedValue != "2") { smsnextreview = Int32.Parse(optSMSReview.SelectedValue); } string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataSet ds = BLL_SCM_Report.SCMReportIssueAssignmentSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(vesselcode) , null, deptcode, year, month, txtSearchBy.Text.Trim(), assigndeptstatus, smsnextreview , sortbycoloumn, sortdirection, null, null, ref rowcount); string[] HeaderCaptions = { "Vessel", "Month", "Year", "Assign Dept.", "SCM Tab", "Vessel Issue", "Created By", "SMS Review" }; string[] DataColumnsName = { "Vessel_Name", "Month", "Year", "Department", "TAB_NAME", "VESSEL_ISSUE", "Issue_Created_By", "SMS_NEXT_REVIEW" }; GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "Vessel Issue Assignment", "Vessel Issue Assignment", HtmlFilterTable()); }
protected void btnRqstUptResponse_Click(object sender, EventArgs e) { BLL_Crew_CrewDetails objBLLCrew = new BLL_Crew_CrewDetails(); BLL_Infra_UserCredentials ojbInfra = new BLL_Infra_UserCredentials(); string sToEmailAddress = "", strEmailAddCc = "", strFormatSubject = "Update response"; DataTable dtEmailAdd = BLL_SCM_Report.SCMReportGetEmailAddToSendMailForResponse(Convert.ToInt32(ddlYear.SelectedValue), Convert.ToInt32(ddlMonth.SelectedValue)); foreach (DataRow dr in dtEmailAdd.Rows) { sToEmailAddress += dr["EMAIL_ADD"].ToString() + ";"; } if (dtEmailAdd.Rows.Count > 0) { DataTable dtRequesterDetails = ojbInfra.Get_UserDetails(Convert.ToInt32(Session["userid"].ToString())); StringBuilder sbEmailbody = new StringBuilder(); string path = System.Configuration.ConfigurationManager.AppSettings["APP_URL"].ToString() + "/QMS/SCM/SCM_Response.aspx"; //string path = "http://seachange.dyndns.info/smslog/QMS/SCM/SCM_Response.aspx"; sbEmailbody.Append("Dear All,"); sbEmailbody.AppendLine("<br><br>"); sbEmailbody.AppendLine("Please click on below link to update the response."); sbEmailbody.Append("<a href=" + path + ">" + path + "</a>"); sbEmailbody.AppendLine("<br><br>"); sbEmailbody.AppendLine("<br>"); sbEmailbody.AppendLine("<br>"); sbEmailbody.AppendLine("Best Regards,"); sbEmailbody.AppendLine("<br>"); sbEmailbody.AppendLine(dtRequesterDetails.Rows[0]["User_name"].ToString().ToUpper() + " " + dtRequesterDetails.Rows[0]["Last_Name"].ToString().ToUpper()); sbEmailbody.AppendLine("<br>"); sbEmailbody.AppendLine(dtRequesterDetails.Rows[0]["Designation"].ToString()); sbEmailbody.AppendLine(Convert.ToString(Session["Company_Address_GL"])); sbEmailbody.AppendLine("<br>"); int MailID = objBLLCrew.Send_CrewNotification(0, 0, 0, 0, sToEmailAddress, strEmailAddCc, "", strFormatSubject, sbEmailbody.ToString(), "", "MAIL", "", UDFLib.ConvertToInteger(Session["USERID"].ToString()), "DRAFT"); string URL = String.Format("window.open('/" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + "/crew/EmailEditor.aspx?ID=+" + MailID.ToString() + "');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "k" + MailID.ToString(), URL, true); } }
protected void btnRelease_Click(object sender, EventArgs e) { DataTable dtGetResponseRelease = BLL_SCM_Report.GetSCMReportResponseRelease(); if (dtGetResponseRelease.Rows.Count > 0) { gvRelease.DataSource = dtGetResponseRelease; gvRelease.DataBind(); string msgdiv = string.Format("showModal('divRelease');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgdiv", msgdiv, true); UpdatePnlSCMRelease.Update(); } else { string js = "alert('There is no response to be released!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser", js, true); } }
public void FillDivDDLOfficeDept() { int?companyid = null; if ((Session["USERCOMPANYID"].ToString() != "") || (Session["USERCOMPANYID"] == null)) { companyid = Convert.ToInt32(Session["USERCOMPANYID"].ToString()); } DataTable dtOfficeDept = BLL_SCM_Report.SCMGetOfficeDepartment(companyid); DivResponseDDLDeptpartment.Items.Clear(); DivResponseDDLDeptpartment.DataSource = dtOfficeDept; DivResponseDDLDeptpartment.DataTextField = "VALUE"; DivResponseDDLDeptpartment.DataValueField = "ID"; DivResponseDDLDeptpartment.DataBind(); ListItem lid = new ListItem("--SELECT ALL--", "0"); DivResponseDDLDeptpartment.Items.Insert(0, lid); }
protected void BindGrid() { DateTime?iniDate = null; if (txtToDate.Text != "") { iniDate = Convert.ToDateTime(txtToDate.Text); } DateTime?tempdate = null; if (txtToDate.Text != "") { tempdate = UDFLib.ConvertDateToNull(txtToDate.Text).Value.AddMonths(1); } DataSet ds = BLL_SCM_Report.Get_Absentees_Report(tempdate, UDFLib.ConvertIntegerToNull(DDLVessel.SelectedValue), UDFLib.ConvertIntegerToNull(DDLVessel.Text)); if (ds.Tables[0].Rows.Count > 0) { txtToDate.Text = UDFLib.ConvertDateToNull(ds.Tables[0].Rows[0]["Meet_date"]).Value.ToString("dd/MM/yyyy"); gvAbsentees.DataSource = ds.Tables[0]; gvAbsentees.DataBind(); } else { ds.Tables[0].Clear(); gvAbsentees.DataSource = ds.Tables[0]; gvAbsentees.DataBind(); } if (iniDate != null) { if (Convert.ToDateTime(txtToDate.Text).Month != iniDate.Value.Month) { txtToDate.Text = iniDate.Value.ToString("dd/MM/yyyy"); ds.Tables[0].Clear(); gvAbsentees.DataSource = ds.Tables[0]; gvAbsentees.DataBind(); } } }
protected void divResponsebtnModifyDept_Click(object sender, EventArgs e) { int?deptid = null; if (DivResponseDDLDeptpartment.SelectedValue != "0") { deptid = Convert.ToInt32(DivResponseDDLDeptpartment.SelectedValue.ToString()); } BLL_SCM_Report.SCMReportOfficeDepartmentUpdate(Convert.ToInt32(Session["userid"].ToString()), Convert.ToInt32(ViewState["ResponseID"].ToString()), deptid); string msgDivResponseHide = string.Format("hideModal('divResponse');"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDivResponseHide", msgDivResponseHide, true); BindSCMResponseSearch(); UpdPnlFilter.Update(); UpdPnlGrid.Update(); }
protected void btnVerify_Click(object sender, EventArgs e) { string js; try { if (txtMessage.Text.Trim().Length == 0) { js = "alert('Verification comment is mandatory!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "js", js, true); return; } int SCMID = Convert.ToInt32(Request.QueryString["SCMID"]); int VESSEL_ID = Convert.ToInt32(Request.QueryString["VesselID"]); int VerifiedBy = int.Parse(Session["USERID"].ToString()); BLL_SCM_Report.ScmVerifyReport(SCMID, txtMessage.Text, VESSEL_ID, VerifiedBy); //btnVerify.Enabled = false; txtMessage.ReadOnly = true; btnVerify.Visible = false; lblVerificationDate.Visible = true; lblVerificationDateH.Visible = true; lblVerifiedBy.Visible = true; lblVerifiedByH.Visible = true; lblVerifiedBy.Text = Session["USERFULLNAME"].ToString(); lblVerificationDate.Text = DateTime.Now.ToString("dd/MMM/yyyy"); //LoadFollowUps(iJob_OfficeID, VESSEL_ID, Worklist_ID); } catch (Exception ex) { js = "alert('Error in saving data!! Error: " + ex.Message + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "errorsaving", js, true); } }
private void OfficeRepresentativeSave(string deptid, string emailAddress) { BLL_SCM_Report.SCMOfficeRepresentativeSave(Convert.ToInt32(deptid), emailAddress); }
private void OfficeRepresentativeDelete(string deptid, string scmrespid) { BLL_SCM_Report.SCMOfficeRepresentativeDelete(Convert.ToInt32(deptid), UDFLib.ConvertIntegerToNull(scmrespid)); }
public void BindVesselsDrillReport() { DataTable dt = new DataTable(); string sortby = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } dt = BLL_SCM_Report.SCMGetVesselDrillReports(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(DDLVessel.SelectedValue), null, null, UDFLib.ConvertIntegerToNull(DDLDrillType.SelectedValue)); if (dt.Rows.Count > 0) { DataTable dtpb = UDFLib.PivotTable("DRILL_NAME", "DRILL_DATE", "Sort_order", new string[] { "VESSEL_ID" }, new string[] { "VESSEL_ID", "ID", "Sort_order" }, dt); dtpb.DefaultView.Sort = "Vessel"; gvVesselsDrill.DataSource = dtpb; gvVesselsDrill.DataBind(); int[] freq = new int[10]; GridViewRow RowHeader = gvVesselsDrill.HeaderRow; int j = 2; foreach (TableCell cell in RowHeader.Cells) { //string[] hrow = (cell.Controls[0] as LinkButton).Text.Split('~'); string[] hrow = cell.Text.Split('~'); if (hrow.Length > 1) { cell.Text = hrow[0] + "<br>" + hrow[1]; freq[j] = int.Parse(hrow[1].Split(' ')[0]); j++; } } foreach (GridViewRow gr in gvVesselsDrill.Rows) { j = 0; foreach (TableCell cell in gr.Cells) { if (cell.Text == "Not Applicable") { cell.ForeColor = System.Drawing.Color.Blue; } if (j > 1 && cell.Text != "Not Applicable" && cell.Text.Trim() != "") { if (Convert.ToDateTime(cell.Text).AddDays(freq[j]).CompareTo(DateTime.Now) < 1) { cell.BackColor = System.Drawing.Color.Tomato; cell.ForeColor = System.Drawing.Color.White; } } j++; } } } else { gvVesselsDrill.DataSource = dt; gvVesselsDrill.DataBind(); } }
protected void BindSCMTabs() { int p = 1; if (TabSCM.ActiveTab.TabIndex != 10) { DataSet ds = BLL_SCM_Report.SCMReportDetailsSearch(Convert.ToInt32(Request.QueryString["SCMID"]), TabSCM.ActiveTab.TabIndex, Convert.ToInt32(Request.QueryString["VesselID"])); if (ds.Tables[ds.Tables.Count - 1].Rows[0]["VerificationComment"].ToString().Length > 0) { txtMessage.Text = ds.Tables[ds.Tables.Count - 1].Rows[0]["VerificationComment"].ToString(); txtMessage.ReadOnly = true; btnVerify.Visible = false; lblVerifiedBy.Text = ds.Tables[ds.Tables.Count - 1].Rows[0]["VerifiedByName"].ToString();; lblVerificationDate.Text = Convert.ToDateTime(ds.Tables[ds.Tables.Count - 1].Rows[0]["VerificationDate"].ToString()).ToString("dd/MMM/yyyy"); lblVerificationDate.Visible = true; lblVerificationDateH.Visible = true; lblVerifiedBy.Visible = true; lblVerifiedByH.Visible = true; txtMessage.Visible = true; lblComment.Visible = true; } else { if (objUA.Approve != 0) { txtMessage.Text = ""; btnVerify.Visible = true; txtMessage.Visible = true; lblVerificationDate.Visible = false; lblVerificationDateH.Visible = false; lblVerifiedBy.Visible = false; lblVerifiedByH.Visible = false; } } switch (TabSCM.ActiveTab.TabIndex) { case 0: gvInjd.DataSource = ds.Tables[0]; gvInjd.DataBind(); gvInjdLst.DataSource = ds.Tables[1]; gvInjdLst.DataBind(); break; case 1: gvEmdrl.DataSource = ds.Tables[0]; gvEmdrl.DataBind(); gvEmdrlntdone.DataSource = ds.Tables[1]; gvEmdrlntdone.DataBind(); break; case 2: gvSfvs.DataSource = ds.Tables[0]; gvSfvs.DataBind(); break; case 3: gvSwpt.DataSource = ds.Tables[0]; gvSwpt.DataBind(); break; case 4: gvOrtg.DataSource = ds.Tables[0]; gvOrtg.DataBind(); break; case 5: break; case 6: gvMetm.DataSource = ds.Tables[0]; gvMetm.DataBind(); break; case 7: gvAbsn.DataSource = ds.Tables[0]; gvAbsn.DataBind(); break; case 8: gvCncd.DataSource = ds.Tables[0]; gvCncd.DataBind(); break; case 9: gvAttachments.DataSource = ds.Tables[0]; gvAttachments.DataBind(); break; case 12: gvEnvironmental.DataSource = ds.Tables[0]; gvEnvironmental.DataBind(); dlEnvironmentalAttachments.DataSource = ds.Tables[1]; dlEnvironmentalAttachments.DataBind(); break; case 13: gvHealthNutritionHygiene.DataSource = ds.Tables[0]; gvHealthNutritionHygiene.DataBind(); dtHealthAttachments.DataSource = ds.Tables[1]; dtHealthAttachments.DataBind(); break; default: break; } } }
public void BindSCMIssueAssignmentSearch() { int rowcount = ucCustomPagerItems.isCountRecord; string vesselcode = (ViewState["VesselCode"] == null) ? null : (ViewState["VesselCode"].ToString()); int?deptcode = null; if (DDLOfficeDept.SelectedValue != "0") { deptcode = Int32.Parse(DDLOfficeDept.SelectedValue); } int?year = null; if (ddlYear.SelectedValue != "0") { year = Int32.Parse(ddlYear.SelectedValue.ToString()); } int?month = null; if (ddlMonth.SelectedValue != "0") { month = Int32.Parse(ddlMonth.SelectedValue.ToString()); } int?assigndeptstatus = null; if (optAssignDept.SelectedValue != "2") { assigndeptstatus = Int32.Parse(optAssignDept.SelectedValue); } int?smsnextreview = null; if (optSMSReview.SelectedValue != "2") { smsnextreview = Int32.Parse(optSMSReview.SelectedValue); } string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataSet ds = BLL_SCM_Report.SCMReportIssueAssignmentSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(vesselcode) , null, deptcode, year, month, txtSearchBy.Text.Trim(), assigndeptstatus, smsnextreview , 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) { gvIssueAssign.DataSource = ds.Tables[0]; gvIssueAssign.DataBind(); if (ViewState["ID"] == null) { ViewState["ID"] = ds.Tables[0].Rows[0]["ResponseID"].ToString(); //gvIssueAssign.SelectedIndex = 0; } // SetRowSelection(); } else { gvIssueAssign.DataSource = ds.Tables[0]; gvIssueAssign.DataBind(); } }