protected void BindItems() { if (!isCallFromPageLoad) { SaveItems(); } #region ===================== Merge header columns ============================ DataTable dtqtn = (DataTable)ViewState["dtqtns"]; if (objItemColumn.MergedColumns.Count == 0) { int columnindex = lastFixedColumnID + 1; int groupid = 1; string GroupCss = ""; string suppliername = ""; string portname = ""; foreach (GridViewRow gr in rgdSupplierInfo.Rows) { DataRow drqtnid = dtqtn.Rows.Find(rgdSupplierInfo.DataKeys[gr.RowIndex].Values["Quotation_ID"].ToString()); //get show only quoted item status for filter drqtnid["onlyQuoted"] = ((CheckBox)gr.FindControl("chkshowOnlyQuoted")).Checked == true ? "1" : "0"; drqtnid["ApprvalStatus"] = ((DropDownList)gr.FindControl("ddlApproval")).SelectedValue == "" ? null : ((DropDownList)gr.FindControl("ddlApproval")).SelectedValue; dicchkOnlyQuoted.Add(gr.RowIndex, ((CheckBox)gr.FindControl("chkshowOnlyQuoted")).Checked); dicddlApproval.Add(gr.RowIndex, ((DropDownList)gr.FindControl("ddlApproval")).SelectedValue); if (groupid % 2 == 1) { GroupCss = "Ctp-QtnEval-HeaderStyle-css"; } else { GroupCss = "Ctp-QtnEval-AltHeaderStyle-css"; } suppliername = ((Label)gr.FindControl("lblSupplierName")).Text; suppliername = suppliername.Length > 20 ? suppliername.Substring(0, 19) : suppliername; portname = ((Label)gr.FindControl("lblPortName")).Text; portname = portname.Length > 20 ? portname.Substring(0, 19) : portname; objItemColumn.AddMergedColumns(new int[] { columnindex, columnindex + 1, columnindex + 2, columnindex + 3, columnindex + 4, columnindex + 5, columnindex + 6 }, suppliername + "  ,  " + portname, GroupCss); columnindex += SupplierColumnGroup; groupid++; } dtqtn.AcceptChanges(); } #endregion int is_fetch_count = ucCustomPageritems.isCountRecord; rgdQuatationInfo.DataSource = BLL_PURC_CTP.Get_Ctp_Qtn_Eval_Item(dtqtn, UDFLib.ConvertStringToNull(txtitemsearch.Text), UDFLib.ConvertStringToNull(ddlSubCatalogue.SelectedValue), UDFLib.ConvertIntegerToNull(""), ucCustomPageritems.CurrentPageIndex, ucCustomPageritems.PageSize, ref is_fetch_count, UDFLib.ConvertIntegerToNull(ViewState["SortDirection"]), UDFLib.ConvertStringToNull(ViewState["SortColumn"])); rgdQuatationInfo.DataBind(); if (ucCustomPageritems.isCountRecord == 1) { ucCustomPageritems.CountTotalRec = is_fetch_count.ToString(); ucCustomPageritems.BuildPager(); } isCallFromPageLoad = false; }
public void BindData_UnSelected() { int IsFetchCount = ucCustomPagerItem_UnSelected.isCountRecord; gvItem_UnSelected.DataSource = BLL_PURC_CTP.Get_Ctp_Items(Catalogue_code, UDFLib.ConvertStringToNull(SubCatalogue), UDFLib.ConvertStringToNull(txtItemSearch.Text), (DataTable)ViewState["vsdtSelected_Items"], (DataTable)ViewState["vsdtSelected_SubCatalogue"], (DataTable)ViewState["vsdtSelected_SubCatalogue_items"], 0, UDFLib.ConvertIntegerToNull(Quotation_ID), ucCustomPagerItem_UnSelected.CurrentPageIndex, ucCustomPagerItem_UnSelected.PageSize, ref IsFetchCount, Contract_ID); gvItem_UnSelected.DataBind(); if (ucCustomPagerItem_UnSelected.isCountRecord == 1) { ucCustomPagerItem_UnSelected.CountTotalRec = IsFetchCount.ToString(); ucCustomPagerItem_UnSelected.BuildPager(); } btnSelect_All.Enabled = (IsFetchCount < 1) ? false : true; btnselectAll_SubCatalogue.Enabled = (IsFetchCount < 1 || SubCatalogue.Trim() == "" || SubCatalogue.Trim() == "0") ? false : true; Set_SelectedCatalogue(); }
protected void btnsave_Click(object sender, EventArgs e) { int retval; if (HiddenFlag.Value == "Add") { retval = objBLLSysVariable.Insert_SysVariable(UDFLib.ConvertStringToNull(ddlVariableType.SelectedValue), txtName.Text.Trim() , txtCode.Text.Trim(), txtValue.Text.Trim(), txtColorCode.Text.Trim(), Convert.ToInt32(Session["USERID"])); } else { retval = objBLLSysVariable.Edit_SysVariable(UDFLib.ConvertIntegerToNull(txtVariableID.Text), UDFLib.ConvertStringToNull(ddlVariableType.SelectedValue), txtName.Text.Trim() , txtCode.Text.Trim(), txtValue.Text.Trim(), txtColorCode.Text.Trim(), Convert.ToInt32(Session["USERID"])); } if (retval >= 1) { BindSysVariableGrid(); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); } else { lblMsg.Text = "Variable Code already exists."; } }
public void BindData() { int rowcount = ucCustomPagerItems.isCountRecord; BLL_PURC_Purchase objPurcBLL = new BLL_PURC_Purchase(); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); string sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = (ViewState["SORTDIRECTION"].ToString()); } //DataTable dt = objPurcBLL.SelectNewRequisitionList((DataTable)Session["sFleet"], (DataTable)Session["sVesselCode"] // , UDFLib.ConvertStringToNull(Session["sDeptType"]), (DataTable)Session["sDeptCode"] // , UDFLib.ConvertIntegerToNull(Session["ReqsnType"].ToString()), UDFLib.ConvertStringToNull(Session["REQNUM"].ToString()) // , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount,sortbycoloumn, UDFLib.ConvertStringToNull(sortdirection)); DataTable dt = objPurcBLL.SelectNewRequisitionList_New (UDFLib.ConvertStringToNull(Session["sFleet"]), UDFLib.ConvertStringToNull(Session["sVesselCode"]) , UDFLib.ConvertStringToNull(Session["sDeptType"]) , UDFLib.ConvertStringToNull(Session["sPurc_Dept"]) , UDFLib.ConvertStringToNull(Session["REQNUM"]) , UDFLib.ConvertStringToNull(Session["sPOType"]) , UDFLib.ConvertStringToNull(Session["sAccType"]) , UDFLib.ConvertStringToNull(Session["ReqsnType"]) , UDFLib.ConvertStringToNull(Session["sCatalogue"]) , UDFLib.ConvertDateToNull(Session["sFrom"]) , UDFLib.ConvertDateToNull(Session["sTO"]) , UDFLib.ConvertStringToNull(Session["sAccClass"]) , UDFLib.ConvertStringToNull(Session["sUrgency"]) , UDFLib.ConvertStringToNull((Session["sReqsnStatus"])) , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount, sortbycoloumn, UDFLib.ConvertStringToNull(sortdirection)); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } rgdNewREQ.DataSource = dt; if (ViewState["NeedDataSource"] == "0") { rgdNewREQ.DataBind(); } string script = " var height = document.body.scrollHeight;parent.ResizeFromChild(height,'1');"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "resize" + DateTime.Now.Millisecond.ToString(), script, true); }
protected void lbtnDAEdit_Click(object s, CommandEventArgs e) { string[] arg = e.CommandArgument.ToString().Split(','); int? DA_ID = UDFLib.ConvertIntegerToNull(arg[0]); ViewState["DA_ID"] = UDFLib.ConvertIntegerToNull(arg[0]); ViewState["Agent_Code"] = UDFLib.ConvertIntegerToNull(arg[1]); DataSet ds = objPortCall.Get_PortCall_DAItem(UDFLib.ConvertStringToNull(ViewState["DA_ID"]), UDFLib.ConvertStringToNull(ViewState["Agent_Code"]), UDFLib.ConvertStringToNull(ddlPortCost.SelectedValue)); if (ds.Tables[0].Rows.Count > 0) { gvDAItem.DataSource = ds; gvDAItem.DataBind(); } //BindActivity(); }
protected void btnExport_Click(object sender, ImageClickEventArgs e) { 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, null, null, ref rowcount); string[] HeaderCaptions = { "Vessel", "Location", "SubSystem", "Job Code", "Job Title", "Frequency", "Frequency Name", "Last Done", "Rhrs", "Next Due", "CMS", "Critical", "Tentative Completion Date", "Modified Completion Date", "Responded By" }; string[] DataColumnsName = { "Vessel_Name", "Location", "SubSystem", "JOB_ID", "JOB_TITLE", "FREQUENCY", "Frequency_Name", "LAST_DONE", "RHRS_DONE", "DATE_NEXT_DUE", "CMS", "Critical", "Tentative_Completion_Date", "Modified_Completion_Date", "Actioned_By" }; GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "PMS Overdue Jobs", "PMS Overdue Jobs", ""); }
protected int InvoiceUpload(string FileStatus, string Action_On_Data_Form) { int ret = 0; try { if (FileUploader.HasFile) { if (FileUploader.FileName != "") { string strLocalPath = FileUploader.PostedFile.FileName; string FileName = Path.GetFileName(strLocalPath); string FileExtension = Path.GetExtension(strLocalPath); int TYPE = 0; string InvoiceType = "CREDIT"; Guid FileGuid = System.Guid.NewGuid(); FileUploader.PostedFile.SaveAs(Server.MapPath(@"~/Uploads\\ASL\\Invoice\\" + FileGuid + FileExtension)); ret = BLL_ASL_Supplier.Supplier_Upload_Document_Insert(UDFLib.ConvertIntegerToNull(txtFileID.Text.Trim()), UDFLib.ConvertStringToNull(GetSupplierCode()), UDFLib.ConvertStringToNull(GetSuppID()), FileName, FileGuid + FileExtension, FileExtension , txtInvioceRef.Text.Trim(), UDFLib.ConvertDateToNull(txtInvoiceDate.Text), UDFLib.ConvertDecimalToNull(txtInvoiceAmount.Text), UDFLib.ConvertDecimalToNull(txtTaxAmount.Text), txtRemarks.Text.Trim(), UDFLib.ConvertDateToNull(txtDueDate.Text), FileStatus, Action_On_Data_Form, InvoiceType, UDFLib.ConvertIntegerToNull(Session["userid"]), TYPE); } } else if (lblFileName.Text != "") { string FileName = ""; string FileExtension = ""; int TYPE = 0; string InvoiceType = "CREDIT"; Guid FileGuid = System.Guid.NewGuid(); ret = BLL_ASL_Supplier.Supplier_Upload_Document_Insert(UDFLib.ConvertIntegerToNull(txtFileID.Text.Trim()), UDFLib.ConvertStringToNull(GetSupplierCode()), UDFLib.ConvertStringToNull(GetSuppID()), FileName, "", FileExtension , txtInvioceRef.Text.Trim(), UDFLib.ConvertDateToNull(txtInvoiceDate.Text), UDFLib.ConvertDecimalToNull(txtInvoiceAmount.Text), UDFLib.ConvertDecimalToNull(txtTaxAmount.Text), txtRemarks.Text.Trim(), UDFLib.ConvertDateToNull(txtDueDate.Text), FileStatus, Action_On_Data_Form, InvoiceType, UDFLib.ConvertIntegerToNull(Session["userid"]), TYPE); } return(ret); } catch { return(ret); } { } }
public void BindPaymentSchedule() { try { DataSet ds = BLL_POLOG_Register.POLOG_Get_Payment_Schedule_Amount(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1 : 0, UDFLib.ConvertIntegerToNull(GetSessionUserID())); if (ds.Tables[0].Rows.Count > 0) { table1.Visible = true; gvPaymentApproved.DataSource = ds.Tables[0]; gvPaymentApproved.DataBind(); gvPaymentSchedule.DataSource = ds.Tables[1]; gvPaymentSchedule.DataBind(); } else { table1.Visible = false; gvPaymentApproved.DataSource = ds.Tables[0]; gvPaymentApproved.DataBind(); gvPaymentSchedule.DataSource = ds.Tables[1]; gvPaymentSchedule.DataBind(); } } catch { } { } }
protected void BindPaymentApprovedGrid() { try { int rowcount = ucCustomPager2.isCountRecord; objChangeReqstMerge.AddMergedColumns(new int[] { 2, 3, 4 }, "PO", "HeaderStyle-center"); //objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6 }, "Total Invoice Value & Count", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6, 7, 8, 9, 10, 11, 12, 13 }, "Invoice", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "Payment Approved", "HeaderStyle-center"); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } string InvoiceAmt = (ViewState["InvoiceAmt"] == null) ? null : (ViewState["InvoiceAmt"].ToString()); string InvoiceStatus = (ViewState["InvoiceStatus"] == null) ? null : (ViewState["InvoiceStatus"].ToString()); string PaymentStatus = (ViewState["PaymentStatus"] == null) ? null : (ViewState["PaymentStatus"].ToString()); DataTable dt = BLL_POLOG_Register.POLOG_Get_Approved_Payment_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1 : 0, InvoiceStatus, PaymentStatus, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPager2.CurrentPageIndex, ucCustomPager2.PageSize, ref rowcount); if (ucCustomPager2.isCountRecord == 1) { ucCustomPager2.CountTotalRec = rowcount.ToString(); ucCustomPager2.BuildPager(); } if (dt.Rows.Count > 0) { btnUnApprove.Visible = true; divApprovedPayment.Visible = true; gvApprovedPayment.DataSource = dt; gvApprovedPayment.DataBind(); } else { divApprovedPayment.Visible = false; btnUnApprove.Visible = false; gvApprovedPayment.DataSource = dt; gvApprovedPayment.DataBind(); } } catch { } { } }
protected void DetailsView_NewAcc_ItemInserting(object sender, DetailsViewInsertEventArgs e) { if (e.Values["Beneficiary"] == null || e.Values["Acc_NO"] == null || e.Values["Bank_Name"] == null || e.Values["Bank_Address"] == null || e.Values["SwiftCode"] == null) { string js = "parent.ShowNotification('Alert','Unable to save as some of the fields are left blank',true)"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js, true); if (((CheckBox)DetailsView_NewAcc.FindControl("chkMOAcc")).Checked == true) { DisableControls(); } } else { int AccID = UDFLib.ConvertToInteger(HiddenField_AccID.Value); int CrewID = UDFLib.ConvertToInteger(HiddenField_CrewID.Value); string Beneficiary = e.Values["Beneficiary"].ToString(); string Acc_No = e.Values["Acc_NO"].ToString(); string Bank_Name = e.Values["Bank_Name"].ToString(); string Bank_Address = e.Values["Bank_Address"].ToString(); int Default_Acc = UDFLib.ConvertStringToNull(e.Values["Default_Acc"]) == null ? 0 : UDFLib.ConvertStringToNull(e.Values["Default_Acc"]) == "True" ? 1 : 0; int Verified = UDFLib.ConvertStringToNull(e.Values["Verified"]) == null ? 0 : UDFLib.ConvertStringToNull(e.Values["Verified"]) == "True" ? 1 : 0; string SwiftCode = e.Values["SwiftCode"].ToString(); int Modified_By = UDFLib.ConvertToInteger(Session["USERID"]); string Bank_Code = e.Values["BANK_CODE"] == null ? "" : e.Values["BANK_CODE"].ToString(); string Branch_Code = e.Values["BRANCH_CODE"] == null ? "" : e.Values["BRANCH_CODE"].ToString(); int Account_Curr = UDFLib.ConvertToInteger(e.Values["ACCOUNT_CURR"].ToString()); int MOBank_ID = UDFLib.ConvertToInteger(e.Values["MOBank_ID"].ToString()); int Res = SMS.Business.PortageBill.BLL_PortageBill.ACC_Insert_BankAccounts(CrewID, Beneficiary, Acc_No, Bank_Name, Bank_Address, Default_Acc, Verified, Modified_By, SwiftCode, Bank_Code, Branch_Code, Account_Curr, MOBank_ID); if (e.CommandArgument.ToString() == "SaveAndClose") { string js2 = "parent.hideModal('dvPopupFrame'); parent.GetCrewBankAcc(" + HiddenField_CrewID.Value.ToString() + ");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js2, true); } else { lblMsg.Text = "New Account Details Updated!!"; string js3 = "parent.GetCrewBankAcc(" + HiddenField_CrewID.Value.ToString() + ");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", js3, true); } } }
protected void BindWithholdInvoice() { try { int rowcount = ucCustomPager3.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()); DataSet ds = BLL_POLOG_Register.POLOG_Get_Withhold_Invoice_Search(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1 : 0, InvoiceStatus, UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPager3.CurrentPageIndex, ucCustomPager3.PageSize, ref rowcount); if (ucCustomPager3.isCountRecord == 1) { ucCustomPager3.CountTotalRec = rowcount.ToString(); ucCustomPager3.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { dvWithhold.Visible = true; gvPOWithhold.DataSource = ds.Tables[0]; gvPOWithhold.DataBind(); txtPOCode.Text = ds.Tables[0].Rows[0]["SUPPLY_ID"].ToString(); BindInvoice(ds.Tables[0].Rows[0]["SUPPLY_ID"].ToString()); gvPOWithhold.Rows[0].BackColor = System.Drawing.Color.Yellow; } else { dvWithhold.Visible = false; gvPOWithhold.DataSource = ds.Tables[0]; gvPOWithhold.DataBind(); } } catch { } { } }
public void BindGrid() { 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()); } DataTable dt = BLL_QMS_RestHours.Get_RestHours_Index(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(ddlvessel.SelectedValue), UDFLib.ConvertStringToNull(txtCrew.Text), UDFLib.ConvertStringToNull(ddlRank.SelectedValue) , UDFLib.ConvertDateToNull(txtfrom.Text), UDFLib.ConvertDateToNull(txtto.Text), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (dt.Rows.Count > 0) { gvDeckLogBook.DataSource = dt; gvDeckLogBook.DataBind(); } else { gvDeckLogBook.DataSource = dt; gvDeckLogBook.DataBind(); } }
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()); } DataTable dt = BLL_QMS_RestHours.Get_RestHours_Index(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(ddlvessel.SelectedValue), UDFLib.ConvertStringToNull(txtCrew.Text), UDFLib.ConvertStringToNull(ddlRank.SelectedValue), UDFLib.ConvertDateToNull(txtfrom.Text), UDFLib.ConvertDateToNull(txtto.Text), sortbycoloumn, sortdirection , 1, null, ref rowcount); string[] HeaderCaptions = { "Vessel", "Date", "Code", "Crew Name", "Rank", "Ship's Clocked Hours", "Working Hours", "Rest Hours", "Rest Hours Any 24", "Over Time", "Seafarer's Remarks", "Verifier's Remarks" }; string[] DataColumnsName = { "Vessel_Name", "REST_HOURS_DATE", "Staff_Code", "Staff_Name", "Staff_rank_Code", "SHIPS_CLOCKED_HOURS", "WORKING_HOURS", "REST_HOURS", "REST_HOURS_ANY24", "OverTime_HOURS", "Seafarer_Remarks", "Verifier_Remarks" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "Rest Hour", "Rest_Hours_Index", ""); //ExcelDataExport objexp = new ExcelDataExport(); //objexp.WriteExcell(dt); }
public void BindGridView() { //try //{ objChangeReqstMerge.AddMergedColumns(new int[] { 5, 6 }, "PO", "HeaderStyle-center"); 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()); } if (Session["sVesselCode"] == "0") { Session["sVesselCode"] = ddlVessel.SelectedValues; } if (Session["sAccountType"] == "0") { Session["sAccountType"] = ddlAccountType.SelectedValues; } if (Session["sAccClassification"] == "0") { Session["sAccClassification"] = ddlAccClassification.SelectedValues; } DataSet ds = BLL_POLOG_Register.POLOG_Get_Purchase_Report(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), (DataTable)Session["sVesselCode"], (DataTable)Session["sAccountType"], (DataTable)Session["sAccClassification"], CurrStatus, txtFromDate.Text != "" ? Convert.ToDateTime(txtFromDate.Text) : Convert.ToDateTime("01/01/1900"), txtToDate.Text != "" ? Convert.ToDateTime(txtToDate.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 lblTotOutPOCurAmt1 = (Label)gvPurchase.FooterRow.FindControl("lblTotOutPOCurAmt1"); Label lblTotPOUSDValue1 = (Label)gvPurchase.FooterRow.FindControl("lblTotPOUSDValue1"); Label lblTotInvUSDAmt1 = (Label)gvPurchase.FooterRow.FindControl("lblTotInvUSDAmt1"); Label lblTotPaidUSDAmt1 = (Label)gvPurchase.FooterRow.FindControl("lblTotPaidUSDAmt1"); lblTotOutPOCurAmt1.Text = ds.Tables[1].Rows[0]["OutStanding_USD_Amount"].ToString(); lblTotPOUSDValue1.Text = ds.Tables[1].Rows[0]["PO_USD_Value"].ToString(); lblTotInvUSDAmt1.Text = ds.Tables[1].Rows[0]["Invoice_USD_Amount"].ToString(); lblTotPaidUSDAmt1.Text = ds.Tables[1].Rows[0]["Paid_USD_Amount"].ToString(); } else { divPurchase.Visible = false; gvPurchase.DataSource = ds.Tables[0]; gvPurchase.DataBind(); gvPurchase.EmptyDataText = "NO RECORDS FOUND"; } // } //catch { } //{ //} }
protected void btnView_Click(object sender, CommandEventArgs e) { string[] arg = e.CommandArgument.ToString().Split(','); txtInvoiceCode.Text = UDFLib.ConvertStringToNull(arg[0]); string InvoiceStatus = UDFLib.ConvertStringToNull(arg[1]); string PaymentStatus = UDFLib.ConvertStringToNull(arg[2]); string Dispute_Flag = UDFLib.ConvertStringToNull(arg[3]); BindAttachment(UDFLib.ConvertStringToNull(txtInvoiceCode.Text)); BindRemarks(UDFLib.ConvertStringToNull(txtInvoiceCode.Text)); //BindGrid(InvoiceID); BindDuplicateInvoice(UDFLib.ConvertStringToNull(txtInvoiceCode.Text)); BindDeliveryGrid(UDFLib.ConvertStringToNull(txtInvoiceCode.Text)); if (Dispute_Flag == "YES") { btnDispute.Text = "Un-Dispute"; } else { btnDispute.Text = "Dispute"; } if (InvoiceStatus == "Verified") { btnInvoiceApprove.Enabled = true; btnInvoiceApprove.Text = "Approve Invoice"; if (Dispute_Flag == "YES") { btnInvoiceApprove.Enabled = false; } } else if (InvoiceStatus == "Approved") { if (Request.QueryString["PageName"] == "FinalApproval") { btnInvoiceApprove.Visible = false; btnPaymentApprove.Visible = false; btnFinalApprove.Visible = true; if (PaymentStatus == "") { btnFinalApprove.Visible = true; btnFinalApprove.Text = "Final UnApproval"; } if (Dispute_Flag == "YES") { btnFinalApprove.Enabled = false; } else { btnFinalApprove.Enabled = true; } } else if (Request.QueryString["PageName"] == "PaymentApproval") { if (PaymentStatus == "") { btnPaymentApprove.Text = "Approve Payment"; dvWithhold.Visible = true; } else if (PaymentStatus == "Approved") { btnPaymentApprove.Text = "Un-Approve Payment"; dvWithhold.Visible = false; } if (Dispute_Flag == "YES") { btnPaymentApprove.Enabled = false; } else { btnPaymentApprove.Enabled = true; } } else if (Request.QueryString["PageName"] == "InvoiceApproval") { btnInvoiceApprove.Text = "UnApprove Invoice"; if (PaymentStatus == "") { btnInvoiceApprove.Enabled = true; } else { btnInvoiceApprove.Enabled = false; } if (Dispute_Flag == "YES") { btnInvoiceApprove.Enabled = false; } else { btnInvoiceApprove.Enabled = true; } } } else { btnDispute.Enabled = true; btnInvoiceApprove.Enabled = false; } foreach (GridViewRow row in gvInvoice.Rows) { String ID = gvInvoice.DataKeys[row.RowIndex].Values[0].ToString(); if (txtInvoiceCode.Text == ID) { row.BackColor = System.Drawing.Color.Yellow; } else { row.BackColor = System.Drawing.Color.White; } } }
protected void BindInvoiceCount() { try { DataTable dt = BLL_POLOG_Register.POLOG_Get_Approved_Invoice_Count(UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlOwner.SelectedValue), chkUrgent.Checked ? 1: 0, UDFLib.ConvertIntegerToNull(GetSessionUserID())); if (dt.Rows.Count > 0) { divInvoiceCount.Visible = true; gvInviceCount.DataSource = dt; gvInviceCount.DataBind(); } else { divInvoiceCount.Visible = false; gvInviceCount.DataSource = dt; gvInviceCount.DataBind(); } } catch { } { } }
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(); } }
/// <summary> /// to fill machinery running hours data to grid view. /// </summary> public void BindRuningHours() { try { int rowcount = ucCustomPagerItems.isCountRecord; DataSet ds = new DataSet(); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } ds = objJobStatus.TecMachineryRunningHoursSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(DDLVessel.SelectedValue), UDFLib.ConvertDateToNull(txtFromDate.Text), UDFLib.ConvertDateToNull(txtToDate.Text), null, null, ViewState["RecordDisplayType"].ToString(), UDFLib.ConvertIntegerToNull(ddlFunction.SelectedValue), UDFLib.ConvertStringToNull(ddlSystem_location.SelectedValue.Split(',')[1]), UDFLib.ConvertIntegerToNull(ddlSystem_location.SelectedValue.Split(',')[0]), UDFLib.ConvertIntegerToNull(ddlSubSystem_location.SelectedValue.Split(',')[1]), UDFLib.ConvertIntegerToNull(ddlSubSystem_location.SelectedValue.Split(',')[0]) , sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount, chkDisplayInheritingCounter.Checked == true ? 1 : 0); if (ViewState["RecordDisplayType"] == "H") { gvRhrs.Columns[3].Visible = false; } else { gvRhrs.Columns[3].Visible = true; } if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (ds.Tables[0].Rows.Count > 0) { gvRhrs.DataSource = ds.Tables[0]; gvRhrs.DataBind(); } else { gvRhrs.DataSource = ds.Tables[0]; gvRhrs.DataBind(); } } catch (Exception ex) { throw ex; } }
private void BindSupplier() { GrdSupplier.DataSource = BLL_TRV_Supplier.Get_SupplierList(UDFLib.ConvertStringToNull(txtSupplierSearch.Text), RequestID); GrdSupplier.DataBind(); }
/// <summary> /// Excel export /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, ImageClickEventArgs e) { try { 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.TecMachineryRunningHoursSearch(UDFLib.ConvertIntegerToNull(DDLFleet.SelectedValue), UDFLib.ConvertIntegerToNull(DDLVessel.SelectedValue) , UDFLib.ConvertDateToNull(txtFromDate.Text), UDFLib.ConvertDateToNull(txtToDate.Text), null, null, ViewState["RecordDisplayType"].ToString(), UDFLib.ConvertIntegerToNull(ddlFunction.SelectedValue), UDFLib.ConvertStringToNull(ddlSystem_location.SelectedValue.Split(',')[1]), UDFLib.ConvertIntegerToNull(ddlSystem_location.SelectedValue.Split(',')[0]), UDFLib.ConvertIntegerToNull(ddlSubSystem_location.SelectedValue.Split(',')[1]), UDFLib.ConvertIntegerToNull(ddlSubSystem_location.SelectedValue.Split(',')[0]), sortbycoloumn, sortdirection, null, null, ref rowcount, chkDisplayInheritingCounter.Checked == true ? 1 : 0); string[] HeaderCaptions = { "Vessel", "System Location", "Sub-System Location", "Date Hours Read", "Differential R.Hours", "Running Hours", "Created by", "Created Date" }; string[] DataColumnsName = { "Vessel_Name", "Location", "SubLocation", "Date_Hours_Read", "diff_in_Rhrs", "Runing_Hours", "Created_By", "Created_On" }; GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "Machinery Running Hours", "Machinery Running Hours", ""); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
protected void BindGrid() { string Supplier_Code = GetSupplierCode(); string Supp_ID = GetSuppID(); //txtFileID.Text = GetFileID(); // int? SuppID = UDFLib.ConvertIntegerToNull(Request.QueryString["Supp_ID"]); DataSet ds = BLL_ASL_Supplier.Get_Supplier_Upload_Document(UDFLib.ConvertStringToNull(Supplier_Code), UDFLib.ConvertStringToNull(Supp_ID), "CREDIT", UDFLib.ConvertStringToNull(txtFileID.Text.Trim())); //ViewState["RetFileID"] = FileID; if (ds.Tables[0].Rows.Count > 0) { lblVessel.Text = ds.Tables[0].Rows[0]["Vessel_Name"].ToString(); lblRef.Text = ds.Tables[0].Rows[0]["Office_Ref_Code"].ToString(); lblDated.Text = ds.Tables[0].Rows[0]["LineDate"].ToString(); lblAmount.Text = ds.Tables[0].Rows[0]["Line_Amount"].ToString(); } if (ds.Tables[1].Rows.Count > 0) { lblFileName.Text = ds.Tables[1].Rows[0]["File_Name"].ToString(); txtInvioceRef.Text = ds.Tables[1].Rows[0]["Invoice_Reference"].ToString(); txtInvoiceDate.Text = ds.Tables[1].Rows[0]["Invoice_Date"].ToString(); txtInvoiceAmount.Text = ds.Tables[1].Rows[0]["Invoice_Amount"].ToString(); txtTaxAmount.Text = ds.Tables[1].Rows[0]["Invoice_GST_Amount"].ToString(); txtDueDate.Text = ds.Tables[1].Rows[0]["Invoice_Due_Date"].ToString(); txtRemarks.Text = ds.Tables[1].Rows[0]["Invoice_Remarks"].ToString(); lblInvoiceReferance.Text = ds.Tables[1].Rows[0]["Invoice_Reference"].ToString(); lblDate.Text = ds.Tables[1].Rows[0]["Invoice_Date"].ToString(); lblInvoiceAmount.Text = ds.Tables[1].Rows[0]["Invoice_Amount"].ToString(); //lblFileName.Text = ds.Tables[1].Rows[0]["File_Path"].ToString(); //"../uploads/ASL/" string FilePath = ds.Tables[1].Rows[0]["File_Path"].ToString(); string FileLocation = HttpContext.Current.Server.MapPath("../Uploads/ASL/Invoice/" + FilePath); if (FilePath != "") { divIframe.Visible = true; iFrame1.Attributes["src"] = @"../Uploads/ASL/Invoice/" + FilePath; } if (ds.Tables[1].Rows[0]["File_Status"].ToString() == "SUBMITTED") { DivStep4.Visible = true; btnSubmit.Enabled = false; btnUploadInvoice.Enabled = false; btnRecallInvoice.Enabled = true; } } string Type = GetInvoiceType(); if (Type == "1") { DivStep3.Visible = true; } else { Divstep1.Visible = true; } }
protected void btnsave_Click(object sender, EventArgs e) { int responseid = 0; responseid = objBLL.EditCompMailAction(UDFLib.ConvertStringToNull(txtSubject.Text), UDFLib.ConvertStringToNull(txtMailTo.Text), UDFLib.ConvertStringToNull(txtMailCc.Text), UDFLib.ConvertStringToNull(txtemailbody.Text), int.Parse(txtMailID.Text), Convert.ToInt32(Session["USERID"])); BindCompany_MailAction(); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); }
public void BindDataItems() { int is_Fetch_Count = ucCustomPagerPO.isCountRecord; gvOrderList.DataSource = BLL_PURC_LOG.Get_Log_PO_List(int.Parse(DDLVessel.SelectedValue), UDFLib.ConvertStringToNull(uc_SupplierList1.SelectedValue), UDFLib.ConvertStringToNull(txtPoNumber.Text), ucCustomPagerPO.CurrentPageIndex, ucCustomPagerPO.PageSize, ref is_Fetch_Count); gvOrderList.DataBind(); ucCustomPagerPO.CountTotalRec = is_Fetch_Count.ToString(); ucCustomPagerPO.BuildPager(); }
/// <summary> /// Method to add or modify the port call setails /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnsave_Click(object sender, EventArgs e) { try { string ArrivalTime = ddlArrHour.SelectedValue + ":" + ddlArrMin.SelectedValue; string BerthingTime = ddlBerthingHour.Text + ":" + ddlBerthingMin.SelectedValue; string DepartureTime = ddlDepHr.Text + ":" + ddlDepmin.SelectedValue; bool bAutoDate = chkAutoDate.Checked; string PortCallStatus = ""; DateTime Berthingdt; int str = 0; int PortId = 0; string PortLocation = string.Empty; //Done changes for the Date format issue on save var Arrival = ""; var Dep = ""; var Berthing = ""; if (dtpArrival.Text != "") { Arrival = UDFLib.ConvertToDefaultDt(dtpArrival.Text); } if (dtpDeparture.Text != "") { Dep = UDFLib.ConvertToDefaultDt(dtpDeparture.Text); } if (dtpBerthing.Text != "") { Berthing = UDFLib.ConvertToDefaultDt(dtpBerthing.Text); } if (dtpBerthing.Text == "") { Berthingdt = Convert.ToDateTime(Arrival + " " + ArrivalTime); } else { Berthingdt = Convert.ToDateTime(Berthing + " " + BerthingTime); } if (chkNewLocation.Checked == false) { PortId = UDFLib.ConvertToInteger(DDLPort.SelectedValue); } else { PortLocation = txtlocation.Text; } if (dtpArrival.Text.Trim() != "" && dtpDeparture.Text.Trim() != "") { DateTime Arrivaldt = Convert.ToDateTime(Arrival + " " + ArrivalTime); DateTime Depdt = Convert.ToDateTime(Dep + " " + DepartureTime); ViewState["dtpArrival"] = Arrival; ViewState["dtpDeparture"] = Dep; ViewState["ddlArrHour"] = ddlArrHour.SelectedValue; ViewState["ddlArrMin"] = ddlArrMin.SelectedValue; ViewState["ddlDepHr"] = ddlDepHr.SelectedValue; ViewState["ddlDepmin"] = ddlDepmin.SelectedValue; if (Arrivaldt > Berthingdt) { lbl1.Text = "Berthing Date can't be before of Arrival Date."; } else if (Arrivaldt > Depdt) { lbl1.Text = "Departure Date can't be before of Arrival Date."; } else if (Berthingdt > Depdt) { lbl1.Text = "Departure Date can't be before of Berthing Date."; } else { if (UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]) == 0) { str = objPortCall.Ins_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); //str = objPortCall.Ins_PortCall_Details(UDFLib.ConvertIntegerToNull(str)); } else { if (chkPortCallStatus.Checked == true) { PortCallStatus = "OMITTED"; } str = objPortCall.Upd_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); } if (str == -1) { lbl1.Text = "Input Date should not come in between existing arrival/departure Date ."; } else if (str == -2) { lbl1.Text = "Input Date should not come in between existing arrival/departure Date ."; } else if (str == -3) { lbl1.Text = "Input Date time should not be less than previous port call time."; } else { //str = objPortCall.Ins_PortCall_Details(UDFLib.ConvertIntegerToNull(str)); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } } } else { if (UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]) == 0) { if (dtpArrival.Text != "" && dtpBerthing.Text != "") { if (Convert.ToDateTime(Berthing) < Convert.ToDateTime(Arrival)) { lbl1.Text = "Berthing Date can't be before of Arrival Date."; } else { str = objPortCall.Ins_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } } else if (dtpBerthing.Text != "" && dtpDeparture.Text != "") { if (Convert.ToDateTime(dtpDeparture.Text) < Convert.ToDateTime(dtpBerthing.Text)) { lbl1.Text = "Departure Date can't be before of Berthing Date."; } else { str = objPortCall.Ins_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } } else { str = objPortCall.Ins_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } } else { if (chkPortCallStatus.Checked == true) { PortCallStatus = "OMITTED"; } if (dtpArrival.Text != "" && dtpBerthing.Text != "") { if (Convert.ToDateTime(dtpBerthing.Text) < Convert.ToDateTime(dtpArrival.Text)) { lbl1.Text = "Berthing Date can't be before of Arrival Date."; } else { str = objPortCall.Upd_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } } else if (dtpBerthing.Text != "" && dtpDeparture.Text != "") { if (Convert.ToDateTime(dtpDeparture.Text) < Convert.ToDateTime(dtpBerthing.Text)) { lbl1.Text = "Departure Date can't be before of Berthing Date."; } else { str = objPortCall.Upd_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } } else { str = objPortCall.Upd_PortCall_Details(UDFLib.ConvertToInteger(ViewState["ReturnPortCallID"]), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), PortId , UDFLib.ConvertDateToNull(Arrival) , UDFLib.ConvertStringToNull(Berthing) , UDFLib.ConvertDateToNull(Dep), UDFLib.ConvertStringToNull(ArrivalTime), UDFLib.ConvertStringToNull(BerthingTime), UDFLib.ConvertStringToNull(DepartureTime) , txtPortRemark.Text, UDFLib.ConvertStringToNull(ddlOwnersAgent.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterAgent.SelectedValue) , Convert.ToInt32(GetSessionUserID()), Convert.ToInt32(chkWarRisk.Checked), Convert.ToInt32(chkShipCrane.Checked), PortCallStatus, PortLocation, bAutoDate); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } } //str = objPortCall.Ins_PortCall_Details(UDFLib.ConvertIntegerToNull(str)); } } catch (Exception ex) { string Error = ex.ToString(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { string Hide = "No"; if (chkHide.Checked == true) { Hide = "Yes"; } else { Hide = "No"; } string Action_On_Data_Form = null; string Status = null; int Retval = BLL_POLOG_Register.POLOG_Update_PO_Admin(UDFLib.ConvertIntegerToNull(txtSupplyID.Text.ToString()), UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue), UDFLib.ConvertStringToNull(ddlSupplier.SelectedValue), UDFLib.ConvertIntegerToNull(ddlTerms.SelectedValue), UDFLib.ConvertStringToNull(ddlCurrency.SelectedValue), UDFLib.ConvertStringToNull(ddlIssueBy.SelectedValue), UDFLib.ConvertStringToNull(ddlCharterParty.SelectedValue), UDFLib.ConvertStringToNull(ddlAccClassifictaion.SelectedValue), UDFLib.ConvertStringToNull(ddlAccountType.SelectedValue), UDFLib.ConvertStringToNull(ddlPOType.SelectedValue), UDFLib.ConvertStringToNull(ddlOwnerCode.SelectedValue), UDFLib.ConvertStringToNull(rdbPayment.SelectedValue), Hide, txtRemarks.Text.ToString(), Action_On_Data_Form, Status, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString())); string script = "alert(\"PO Log details have been successfully updated\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } catch { } { } }
protected void BindItems() { DateTime?sFromDate; DateTime?sToDate; if (ViewState["sFromDT"].ToString() == "") { sFromDate = null; } else { sFromDate = UDFLib.ConvertDateToNull(ViewState["sFromDT"]); } if (ViewState["sToDT"].ToString() == "") { sToDate = null; } else { sToDate = UDFLib.ConvertDateToNull(ViewState["sToDT"]); } int Record_count = 0; gvPortReport.DataSource = BLL_OPS_VoyageReports.Get_PortReportIndex(Convert.ToInt32(ViewState["iVesselID"]), sFromDate, sToDate, UDFLib.ConvertStringToNull(ViewState["Sort_Column"]), UDFLib.ConvertStringToNull(ViewState["Sort_Direction"]), UDFLib.ConvertIntegerToNull(ucCustomPagerItems.CurrentPageIndex), UDFLib.ConvertIntegerToNull(ucCustomPagerItems.PageSize), ref Record_count); gvPortReport.DataBind(); ucCustomPagerItems.CountTotalRec = Record_count.ToString(); ucCustomPagerItems.BuildPager(); }
public void BindSysVariableGrid() { 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()); } DataTable dt = objBLLSysVariable.Get_SysVariable_Search(txtNameFilter.Text != "" ? txtNameFilter.Text : null, UDFLib.ConvertStringToNull(ddlVariableTypeFilter.SelectedValue), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (dt.Rows.Count > 0) { gvVariable.DataSource = dt; gvVariable.DataBind(); } else { gvVariable.DataSource = dt; gvVariable.DataBind(); } }
public void BindDataItems() { int?ShowAllUser = (chkShowAll.Checked) ? UDFLib.ConvertIntegerToNull(0) : Convert.ToInt32(Session["userid"]); int?ShowActive = (chkShowActive.Checked) ? 1 : 0; int is_Fetch_Count = ucCustomPagerPO.isCountRecord; gvOrderList.DataSource = BLL_PURC_LOG.Get_Log_LogisticPO_List((DataTable)DDLFleet.SelectedValues, (DataTable)DDLVessel.SelectedValues, UDFLib.ConvertStringToNull(uc_SupplierList1.SelectedValue), UDFLib.ConvertStringToNull(txtPoNumber.Text), ShowAllUser, null, UDFLib.ConvertStringToNull(ViewState["LOG_STATUS"]), ucCustomPagerPO.CurrentPageIndex, ucCustomPagerPO.PageSize, ref is_Fetch_Count); gvOrderList.DataBind(); ucCustomPagerPO.CountTotalRec = is_Fetch_Count.ToString(); ucCustomPagerPO.BuildPager(); }
protected void ImgExpExcel_Click(object sender, EventArgs e) { 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()); } DataTable dt = objBLLSysVariable.Get_SysVariable_Search(txtNameFilter.Text != "" ? txtNameFilter.Text : null, UDFLib.ConvertStringToNull(ddlVariableTypeFilter.SelectedValue), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); string[] HeaderCaptions = { "Variable Type", "Variable Name", "Variable Code", "Variable Value", "Color Code" }; string[] DataColumnsName = { "Variable_Type", "Variable_Name", "Variable_Code", "VARIABLE_VALUE", "COLOR_CODE" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "System Variable", "System Variable", ""); }
public void BindALLRequistionsDetails() { using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase()) { DataTable dtAllRequisition = new DataTable(); switch (Request.QueryString["Type"]) { case "ALL": int Fetch_Count = ucCustomPagerAllStatus.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); string sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = (ViewState["SORTDIRECTION"].ToString()); } dtAllRequisition = objTechService.SelectAllRequisitionStages_New (UDFLib.ConvertStringToNull(Session["sFleet"]), UDFLib.ConvertStringToNull(Session["sVesselCode"]) , UDFLib.ConvertStringToNull(Session["sDeptType"]) , UDFLib.ConvertStringToNull(Session["sPurc_Dept"]) , UDFLib.ConvertStringToNull(Session["REQNUM"]) , UDFLib.ConvertStringToNull(Session["sPOType"]) , UDFLib.ConvertStringToNull(Session["sAccType"]) , UDFLib.ConvertStringToNull(Session["ReqsnType"]) , UDFLib.ConvertStringToNull(Session["sCatalogue"]) , UDFLib.ConvertDateToNull(Session["sFrom"]) , UDFLib.ConvertDateToNull(Session["sTO"]) , UDFLib.ConvertStringToNull(Session["sAccClass"]) , UDFLib.ConvertStringToNull(Session["dturgrcy"]) , UDFLib.ConvertStringToNull((Session["sReqsnStatus"])) , ucCustomPagerAllStatus.CurrentPageIndex, ucCustomPagerAllStatus.PageSize, ref Fetch_Count, sortbycoloumn, UDFLib.ConvertStringToNull(sortdirection)); //dtAllRequisition = objTechService.SelectAllRequisitionStages((DataTable)Session["sFleet"], (DataTable)Session["sVesselCode"], // (DataTable)Session["sDeptCode"], // UDFLib.ConvertStringToNull(Session["sDeptType"]), // UDFLib.ConvertStringToNull(Session["REQNUM"]), // UDFLib.ConvertIntegerToNull(Session["ReqsnType"]), // UDFLib.ConvertStringToNull(ddlReqsnStatus.SelectedValue), // ucCustomPagerAllStatus.CurrentPageIndex, // ucCustomPagerAllStatus.PageSize, // ref Fetch_Count, sortbycoloumn, sortdirection); if (ucCustomPagerAllStatus.isCountRecord == 1) { ucCustomPagerAllStatus.CountTotalRec = Fetch_Count.ToString(); ucCustomPagerAllStatus.BuildPager(); } break; } if (ddlReqsnStatus.SelectedValue != "") { Session["PURC_ReqsnStatusATAll"] = ddlReqsnStatus.SelectedValue; } Session["PURC_ReqsnStatusATAll"] = ""; rgdAllReqStatus.DataSource = dtAllRequisition; if (ViewState["NeedDataSource"].ToString() == "0") { rgdAllReqStatus.DataBind(); } string script = " var height = document.body.scrollHeight;parent.ResizeFromChild(height,'1');"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "resize" + DateTime.Now.Millisecond.ToString(), script, true); } }