private void Load_LashingGearInventoryReport_Details(int Main_Report_ID, int Vessel_ID) { try { DataSet ds = BLL_LGInventoryReport.Get_LGI_REPORT_Log(Main_Report_ID, Vessel_ID); if (ds.Tables[1].Rows.Count > 0) { lblReportDate.Text = ds.Tables[1].Rows[0]["RptDate"].ToString(); lblVesselName.Text = ds.Tables[1].Rows[0]["Vessel_Name"].ToString(); txtremarks.Text = ds.Tables[1].Rows[0]["Remarks"].ToString(); lblMasterSignature.Text = ds.Tables[1].Rows[0]["MasterName"].ToString(); //lblmasterDate.Text = ds.Tables[1].Rows[0]["CrewMsDate"].ToString(); lblchiefofficer.Text = ds.Tables[1].Rows[0]["COName"].ToString(); //lblchiefofficerdate.Text = ds.Tables[1].Rows[0]["CrewCoDate"].ToString(); } GridView_LashingInventoryRPT.DataSource = ds.Tables[0]; GridView_LashingInventoryRPT.DataBind(); objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5 }, "Units Received", "HeaderStyle-css"); objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7 }, "Operational Losses or Condemned", "HeaderStyle-css"); //UserAccessValidation(); } catch { } }
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); } }
protected void Page_Load(object sender, EventArgs e) { TechnicalBAL objtechBAL = new TechnicalBAL(); dtQTNReceived = objtechBAL.GetToopTipsForQtnRecve(); dtQTNSent = objtechBAL.GetToopTipsForQtnSent(); if (!IsPostBack) { BindFleetDLL(); DDLFleet.SelectedValue = Session["USERFLEETID"].ToString(); BindVesselDDL(); BindDeptTypeOpt(); BindDepartmentByST_SP(); //BindPendingStatas(); rgdReqAllStage.Attributes.Add("bordercolor", "#D8D8D8"); txtSearchJoinFromDate.Text = (DateTime.Now.AddDays(-(DateTime.Now.DayOfYear) + 1)).ToString("dd-MM-yyyy"); txtSearchJoinToDate.Text = (DateTime.Now.AddMonths(1).AddDays(-(DateTime.Now.Day))).ToString("dd-MM-yyyy"); BindSearchRequistionstages(); //txtSearchJoinFromDate.Text.Trim() == "" ? "1900/01/01" : txtSearchJoinFromDate.Text.Trim(), //txtSearchJoinToDate.Text.Trim() == "" ? "2099/01/01" : txtSearchJoinToDate.Text.Trim(), } objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "Requisition", "HeaderStyle-css"); objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8 }, "Quotation", "HeaderStyle-css"); objChangeReqstMerge.AddMergedColumns(new int[] { 9, 10, 11, 12 }, "Purchase Order", "HeaderStyle-css"); objChangeReqstMerge.AddMergedColumns(new int[] { 13, 14, 15 }, "Delivery", "HeaderStyle-css"); }
protected void Page_Load(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "myFunction();", true); UserAccessValidation(); //UserAccessTypeValidation(); objContractList.AddMergedColumns(new int[] { 10, 11 }, "Evaluation", "HeaderStyle-center"); objContractList.AddMergedColumns(new int[] { 12, 13, 14 }, "Supplier", "HeaderStyle-center"); objContractList.AddMergedColumns(new int[] { 15, 16 }, "Change", "HeaderStyle-center"); objContractList.AddMergedColumns(new int[] { 17, 18, 19, 20, 21, 22 }, "Invoice/PO", "HeaderStyle-center"); this.Form.DefaultButton = this.btnGet.UniqueID; if (!IsPostBack) { if (Request.QueryString["Supplier_Code"] != null) { txtfilter.Text = Request.QueryString["Supplier_Code"].ToString(); } else { txtfilter.Text = ""; } chkApproved.Checked = true; chkBlack.Checked = true; chkCond.Checked = true; chkexp.Checked = true; chkUnreg.Checked = true; BindType(); BindPort(); BindScope(); BindEvaluationStatus(); BindEvaluationGrid(); BindChangeRequestGrid(); BindGrid(); } }
protected void Page_Load(object sender, EventArgs e) { try { UserAccessValidation(); if (!IsPostBack) { BindFleetDLL(); DDLFleet.SelectedValue = Session["USERFLEETID"].ToString(); BindVesselDDL(); ViewState["System_ID"] = null; ViewState["IsNewFlage"] = null; ViewState["SORTDIRECTION"] = null; ViewState["SORTBYCOLOUMN"] = null; ViewState["Status"] = null; optStatus.SelectedValue = "P"; BindMachineryChageRequests(); } objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5 }, "ORIGINAL", "HeaderStyle-css"); objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7, 8, 9 }, "CHANGE REQUEST", "HeaderStyle-css"); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
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(); } }
public void BindGridView() { try { objChangeReqstMerge.AddMergedColumns(new int[] { 0, 1, 2, 3, 4, 5 }, "PO", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7, 8, 9, 10, 11, 12 }, "Invoice", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 13, 14, 15 }, "Payment", "HeaderStyle-center"); ViewState["SupplyID"] = ""; ChkStatus(); 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 = new DataSet(); if (POStatus != null || UnpaidInvoiceStatus != null || InvoiceStatus != null) { ds = BLL_POLOG_Register.POLOG_Get_Invoice_Summary_Report(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), POStatus, UnpaidInvoiceStatus, InvoiceStatus, txtFromDate.Text != "" ? Convert.ToDateTime(txtFromDate.Text) : Convert.ToDateTime("01/01/1900") , txtToDate.Text != "" ? Convert.ToDateTime(txtToDate.Text) : Convert.ToDateTime("01/01/1900"), txtFromPayment.Text != "" ? Convert.ToDateTime(txtFromPayment.Text) : Convert.ToDateTime("01/01/1900"), txtToPayment.Text != "" ? Convert.ToDateTime(txtToPayment.Text) : Convert.ToDateTime("01/01/1900"), UDFLib.ConvertIntegerToNull(GetSessionUserID()), 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) { divPurchase.Visible = true; gvPurchase.DataSource = ds.Tables[0]; gvPurchase.DataBind(); Label lblPOUSDAmount1 = (Label)gvPurchase.FooterRow.FindControl("lblPOUSDAmount1"); Label lblInvBookValue1 = (Label)gvPurchase.FooterRow.FindControl("lblInvBookValue1"); lblPOUSDAmount1.Text = ds.Tables[1].Rows[0]["PO_USD_Value"].ToString(); lblInvBookValue1.Text = ds.Tables[2].Rows[0]["Invoice_USD_Amount"].ToString(); } else { divPurchase.Visible = false; gvPurchase.DataSource = ds.Tables[0]; gvPurchase.DataBind(); gvPurchase.EmptyDataText = "NO RECORDS FOUND"; } } catch { } { } }
protected void BindGrid() { try { objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Verified", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 16, 17 }, "Approved", "HeaderStyle-center"); int rowcount = ucCustomPagerItems.isCountRecord; DataTable dtType = ChkType(); string urgent = null; if (chkUrgent.Checked == true) { urgent = "YES"; } string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } ChkStatus(); //string ReqsnStatus = hdfSelectedStageValue.Value; DataSet ds = BLL_POLOG_Register.POLOG_Get_Pending_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), CurrStatus, urgent, dtType, UDFLib.ConvertIntegerToNull(GetSessionUserID()), 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) { //btnApprove.Visible = true; gvPendinginvoice.DataSource = ds.Tables[0]; gvPendinginvoice.DataBind(); } else { // btnApprove.Visible = false; gvPendinginvoice.DataSource = ds.Tables[0]; gvPendinginvoice.DataBind(); gvPendinginvoice.EmptyDataText = "NO RECORDS FOUND"; } } catch { } { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Form_ID = UDFLib.ConvertToInteger(Request.QueryString["Form_ID"]); Dtl_Report_ID = UDFLib.ConvertToInteger(Request.QueryString["DtlID"]); Vessel_ID = UDFLib.ConvertToInteger(Request.QueryString["VID"]); objMergeList.AddMergedColumns(new int[] { 5, 6 }, "Fuel Pump", "HeaderStyle-css-2"); objMergeList.AddMergedColumns(new int[] { 10, 11, 12, 13 }, "Running Hours Since", "HeaderStyle-css-2"); Load_ME_Perf_Report_Details(Dtl_Report_ID, Vessel_ID); } }
protected void Page_Load(object sender, EventArgs e) { UserAccessValidation(); objContractList.AddMergedColumns(new int[] { 4, 5, 6 }, "Company Seniority", "HeaderStyle-css HeaderStyle-css-center"); objContractList.AddMergedColumns(new int[] { 7, 8, 9, 10 }, "Rank Seniority", "HeaderStyle-css HeaderStyle-css-center"); if (!IsPostBack) { ucCustomPager.PageSize = 20; Load_RankList(); Load_SeniorityRecords(); } //string msg1 = String.Format("$('.sailingInfo').SailingInfo();"); //ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgshowdetails", msg1, true); }
protected void Page_Load(object sender, EventArgs e) { UserAccessValidation(); if (!string.IsNullOrEmpty(Request.QueryString["Vessel_ID"])) { DataSet dsCapt = BLL_PB_PortageBill.ReportDetailsByID(Request.QueryString["ID"], Request.QueryString["Vessel_ID"]); if (dsCapt.Tables[0].Rows.Count > 0) { lblVessel.Text = dsCapt.Tables[0].Rows[0]["Vessel_Name"].ToString(); if (!string.IsNullOrEmpty(dsCapt.Tables[0].Rows[0]["from_date"].ToString())) { lblFrom.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dsCapt.Tables[0].Rows[0]["from_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat()); } if (!string.IsNullOrEmpty(dsCapt.Tables[0].Rows[0]["To_date"].ToString())) { lblTo.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dsCapt.Tables[0].Rows[0]["To_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat()); } lblOpnBL.Text = dsCapt.Tables[0].Rows[0]["Opening_Bal"].ToString(); lblClosing.Text = dsCapt.Tables[0].Rows[0]["Closing_Bal"].ToString(); objItemColumn.AddMergedColumns(new int[] { 5, 6 }, "Amount", "HeaderStyle-css"); gvCastCash.DataSource = dsCapt.Tables[0]; gvCastCash.DataBind(); (gvCastCash.FooterRow.FindControl("lblRcvdTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Recp_Amount"].ToString(); (gvCastCash.FooterRow.FindControl("lblPaidTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Payment_Amount"].ToString(); } } }
protected void BindInvoiceCount() { 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 = BLL_POLOG_Invoice.POLOG_Get_Rework_Invoice(Convert.ToInt16(ddlUserName.SelectedValue), sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); // objChangeReqstMerge.AddMergedColumns(new int[] { 3, 4 }, "PO", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5, 6, 7, 8, 9 }, "Invoice", "HeaderStyle-center"); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { gvInvoice.DataSource = ds.Tables[0]; gvInvoice.DataBind(); } if (ds.Tables[1].Rows.Count > 0) { gvInvoiceCount.DataSource = ds.Tables[1]; gvInvoiceCount.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { // UserAccessValidation(); if (!string.IsNullOrEmpty(Request.QueryString["Vessel_ID"])) { DataTable dtWelfareDetails = BLL_PB_PortageBill.Get_Crew_Welfare_Details(UDFLib.ConvertToInteger(Request.QueryString["Welfare_ID"]), Convert.ToInt32(Request.QueryString["Vessel_ID"]), UDFLib.ConvertDateToNull(Request.QueryString["PB_Date"])); if (dtWelfareDetails.Rows.Count > 0) { lblVessel.Text = dtWelfareDetails.Rows[0]["Vessel_Name"].ToString(); if (!string.IsNullOrEmpty(dtWelfareDetails.Rows[0]["from_date"].ToString())) { lblFrom.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dtWelfareDetails.Rows[0]["from_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat()); } if (!string.IsNullOrEmpty(dtWelfareDetails.Rows[0]["To_date"].ToString())) { lblTo.Text = UDFLib.ConvertUserDateFormat(Convert.ToDateTime(dtWelfareDetails.Rows[0]["To_date"].ToString()).ToString("dd/MM/yyyy"), UDFLib.GetDateFormat()); } lblOpnBL.Text = dtWelfareDetails.Rows[0]["Opening_Bal"].ToString(); lblClosing.Text = dtWelfareDetails.Rows[0]["Closing_Bal"].ToString(); objItemColumn.AddMergedColumns(new int[] { 5, 6 }, "Amount", "HeaderStyle-css"); gvWelfareDetails.DataSource = dtWelfareDetails; gvWelfareDetails.DataBind(); (gvWelfareDetails.FooterRow.FindControl("lblRcvdTotal") as Label).Text = dtWelfareDetails.Rows[0]["Total_Recp_Amount"].ToString(); (gvWelfareDetails.FooterRow.FindControl("lblPaidTotal") as Label).Text = dtWelfareDetails.Rows[0]["Total_Payment_Amount"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { UserAccessValidation(); if (!IsPostBack) { ViewState["SORTDIRECTION"] = null; ViewState["SORTBYCOLOUMN"] = null; ucCustomPagerItems.PageSize = 20; Load_ApprovalGroup(); Load_UserList(); Load_ApprovalType(); BindUserApproval(); } objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3 }, "Approvel Limit", "HeaderStyle-css"); objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5, 6, 7 }, "Approver Type", "HeaderStyle-css"); }
protected void BindOnlineInvoice() { try { objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5, 6, 7 }, "PO Details", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 9, 10, 11, 12, 13, 14 }, "Online Invoice", "HeaderStyle-center"); int rowcount = ucCustomPager1.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 = BLL_POLOG_Invoice.POLOG_Get_PedingOnline_Invoice(txtfilter.Text.Trim() != "" ? txtfilter.Text.Trim() : null, GetSessionUserID(), sortbycoloumn, sortdirection , ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount); if (ucCustomPager1.isCountRecord == 1) { ucCustomPager1.CountTotalRec = rowcount.ToString(); ucCustomPager1.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { gvOnlineInvoice.DataSource = ds.Tables[0]; gvOnlineInvoice.DataBind(); } else { gvOnlineInvoice.DataSource = null; gvOnlineInvoice.DataBind(); gvExistingInvoices.DataSource = null; gvExistingInvoices.DataBind(); gvDuplieCateinvoice.DataSource = null; gvDuplieCateinvoice.DataBind(); } } catch { } { } }
protected void Page_Load(object sender, EventArgs e) { objVicRate.AddMergedColumns(new int[] { 0, 1, 2, 3 }, "Dry", "HeaderStyle-css HeaderStyle-css-center"); objVicRate.AddMergedColumns(new int[] { 4, 5, 6, 7 }, "Fresh", "HeaderStyle-css HeaderStyle-css-center"); DataSet dsProv = BLL_PURC_Provision.Get_Calculate_Victualling_Rate(Convert.ToInt32(Request.QueryString["VESSEL_ID"]), Request.QueryString["REQSN_CODE"].ToString(), UDFLib.ConvertStringToNull(Request.QueryString["ORDER_CODE"]), Convert.ToInt32(Session["USERID"])); gvVictuallingRate.DataSource = dsProv.Tables["VICRATE"]; gvVictuallingRate.DataBind(); if (dsProv.Tables["MEAT"].Rows.Count > 0) { lblMeatMaxLimit.Text = Convert.ToString(dsProv.Tables["MEAT"].Rows[0]["MEAT_LIMIT"]); lblMeatCurrentQty.Text = Convert.ToString(dsProv.Tables["MEAT"].Rows[0]["CURRENT_MEAT_QTY"]); } gvPercentage.DataSource = BLL_PURC_Provision.Get_Reqsn_Items_Percent(Request.QueryString["REQSN_CODE"].ToString(), UDFLib.ConvertStringToNull(Request.QueryString["ORDER_CODE"]), "PROVI"); gvPercentage.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { try { UserAccessValidation(); if (!IsPostBack) { BindFleetDLL(); DDLFleet.SelectedValue = Session["USERFLEETID"].ToString(); BindVesselDDL(); BindSystem(); BindSubSystem(); BindPMSDepartmentDDL(); BindRankDDL(); ViewState["Vessel_id"] = null; ViewState["System_ID"] = null; ViewState["IsNewFlage"] = null; ViewState["SORTDIRECTION"] = null; ViewState["SORTBYCOLOUMN"] = null; ViewState["Status"] = null; optStatus.SelectedValue = "P"; // ucCustomPagerItems.PageSize = 30; BindGrid(); } objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "Original Job Deatils", "HeaderStyle-css HeadetTHStyle"); objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11 }, "Change Request", "HeaderStyle-css HeadetTHStyle"); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
protected void BindInvoiceApprovedGrid() { try { objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Invoice Approved", "HeaderStyle-center"); int rowcount = ucCustomPager1.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } string InvoiceStatus = (ViewState["InvoiceStatus"] == null) ? null : (ViewState["InvoiceStatus"].ToString()); string InvoiceWorkflow = (ViewState["InvoiceWorkflow"] == null) ? null : (ViewState["InvoiceWorkflow"].ToString()); //string InvoiceWorkflow = (ViewState["InvoiceWorkflow"] == null) ? null : (ViewState["InvoiceWorkflow"].ToString()); DataSet ds = BLL_POLOG_Register.POLOG_Get_Approved_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1 : 0, InvoiceStatus, InvoiceWorkflow, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount); if (ucCustomPager1.isCountRecord == 1) { ucCustomPager1.CountTotalRec = rowcount.ToString(); ucCustomPager1.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { divApprovedInvoice.Visible = true; btnApprove.Visible = true; //btnApproveAll.Visible = true; //btnRework.Visible = true; //btnRefresh.Visible = true; //btnUnApprove.Visible = false; gvApprovedInvoice.DataSource = ds.Tables[0]; gvApprovedInvoice.DataBind(); } else { divApprovedInvoice.Visible = false; gvApprovedInvoice.DataSource = ds.Tables[0]; gvApprovedInvoice.DataBind(); } } catch { } { } }
/// <summary> /// Bind ApprovalHistory Gridview /// </summary> protected void gvApprovalHistory_DataBound(object sender, EventArgs e) // -- DataBound ApprovalHistory Gridview { string HeaderToHide = ""; string HeaderSupplier = ""; var grh = gvApprovalHistory.HeaderRow; for (int i = 0; i < gvApprovalHistory.HeaderRow.Cells.Count; i++) { string Suppname = grh.Cells[i].Text.ToLower(); if (Suppname.Contains("_hide")) { HeaderToHide += i.ToString() + ","; HeaderSupplier += grh.Cells[i].Text.Split(new char[] { '_' })[0] + ","; gvApprovalHistory.HeaderRow.Cells[i].Visible = false; foreach (GridViewRow gr in gvApprovalHistory.Rows) { gr.Cells[i].Visible = false; } } if (Suppname.Contains("_amount")) { gvApprovalHistory.HeaderRow.Cells[i].Text = "Amount"; gvApprovalHistory.HeaderRow.Cells[i].CssClass = "HeaderStyle-css"; foreach (GridViewRow gr in gvApprovalHistory.Rows) { gr.Cells[i].CssClass = "amount-css"; gr.Cells[0].CssClass = "text-css"; gr.Cells[gr.Cells.Count - 1].CssClass = "text-css"; } } if (Suppname.Contains("_currency")) { gvApprovalHistory.HeaderRow.Cells[i].Text = "Currency"; gvApprovalHistory.HeaderRow.Cells[i].CssClass = "HeaderStyle-css"; } } string[] strColumnIndex = HeaderToHide.Split(new char[] { ',' }); string[] strHeaderName = HeaderSupplier.Split(new char[] { ',' }); int index = 0; foreach (string item in strColumnIndex) { if (item != "") { objApprovalHist.AddMergedColumns(new int[] { int.Parse(item) + 1, int.Parse(item) + 2 }, strHeaderName[index]); } index++; } }
protected void Page_Load(object sender, EventArgs e) { calFrom.Format = CalendarExtender1.Format = UDFLib.GetDateFormat(); if (GetSessionUserID() == 0) { Response.Redirect("~/account/login.aspx"); } else { UserAccessValidation(); } TodayDateFormat = UDFLib.DateFormatMessage(); objContractList.AddMergedColumns(new int[] { 13, 14 }, "Eval(%)", "HeaderStyle-css-2"); if (!IsPostBack) { ConfidentialityCheck(); ViewState["SORTDIRECTION"] = null; ViewState["SORTBYCOLOUMN"] = null; int CurrentUserID = GetSessionUserID(); hdnUserID.Value = CurrentUserID.ToString(); //txtSearchJoinFromDate.Text = DateTime.Now.AddYears(-5).ToString("dd/MM/yyyy", iFormatProvider); txtSearchJoinFromDate.Text = DateTime.Now.AddYears(-5).ToString("dd/MM/yyyy", iFormatProvider); txtSearchJoinFromDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(txtSearchJoinFromDate.Text)); txtSearchJoinToDate.Text = DateTime.Now.ToString("dd/MM/yyyy", iFormatProvider); txtSearchJoinToDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(txtSearchJoinToDate.Text)); Load_CountryList(); Load_FleetList(); Load_ManningAgentList(); Load_RankList(); Load_VesselList(); Load_MainStatus(); Load_VesselTypes(); ucCustomPager_CrewList.PageSize = 30; FillGridViewAfterSearch(); if (Session["UTYPE"].ToString() == "MANNING AGENT") { GridView1.Columns[13].Visible = false; GridView1.Columns[14].Visible = false; } } string js = "Timer();RefreshButtonPopups();"; ScriptManager.RegisterStartupScript(this, this.GetType(), "initscript", js, true); }
protected void BindApprovedPaymentInvoice() { try { int rowcount = ucCustomPagerItems.isCountRecord; DataTable dtType = new DataTable(); objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5 }, "Payment Planned", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7 }, "Priority", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 8, 9 }, "Overdue", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 10, 11 }, "0 To 7 Days", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 12, 13 }, "8 to 14 Days", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "After 15 Days", "HeaderStyle-center"); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } Int16 AutoCheck = 0; if (chkAuto.Checked == true) { AutoCheck = 1; } else { AutoCheck = 0; } DataTable dt = BLL_POLOG_Register.POLOG_Get_Payment_Processing_Invoice_Search(UDFLib.ConvertStringToNull(ddlCurrency.SelectedValue), Convert.ToInt16(AutoCheck), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } //if (dt.Rows.Count > 0) //{ divApprovedinvoice.Visible = true; gvApprovedPaymentinvoice.DataSource = dt; gvApprovedPaymentinvoice.DataBind(); gvApprovedPaymentinvoice.Rows[0].BackColor = System.Drawing.Color.Yellow; BindSupplierInvoice(dt.Rows[0]["Supplier_Code"].ToString()); BindSupplierDetails(dt.Rows[0]["Supplier_Code"].ToString()); txtSupplierCode.Text = dt.Rows[0]["Supplier_Code"].ToString(); //} //else //{ // divApprovedinvoice.Visible = false; // gvApprovedPaymentinvoice.DataSource = dt; // gvApprovedPaymentinvoice.DataBind(); //} } catch { } { } }
protected void Page_Load(object sender, EventArgs e) { if (UDFLib.GetSessionUserID() == 0) { Response.Redirect("~/account/login.aspx?ReturnUrl=" + Request.Path.ToString()); } UserAccessValidation(); objMegeHead.AddMergedColumns(new int[] { 1, 2 }, "Inspection", "HeaderStyle-css HeadetTHStyle"); objMegeHead.AddMergedColumns(new int[] { 8, 9, 10 }, "Duration", "HeaderStyle-css HeadetTHStyle"); if (!IsPostBack) { if (Session["COMPANYTYPE"].ToString().ToUpper() == "SURVEYOR") { lblFleet.Text = "Company :"; DDLFleet.Visible = false; ddlVessel_Manager.Visible = true; } FillDDL(); if (Request.QueryString.Count == 3) { txtFromDate.Text = Convert.ToDateTime(Request.QueryString[0]).ToString("dd/MMM/yy"); txtToDate.Text = Convert.ToDateTime(Request.QueryString[1]).ToString("dd/MMM/yy"); DDLVessel.SelectedValue = Request.QueryString[2]; } string CompanyID = Session["USERCOMPANYID"].ToString(); // removed DisplayReportIcon if (Request.QueryString.Count > 0 && Request.QueryString["InspectionId"] != "") { InspectionId = Convert.ToInt16(Request.QueryString["InspectionId"]); } Load_Current_Schedules(); } }
private void LoadDetails(int Main_Report_ID, int Vessel_ID) { try { DataSet ds = BLL_TankerInspection.GET_TANK_REPORT_DETAILS(Vessel_ID, Main_Report_ID); if (ds.Tables[1].Rows.Count > 0) { lblYear.Text = ds.Tables[0].Rows[0]["Report_Year"].ToString(); lblVesselName.Text = ds.Tables[0].Rows[0]["Vessel_Name"].ToString(); txtremarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString(); if (ds.Tables[0].Rows[0]["VslMasterID"].ToString() != "" && ds.Tables[0].Rows[0]["VslMasterID"].ToString() != "0") { lnkMaster.Text = ds.Tables[0].Rows[0]["VslMasterName"].ToString(); lnkMaster.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + ds.Tables[0].Rows[0]["VslMasterID"].ToString(); lnkMaster.Target = "_blank"; imgMaster.ImageUrl = hdnBaseURL.Value + "uploads/CrewImages/" + ds.Tables[0].Rows[0]["PhotoUrl1"].ToString(); lnkMaster.Visible = true; imgMaster.Visible = true; } else { lnkMaster.Visible = false; imgMaster.Visible = false; } if (ds.Tables[0].Rows[0]["VslChiefOfficerID"].ToString() != "" && ds.Tables[0].Rows[0]["VslChiefOfficerID"].ToString() != "0") { lnkChiefOfficer.Text = ds.Tables[0].Rows[0]["VslChiefOfficerName"].ToString(); lnkChiefOfficer.NavigateUrl = "~/crew/crewdetails.aspx?ID=" + ds.Tables[0].Rows[0]["VslChiefOfficerID"].ToString(); lnkChiefOfficer.Target = "_blank"; imgChiefOfficer.ImageUrl = hdnBaseURL.Value + "uploads/CrewImages/" + ds.Tables[0].Rows[0]["PhotoUrl2"].ToString(); lnkChiefOfficer.Visible = true; imgChiefOfficer.Visible = true; } else { lnkChiefOfficer.Visible = false; imgChiefOfficer.Visible = false; } } GridView_Tanker.DataSource = ds.Tables[1]; GridView_Tanker.DataBind(); objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5, 6 }, "Units Received", "HeaderStyle-css"); //UserAccessValidation(); } catch { } }
protected void Page_Load(object sender, EventArgs e) { objItemColumn.AddMergedColumns(new int[] { 6, 7, 8, 9, 10 }, "Scanned Copy from vessel", "HeaderStyle-css"); if (!IsPostBack) { UserAccessValidation(); Load_Years(); Load_FleetList(); Load_VesselList(); Load_PB_Received(); } }
public void BindLimit(string Group_Code) { objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4, 5 }, "Approver", "HeaderStyle-center"); DataTable dt = BLL_POLOG_Lib.POLOG_Get_Approval_Limit_Search(Group_Code, GetSessionUserID()); if (dt.Rows.Count > 0) { gvLimit.DataSource = dt; gvLimit.DataBind(); } else { gvLimit.DataSource = dt; gvLimit.DataBind(); } }
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 Page_Load(object sender, EventArgs e) { UserAccessValidation(); lblmsg.Text = ""; objContractList.AddMergedColumns(new int[] { 6, 7 }, "No. of items", "HeaderStyle-css"); if (!IsPostBack) { // first check for supplier's log-in string s = UDFLib.ConvertStringToNull(1); if (string.IsNullOrWhiteSpace(Convert.ToString(Session["SUPPCODE"])) && UDFLib.ConvertToInteger(Session["userid"]) == 0) { Server.Transfer("../FileNotFound.aspx"); } //else if (Request.QueryString["__supplier_`_code"] != null) //{ // Session["userid"] = Request.QueryString["__supplier_`_code"]; //} uc_Purc_DepartmentListctp.SelectedValue = "0"; ctlPortListctp.SelectedValue = "0"; if (!string.IsNullOrWhiteSpace(Convert.ToString(Session["SUPPCODE"])) && Convert.ToString(Session["SUPPCODE"]) != "0") { uc_SupplierListCTP.SelectedValue = Convert.ToString(Session["SUPPCODE"]); lblsupp.Enabled = false; hlnkCreateNewContract.Visible = false; btnCompare.Visible = false; gvContractList.ShowFooter = false; chkQtnStatus.Visible = false; chkContractStatus.Visible = false; } else { uc_SupplierListCTP.SelectedValue = "0"; } BindDataItems(); } }
protected void BindPendingInvoiceGrid() { try { objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Invoice Approved", "HeaderStyle-center"); int rowcount = ucCustomPager1.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataTable dtType = ChkType(); string InvoiceStatus = null; DataSet ds = BLL_POLOG_Invoice.POLOG_Get_Final_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), InvoiceStatus, dtType, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount); if (ucCustomPager1.isCountRecord == 1) { ucCustomPager1.CountTotalRec = rowcount.ToString(); ucCustomPager1.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { divApprovedPayment.Visible = false; divPendingInvoice.Visible = true; btnApprove.Visible = true; gvPendingInvoice.DataSource = ds.Tables[0]; gvPendingInvoice.DataBind(); } else { divApprovedPayment.Visible = false; divPendingInvoice.Visible = false; gvPendingInvoice.DataSource = ds.Tables[0]; gvPendingInvoice.DataBind(); } } catch { } { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string id = Request.QueryString["SCMID"]; string id1 = Request.QueryString["SCMID"].ToString(); string tabid = TabSCM.ActiveTab.ID; string tabindex = TabSCM.ActiveTab.TabIndex.ToString(); if (!string.IsNullOrEmpty(Request.QueryString["SCMID"].ToString())) { BindSCMList(); } UserAccessValidation(); BindSCMTabs(); } mergeheadgvSfvs.AddMergedColumns(new int[] { 3, 4, 5 }, "Attendance", "HeaderStyle-css"); mergeheadgvSwpt.AddMergedColumns(new int[] { 3, 4, 5 }, "Attendance", "HeaderStyle-css"); mergeheadgvOrtg.AddMergedColumns(new int[] { 3, 4, 5 }, "Attendance", "HeaderStyle-css"); }
protected void Page_Load(object sender, EventArgs e) { UserAccessValidation(); if (!string.IsNullOrEmpty(Request.QueryString["Vessel_ID"])) { DataSet dsCapt = BLL_PB_PortageBill.ReportDetailsByID_Cur(Request.QueryString["ID"], Request.QueryString["Vessel_ID"]); if (dsCapt.Tables[0].Rows.Count > 0) { lblVessel.Text = dsCapt.Tables[0].Rows[0]["Vessel_Name"].ToString(); lblFrom.Text = dsCapt.Tables[0].Rows[0]["from_date"].ToString(); lblTo.Text = dsCapt.Tables[0].Rows[0]["To_date"].ToString(); lblOpnBL.Text = dsCapt.Tables[0].Rows[0]["Opening_Bal"].ToString(); // lblClosing.Text = dsCapt.Tables[0].Rows[0]["Closing_Bal"].ToString(); lblClosing.Text = (Convert.ToDouble(dsCapt.Tables[0].Rows[0]["Opening_Bal"].ToString()) + Convert.ToDouble(dsCapt.Tables[0].Rows[0]["Total_Recp_Amount"].ToString()) - Convert.ToDouble(dsCapt.Tables[0].Rows[0]["Total_Payment_Amount"].ToString())).ToString(); objItemColumn.AddMergedColumns(new int[] { 5, 6 }, "Amount", "HeaderStyle-css"); gvCastCash.DataSource = dsCapt.Tables[0]; gvCastCash.DataBind(); gvCastCash.FooterRow.Cells[4].Text = "USD"; gvCastCash.FooterRow.Cells[3].Text = "Total :-"; gvCastCash.FooterRow.Cells[4].Style.Add("text-align", "center"); gvCastCash.FooterRow.Cells[3].Style.Add("text-align", "center"); gvCastCash.FooterRow.Cells[3].Style.Add("font-weight", "bold"); gvCastCash.FooterRow.Cells[4].Style.Add("font-weight", "bold"); gvCastCash.FooterRow.Cells[5].Style.Add("font-weight", "bold"); gvCastCash.FooterRow.Cells[6].Style.Add("font-weight", "bold"); (gvCastCash.FooterRow.FindControl("lblRcvdTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Recp_Amount"].ToString(); (gvCastCash.FooterRow.FindControl("lblPaidTotal") as Label).Text = dsCapt.Tables[0].Rows[0]["Total_Payment_Amount"].ToString(); } } }