//Delete protected void btnDelete_Click(object sender, EventArgs e) { try { int RetValue = BLL_ASL_Supplier.Evaluation_Data_Delete(UDFLib.ConvertIntegerToNull(ViewState["ReturnEvalutionID"].ToString()), UDFLib.ConvertStringToNull(Request.QueryString["Supp_ID"].ToString()), UDFLib.ConvertToInteger(GetSessionUserID())); string message = "alert('Evaluation Record Deleted.')"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); //BindSupplier(); string msgDraft = String.Format("parent.ReloadParent_ByButtonID();"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgDraft", msgDraft, true); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method is used to insert/update observation note details /// </summary> /// <param name="Mode">Mode of operation. Value is Add or Edit</param> public void VET_Ins_Observation_Note(string Mode) { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); if (Mode == "Add") { DataTable dtObservation = new DataTable(); dtObservation = objBLLIndx.VET_Ins_Observation_Note(UDFLib.ConvertToInteger(ViewState["Vetting_ID"].ToString()), UDFLib.ConvertToInteger(ddlQuestion.SelectedValue), UDFLib.ConvertToInteger(ddlType.SelectedValue), txtObsDescription.Text.Trim(), UDFLib.ConvertToInteger(ddlCategory.SelectedValue), UDFLib.ConvertIntegerToNull(ddlRiskLevel.SelectedValue), ddlStatus.SelectedItem.Text.Trim(), UDFLib.ConvertToInteger(Session["USERID"].ToString())); if (dtObservation.Rows.Count > 0) { hdnObservationId.Value = dtObservation.Rows[0]["Observation_ID"].ToString(); hdnQryStrObservationId.Value = dtObservation.Rows[0]["Observation_ID"].ToString(); ViewState["Observation_ID"] = hdnObservationId.Value; } string jsSqlError2 = "alert('Observation saved successfully.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError2", jsSqlError2, true); } else if (Mode == "Edit") { objBLLIndx.VET_Upd_Observation_Note(UDFLib.ConvertToInteger(ViewState["Observation_ID"].ToString()), UDFLib.ConvertToInteger(ViewState["Vetting_ID"].ToString()), UDFLib.ConvertToInteger(ddlQuestion.SelectedValue), UDFLib.ConvertToInteger(ddlType.SelectedValue), txtObsDescription.Text.Trim(), UDFLib.ConvertToInteger(ddlCategory.SelectedValue), UDFLib.ConvertIntegerToNull(ddlRiskLevel.SelectedValue), ddlStatus.SelectedItem.Text.Trim(), UDFLib.ConvertToInteger(Session["USERID"].ToString())); string jsSqlError2 = "alert('Observation updated successfully.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError2", jsSqlError2, true); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
protected void gvRelatedJob_RowCommand(object sender, GridViewCommandEventArgs e) { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); int OBSJobID = UDFLib.ConvertToInteger(e.CommandArgument.ToString()); int res = objBLLIndx.VET_Upd_UnlinkWorklistJobs(OBSJobID, UDFLib.ConvertToInteger(Session["USERID"].ToString())); VET_Get_ObsRelatedJobs(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { ViewState["FleetCode"] = ""; ViewState["Vessel_ID"] = ""; ViewState["Vetting_ID"] = ""; ViewState["Question_ID"] = ""; ViewState["Observation_ID"] = ""; ViewState["Vessel_Name"] = ""; ViewState["Vetting_Type_ID"] = ""; ViewState["Vetting_Type_Name"] = ""; ViewState["Mode"] = ""; if (Request.QueryString["FleetCode"] != null) { FleetCode = Request.QueryString["FleetCode"].ToString(); ViewState["FleetCode"] = Request.QueryString["FleetCode"].ToString(); } if (Request.QueryString["Vessel_ID"] != null) { Vessel_ID = Request.QueryString["Vessel_ID"].ToString(); ViewState["Vessel_ID"] = Request.QueryString["Vessel_ID"].ToString(); } if (Request.QueryString["Vessel_Name"] != null) { Vessel_Name = Request.QueryString["Vessel_Name"].ToString(); ViewState["Vessel_Name"] = Request.QueryString["Vessel_Name"].ToString(); } if (Request.QueryString["Vetting_Type_ID"] != null) { Vetting_Type_ID = Request.QueryString["Vetting_Type_ID"].ToString(); ViewState["Vetting_Type_ID"] = Request.QueryString["Vetting_Type_ID"].ToString(); } if (Request.QueryString["Vetting_Type_Name"] != null) { Vetting_Type_Name = Request.QueryString["Vetting_Type_Name"].ToString(); ViewState["Vetting_Type_Name"] = Request.QueryString["Vetting_Type_Name"].ToString(); } if (Request.QueryString["Vetting_ID"] != null) { Vetting_ID = Request.QueryString["Vetting_ID"].ToString(); ViewState["Vetting_ID"] = Request.QueryString["Vetting_ID"].ToString(); } if (Request.QueryString["Question_ID"] != null) { Question_ID = Request.QueryString["Question_ID"].ToString(); ViewState["Question_ID"] = Request.QueryString["Question_ID"].ToString(); } if (Request.QueryString["Observation_ID"] != null) { Observation_ID = Request.QueryString["Observation_ID"].ToString(); hdnQryStrObservationId.Value = Observation_ID; ViewState["Observation_ID"] = Request.QueryString["Observation_ID"].ToString(); Mode = "Edit"; } if (!string.IsNullOrWhiteSpace(Convert.ToString(Request.QueryString["Mode"]))) { Mode = Request.QueryString["Mode"].ToString(); ViewState["Mode"] = Request.QueryString["Mode"].ToString(); } if (!string.IsNullOrWhiteSpace(Convert.ToString(Request.QueryString["Vetting_Status"]))) { Vetting_Status = Request.QueryString["Vetting_Status"].ToString(); } if (!string.IsNullOrWhiteSpace(Convert.ToString(Request.QueryString["Opn_Obs_Count"]))) { ViewState["Opn_Obs_Count"] = Request.QueryString["Opn_Obs_Count"].ToString(); lnkRelatedObs.Text = ViewState["Opn_Obs_Count"].ToString(); lnkRelatedObs.NavigateUrl = "Vetting_ObservationIndex.aspx?Question_ID=" + Question_ID + "&FleetCode=" + FleetCode + "&Vetting_Type_ID=" + Vetting_Type_ID + "&Status=Open" + "&Parent=AON"; if (lnkRelatedObs.Text == "0") { lnkRelatedObs.Enabled = false; } } VET_Get_SectionListByVettingId(); VET_Get_QuestionNoByVettingId(); VET_Get_ObservationCategories(); VET_Get_ObservationTypeList(); if (Mode == "Add") { txtObsDescription.Enabled = true; ImgUpdate.Enabled = false; ImgAddNewJob.Enabled = false; ImglnkJob.Enabled = false; ImgAddResponse.Enabled = false; dvbadge.Visible = false; } if (Mode == "Edit") { VET_Get_Observation(); //ImgAddNewJob.NavigateUrl = "../Worklist/AddNewJob.aspx?VID=" + ViewState["Vessel_ID"].ToString() + "&Vetting_ID=" + ViewState["Vetting_ID"].ToString() + "&Question_ID=" + ddlQuestion.SelectedValue + "&Observation_ID=" + ViewState["Observation_ID"].ToString() + "&WLID=0&OFFID=0"; //enable the edit button in read-only mode to view observation if (Vetting_Status == "Completed") { ImgAddNewJob.Enabled = false; ImglnkJob.Enabled = false; ImgAddResponse.Enabled = false; btnSave.Enabled = false; BtnSaveClose.Enabled = false; ImgAddResponse.Enabled = false; ImgUpdate.Enabled = false; } else { ImgAddNewJob.Enabled = true; ImglnkJob.Enabled = true; ImgAddResponse.Enabled = true; } dvbadge.Visible = true; ImglnkJob.Attributes.Add("onClick", "PopupAssignJob(" + Observation_ID + "," + Vessel_ID + ")"); UpdPnlAddObservation_Naote.Update(); } VET_Get_Response(); VET_Get_ObsRelatedJobs(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Method is used to get observation details for display /// </summary> public void VET_Get_Observation() { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); DataTable dtObs = objBLLIndx.VET_Get_Observation(UDFLib.ConvertToInteger(ViewState["Vetting_ID"].ToString()), UDFLib.ConvertToInteger(ViewState["Question_ID"].ToString()), UDFLib.ConvertToInteger(ViewState["Observation_ID"].ToString())); if (dtObs.Rows.Count > 0) { if (Convert.ToString(dtObs.Rows[0]["Section_No"]) != "") { ddlSection.ClearSelection(); ddlSection.Items.FindByText(Convert.ToString(dtObs.Rows[0]["Section_No"])).Selected = true; } if (Convert.ToString(dtObs.Rows[0]["Question_No"]) != "") { VET_Get_QuestionByVettingId_SectionNo(); ddlQuestion.ClearSelection(); ddlQuestion.Items.FindByText(Convert.ToString(dtObs.Rows[0]["Question_No"])).Selected = true; } if (Convert.ToString(dtObs.Rows[0]["Category"]) != "") { ddlCategory.ClearSelection(); ddlCategory.Items.FindByText(Convert.ToString(dtObs.Rows[0]["Category"])).Selected = true; } if (Convert.ToString(dtObs.Rows[0]["Risk_Level"]) != "") { ddlRiskLevel.ClearSelection(); ddlRiskLevel.Items.FindByText(Convert.ToString(dtObs.Rows[0]["Risk_Level"])).Selected = true; } if (Convert.ToString(dtObs.Rows[0]["Status"]) != "") { ddlStatus.ClearSelection(); ddlStatus.Items.FindByText(Convert.ToString(dtObs.Rows[0]["Status"])).Selected = true; } if (Convert.ToString(dtObs.Rows[0]["ObsType"]) != "") { ddlType.ClearSelection(); ddlType.Items.FindByText(Convert.ToString(dtObs.Rows[0]["ObsType"])).Selected = true; } if (Convert.ToString(dtObs.Rows[0]["ObsDescription"]) != "") { txtObsDescription.Text = dtObs.Rows[0]["ObsDescription"].ToString(); } if (Convert.ToString(dtObs.Rows[0]["Question"]) != "") { lblQuestion.Text = dtObs.Rows[0]["Question"].ToString(); } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
public void BindUserApproval() { 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 = objBLLAppLimit.Get_Approval_Limit_Search(txtfilter.Text != "" ? txtfilter.Text : null, UDFLib.ConvertIntegerToNull(DDLGroupFilter.SelectedValue) , UDFLib.ConvertIntegerToNull(DDLUserFilter.SelectedValue), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } gvUserType.DataSource = dt; gvUserType.DataBind(); }
protected void gvVoyageReport_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { try { string TelegramType = DataBinder.Eval(e.Row.DataItem, "TELEGRAM_TYPE").ToString(); string wind = DataBinder.Eval(e.Row.DataItem, "WIND_FORCE").ToString(); string instructedspeed = DataBinder.Eval(e.Row.DataItem, "INSTRUCTED_SPEED").ToString(); string averagespeed = DataBinder.Eval(e.Row.DataItem, "AVERAGE_SPEED").ToString(); string stractualHO = DataBinder.Eval(e.Row.DataItem, "ACTUAL_HO_CONSMP").ToString(); string stractualDO = DataBinder.Eval(e.Row.DataItem, "ACTUAL_DO_CONSMP").ToString(); string strcpHO = DataBinder.Eval(e.Row.DataItem, "CP_HOCONS").ToString(); string strcpDO = DataBinder.Eval(e.Row.DataItem, "CP_DOCONS").ToString(); string strVesselID = DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString(); #region Format cells if (TelegramType.ToUpper() == "N") { e.Row.Cells[3].BackColor = System.Drawing.Color.Yellow; } else if (TelegramType.ToUpper() == "D") { e.Row.Cells[3].BackColor = System.Drawing.Color.Orange; } else if (TelegramType.ToUpper() == "A") { e.Row.Cells[3].BackColor = System.Drawing.Color.YellowGreen; } else if (TelegramType.ToUpper() == "P") { e.Row.Cells[3].CssClass = "PurpleFinder-css"; e.Row.Cells[3].ForeColor = System.Drawing.Color.Black; } double WindForce = 0.0; if (double.TryParse(wind, out WindForce)) { if (WindForce >= 5) { e.Row.Cells[8].CssClass = "RedCell"; } } double AvgSpeed = 0.0; double InsSpeed = 0.0; if (double.TryParse(averagespeed, out AvgSpeed) && double.TryParse(instructedspeed, out InsSpeed)) { if (AvgSpeed < InsSpeed) { e.Row.Cells[10].CssClass = "RedCell"; } } double ActualHO = 0.0; double CPHO = 0.0; if (double.TryParse(stractualHO, out ActualHO) && double.TryParse(strcpHO, out CPHO)) { if (ActualHO > CPHO) { e.Row.Cells[12].CssClass = "RedCell"; } } double ActualDO = 0.0; double CPDO = 0.0; if (double.TryParse(stractualDO, out ActualDO) && double.TryParse(strcpDO, out CPDO)) { if (ActualDO > CPDO) { e.Row.Cells[14].CssClass = "RedCell"; } } #endregion string strRowId = DataBinder.Eval(e.Row.DataItem, "pkid").ToString(); string strtype = DataBinder.Eval(e.Row.DataItem, "Telegram_Type").ToString(); for (int ix = 1; ix < e.Row.Cells.Count - 1; ix++) { string filters = Convert.ToString(ViewState["sReportType"]) + "~" + Convert.ToString(ViewState["iVesselID"]) + "~" + Convert.ToString(ViewState["iLocationID"]) + "~" + Convert.ToString(ViewState["sFromDT"]) + "~" + Convert.ToString(ViewState["sToDT"]) + "~" + Convert.ToString(ViewState["iFleetID"]); e.Row.Cells[ix].Attributes.Add("onclick", "showdetails('" + strRowId.Split(new char[] { '.' })[0] + "," + strtype + "," + filters + "')"); e.Row.Cells[ix].Attributes.Add("style", "cursor:pointer"); } #region check for low ROB bool stsLow = false; string strCPFlt = "Vessel_ID=" + strVesselID + " AND datatype like '%ROB%'"; string strVSLflt = "Vessel_ID=" + strVesselID + " AND pkid=" + strRowId; DataRow[] drVSLROB = dtVesselROB.Select(strVSLflt); DataRow[] drCPROB = dtCPROB.Select(strCPFlt); foreach (DataRow dr in drCPROB) { string DataCode = dr["Data_Code"].ToString().ToUpper().Trim(); decimal datavalue = decimal.Parse(dr["data_value"].ToString()); if (DataCode == "HO_ROB") { if (decimal.Parse(drVSLROB[0]["HO_ROB"].ToString()) < datavalue) { stsLow = true; break; } } else if (DataCode == "DO_ROB") { if (decimal.Parse(drVSLROB[0]["DO_ROB"].ToString()) < datavalue) { stsLow = true; break; } } else if (DataCode == "AECC_ROB") { if (decimal.Parse(drVSLROB[0]["AECC_ROB"].ToString()) < datavalue) { stsLow = true; break; } } else if (DataCode == "MECC_ROB") { if (decimal.Parse(drVSLROB[0]["MECC_ROB"].ToString()) < datavalue) { stsLow = true; break; } } else if (DataCode == "MECYL_ROB") { if (decimal.Parse(drVSLROB[0]["MECYL_ROB"].ToString()) < datavalue) { stsLow = true; break; } } else if (DataCode == "FW_ROB") { if (decimal.Parse(drVSLROB[0]["FW_ROB"].ToString()) < datavalue) { stsLow = true; break; } } } if (stsLow == true) { ((Label)e.Row.Cells[16].FindControl("lblLowrob")).Text = "YES"; //((Label)e.Row.Cells[14].FindControl("lblLowrob")).CssClass = "RedCell"; e.Row.Cells[16].CssClass = "RedCell"; } #endregion #region check for FW Cons if (TelegramType.ToUpper() == "N") { decimal FWCons = UDFLib.ConvertToDecimal(DataBinder.Eval(e.Row.DataItem, "FW_CONS").ToString()); decimal FWCPCons = UDFLib.ConvertToDecimal(DataBinder.Eval(e.Row.DataItem, "CP_FWCONS").ToString()); if (FWCPCons < FWCons) { e.Row.Cells[15].CssClass = "RedCell"; } } #endregion } catch (Exception ex) { } } }
public void BindAgentBank() { 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 = objBLL.Agent_Bank_Account_Search(txtfilter.Text != "" ? txtfilter.Text : null, UDFLib.ConvertIntegerToNull(ddlCurrencyFilter.SelectedValue), UDFLib.ConvertIntegerToNull(ddlManningOfficeFilter.SelectedValue), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (dt.Rows.Count > 0) { gvAgentBank.DataSource = dt; gvAgentBank.DataBind(); } else { gvAgentBank.DataSource = dt; gvAgentBank.DataBind(); } }
protected void cmdUpload_Click(object source, EventArgs e) { BLL_TRV_Attachment att = new BLL_TRV_Attachment(); try { if (IsPostBack) { if (Attach_Type.ToString().ToUpper() == "INVOICE") { SaveInvoice(); ddlAttachmentType.SelectedIndex = 0; txtInvAmount.Text = ""; txtInvNo.Text = ""; } if (flName.PostedFile.ContentLength > 0) { string sFileName, filePath; sFileName = System.Guid.NewGuid().ToString() + Path.GetExtension(flName.PostedFile.FileName); filePath = ConfigurationManager.AppSettings["TRV_UPLOAD_PATH"].ToString(); if (flName.PostedFile.ContentLength <= 3048000) { filePath = Server.MapPath("~/") + ConfigurationManager.AppSettings["TRV_UPLOAD_PATH"].ToString() + sFileName; flName.PostedFile.SaveAs(filePath); att.SaveAttchement(RequestID, Path.GetFileName(flName.PostedFile.FileName), sFileName, Attach_Type, "", Convert.ToInt32(Session["USERID"].ToString()), UDFLib.ConvertIntegerToNull(Request.QueryString["SUPPLIER_ID"])); } } } GetAttachment(RequestID, Attach_Type); } catch (UnauthorizedAccessException ex) { throw new Exception(ex.Message + "Permission to upload file denied"); } finally { att = null; } }
protected void SaveSupplierPort() { DataTable dtService = new DataTable(); dtService.Columns.Add("PKID"); dtService.Columns.Add("FKID"); dtService.Columns.Add("Value"); foreach (ListItem chkitem in chkPort.Items) { DataRow dr = dtService.NewRow(); dr["FKID"] = chkitem.Value; dr["Value"] = chkitem.Selected == true ? 1 : 0; dtService.Rows.Add(dr); } BLL_ASL_Supplier.ASL_Supplier_Port_Insert(UDFLib.ConvertStringToNull(UDFLib.ConvertStringToNull(Request.QueryString["Supp_ID"].ToString())), dtService, UDFLib.ConvertToInteger(GetSessionUserID())); }
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 = objBLL.Agent_Bank_Account_Search(txtfilter.Text != "" ? txtfilter.Text : null, UDFLib.ConvertIntegerToNull(ddlCurrencyFilter.SelectedValue), UDFLib.ConvertIntegerToNull(ddlManningOfficeFilter.SelectedValue) , sortbycoloumn, sortdirection, null, null, ref rowcount); string[] HeaderCaptions = { "Manning Office", "Beneficiary", "A/c No.", "Bank Currency", "Swift Code", "Bank Code", "Branch Code", "Bank Address" }; string[] DataColumnsName = { "COMPANY_NAME", "Beneficiary", "Acc_NO", "Currency_Code", "SwiftCode", "BANK_CODE", "BRANCH_CODE", "Bank_Address" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "AgentBankAccount", "Agent Bank Account"); }
//Send Mail protected void SendEmail(string Evaluationstatus, string Approve, string Reject) { try { int RetValue = BLL_ASL_Supplier.Evaluation_Send_Email(UDFLib.ConvertIntegerToNull(ViewState["ReturnEvalutionID"].ToString()), UDFLib.ConvertStringToNull(GetSuppID()), Evaluationstatus, UDFLib.ConvertIntegerToNull(GetSessionUserID()), Approve, Reject); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
//Final Approval Funcation protected void SaveFinalEvaluation(string EvaluationStatus, string Approve, string Reject) { try { string str1 = ""; if (chkUrgent.Checked == true) { str1 = "Yes"; } else { str1 = "No"; } int RetValue = BLL_ASL_Supplier.Evaluation_Data_Insert(UDFLib.ConvertIntegerToNull(ViewState["ReturnEvalutionID"].ToString()) , UDFLib.ConvertStringToNull(GetSuppID()), EvaluationStatus, UDFLib.ConvertStringToNull(ddlProposedStatus.SelectedItem), UDFLib.ConvertIntegerToNull(ddlforPeriod.SelectedValue), txtRemarks.Text, txtVerificationRemrks.Text, txtApprovalRemrks.Text, UDFLib.ConvertToInteger(GetSessionUserID()), UDFLib.ConvertToInteger(ddlApproverName.SelectedValue), UDFLib.ConvertToInteger(ddlFinalApproverName.SelectedValue), str1, Approve, Reject, txtSupplierDesc.Text.Trim()); ViewState["ReturnEvalutionID"] = RetValue; SaveSupplierScope(); SaveSupplierPort(); } catch { } { } }
protected void BindSupplier() { try { int? EvalID = UDFLib.ConvertIntegerToNull(GetEvaluation_ID()); string Supp_ID = GetSuppID(); txtSupplier_Code.Text = Supp_ID; DataSet ds = BLL_ASL_Supplier.Get_Supplier_Evaluation_List(UDFLib.ConvertStringToNull(Supp_ID), EvalID); if (ds.Tables[2].Rows.Count > 0) { txtSupplierCode.Text = ds.Tables[2].Rows[0]["Supplier_Code"].ToString(); txtType.Text = ds.Tables[2].Rows[0]["Supp_Type"].ToString(); txtSubType.Text = ds.Tables[2].Rows[0]["Counterparty_Type"].ToString(); txtStatus.Text = ds.Tables[2].Rows[0]["Supp_Status"].ToString(); txtCompanyName.Text = ds.Tables[2].Rows[0]["Register_Name"].ToString(); txtIncorporation.Text = ds.Tables[2].Rows[0]["Setup_Year"].ToString(); txtAddress.Text = ds.Tables[2].Rows[0]["Address"].ToString(); txtPhone.Text = ds.Tables[2].Rows[0]["Phone"].ToString(); txtEmail.Text = ds.Tables[2].Rows[0]["Email"].ToString(); txtFax.Text = ds.Tables[2].Rows[0]["Fax"].ToString(); txtPICName.Text = ds.Tables[2].Rows[0]["Contact_1"].ToString(); txtPICEmail.Text = ds.Tables[2].Rows[0]["Contact_1_Email"].ToString(); txtPICPhone.Text = ds.Tables[2].Rows[0]["Contact_1_Phone"].ToString(); txtRegistedData.Text = ds.Tables[2].Rows[0]["Record_Status"].ToString(); txtSupplierDesc.Text = ds.Tables[2].Rows[0]["Supplier_Description"].ToString(); if (ds.Tables[2].Rows[0]["Record_Status"].ToString() != "") { btnRegisteredData.Visible = true; } else { btnRegisteredData.Visible = false; } UserAccessTypeValidation(txtType.Text); BindApproverList(txtType.Text); } if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Evaluation_Status"].ToString() == "Approved") { ViewState["ReturnEvalutionID"] = 0; ClearControl(); } else if (ds.Tables[0].Rows[0]["Evaluation_Status"].ToString() == "Rejected") { ViewState["ReturnEvalutionID"] = 0; ClearControl(); } else { ViewState["ReturnEvalutionID"] = ds.Tables[0].Rows[0]["Evaluation_ID"].ToString(); if (ds.Tables[0].Rows[0]["Supp_Status"].ToString() != "") { ddlProposedStatus.SelectedValue = ds.Tables[0].Rows[0]["Supp_Status"].ToString(); } txtSupplierDesc.Text = ds.Tables[0].Rows[0]["Supplier_Description"].ToString(); ddlforPeriod.SelectedValue = ds.Tables[0].Rows[0]["Approval_Period"].ToString(); txtRemarks.Text = ds.Tables[0].Rows[0]["Justification_Remarks"].ToString(); txtVerificationRemrks.Text = ds.Tables[0].Rows[0]["Verifier_Remarks"].ToString(); txtApprovalRemrks.Text = ds.Tables[0].Rows[0]["Approver_Remarks"].ToString(); txtCreatedDate.Text = ds.Tables[0].Rows[0]["Created_Date"].ToString(); txtApprovedDate.Text = ds.Tables[0].Rows[0]["Approved_Date"].ToString(); txtFinalApprovedDate.Text = ds.Tables[0].Rows[0]["FinalApproved_Date"].ToString(); if (ddlApproverName.Items.FindByValue(ds.Tables[0].Rows[0]["SentForApproval"].ToString()) == null) { ddlApproverName.SelectedValue = "0"; } else { ddlApproverName.SelectedValue = ds.Tables[0].Rows[0]["SentForApproval"].ToString(); } if (ddlFinalApproverName.Items.FindByValue(ds.Tables[0].Rows[0]["SentForfinalApproval"].ToString()) == null) { ddlFinalApproverName.SelectedValue = "0"; } else { ddlFinalApproverName.SelectedValue = ds.Tables[0].Rows[0]["SentForfinalApproval"].ToString(); } lblEvalStatus.Text = ds.Tables[0].Rows[0]["Evaluation_Status"].ToString(); lblCreatedby.Text = ds.Tables[0].Rows[0]["Created_Name"].ToString(); txtEvalID.Text = ds.Tables[0].Rows[0]["Evaluation_ID"].ToString(); string str = ds.Tables[0].Rows[0]["Urgent_Flag"].ToString(); if (str == "Yes") { chkUrgent.Checked = true; } else { chkUrgent.Checked = false; } btnSaveEvalution.Visible = true; btnVerify.Visible = true; } Visibelbutton(false); if (ds.Tables[0].Rows[0]["Evaluation_Status"].ToString() == "Rework") { if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["Created_By"].ToString())) { EnableDisable(true); btnSaveEvalution.Visible = true; btnVerify.Visible = true; txtRemarks.Enabled = true; txtApprovalRemrks.Enabled = false; txtVerificationRemrks.Enabled = false; } } else if (ds.Tables[0].Rows[0]["Evaluation_Status"].ToString() == "DRAFT") { if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["Created_By"].ToString())) { btnDelete.Visible = true; } else { btnDelete.Visible = false; } EnableDisable(true); txtApprovalRemrks.Enabled = false; txtVerificationRemrks.Enabled = false; txtRemarks.Enabled = true; btnSaveEvalution.Visible = true; btnVerify.Visible = true; btnRecallVerification.Visible = false; btnRework.Visible = false; btnRejected.Visible = false; btnRecallApproval.Visible = false; btnApproval.Visible = false; btnRecallApproval.Visible = false; } else if (ds.Tables[0].Rows[0]["Evaluation_Status"].ToString() == "Approval") { btnDelete.Visible = false; btnSaveEvalution.Visible = false; btnVerify.Visible = false; if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["Created_By"].ToString())) { EnableDisable(false); btnRecallVerification.Visible = true; //if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["SentForApproval"].ToString())) //{ // btnRecallVerification.Visible = true; //} //else //{ // btnRecallVerification.Visible = true; //} } else { EnableDisable(false); btnRecallVerification.Visible = true; btnforApproval.Visible = true; btnRework.Visible = true; btnforApproval.Enabled = false; btnRework.Enabled = false; } if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["SentForApproval"].ToString())) { txtVerificationRemrks.Enabled = true; btnforApproval.Visible = true; btnRework.Visible = true; ddlApproverName.Enabled = false; btnRecallApproval.Visible = false; btnforApproval.Enabled = true; btnRework.Enabled = true; } else { btnforApproval.Visible = true; btnRework.Visible = true; btnforApproval.Enabled = false; btnRework.Enabled = false; } } else if (ds.Tables[0].Rows[0]["Evaluation_Status"].ToString() == "FinalApproval") { btnDelete.Visible = false; btnSaveEvalution.Visible = false; btnVerify.Visible = false; btnRecallVerification.Visible = false; if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["Created_By"].ToString())) { EnableDisable(false); } else { EnableDisable(false); btnRecallApproval.Visible = false; } if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["SentForApproval"].ToString())) { EnableDisable(false); btnRecallApproval.Visible = true; btnforApproval.Visible = false; btnRework.Visible = false; } else { btnApproval.Visible = true; btnRejected.Visible = true; btnApproval.Enabled = false; btnRejected.Enabled = false; } if (UDFLib.ConvertToInteger(GetSessionUserID()) == UDFLib.ConvertToInteger(ds.Tables[0].Rows[0]["SentForfinalApproval"].ToString())) { //EnableDisable(true); txtApprovalRemrks.Enabled = true; btnApproval.Visible = true; btnApproval.Enabled = true; btnRejected.Enabled = true; btnRejected.Visible = true; //btnRecallApproval.Visible = false; } else { btnApproval.Visible = true; btnRejected.Visible = true; btnApproval.Enabled = false; btnRejected.Enabled = false; } } } else { ClearControl(); } if (ds.Tables[1].Rows.Count > 0) { dvEvalProgress.Visible = true; gvEvalProgress.DataSource = ds.Tables[1]; gvEvalProgress.DataBind(); } else { dvEvalProgress.Visible = false; gvEvalProgress.DataSource = ds.Tables[1]; gvEvalProgress.DataBind(); } } catch { } { } }
protected void btnsave_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("User_ID", typeof(Int16)); dt.Columns.Add("MAX_APPROVAL_LIMIT", typeof(decimal)); int UserId; int UserSelectedCount = 0; decimal MAX_APPROVAL_LIMIT; bool Selected; string js = ""; string ApproverType = ddlType.SelectedValue; ArrayList ApproverAmount = new ArrayList(); AmountApplicable = objBLLAppLimit.CheckAmountApplicable(ddlType.SelectedValue.ToString(), AmountApplicable); foreach (GridViewRow dr in gvUserApprovalList.Rows) { Selected = ((CheckBox)dr.FindControl("chkSelected")).Checked; if (Selected == true) { UserSelectedCount++; UserId = int.Parse(((Label)dr.FindControl("lblUserId")).Text.ToString()); if (AmountApplicable == 1) { if (((TextBox)dr.FindControl("txtAmount")).Text.ToString() != "") { MAX_APPROVAL_LIMIT = decimal.Parse(((TextBox)dr.FindControl("txtAmount")).Text.ToString()); if (ApproverType == "AdvanceApprover") { if (ApproverAmount.Contains(MAX_APPROVAL_LIMIT)) { js = "alert('There can be only one approver with specific amount');"; break; } ApproverAmount.Add(MAX_APPROVAL_LIMIT); } } else { MAX_APPROVAL_LIMIT = 0; } if (MAX_APPROVAL_LIMIT == 0) { js = "alert('Approval Limit is mandatory');"; break; } } else { MAX_APPROVAL_LIMIT = 0; } dt.Rows.Add(UserId, MAX_APPROVAL_LIMIT); } } if (UserSelectedCount == 0) { js = "alert('Select user for approval');"; } if (js == "") { int responseid = objBLLAppLimit.INS_Approval_Limit(UDFLib.ConvertIntegerToNull(DDLGroup.SelectedValue), ddlType.SelectedValue.ToString(), dt, Convert.ToInt32(Session["USERID"])); BindUserApproval(); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "status", js, true); string AddUserTypemodal = String.Format("showModal('divadd',false);"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddUserTypemodal", AddUserTypemodal, true); } }
protected void Page_Load(object sender, EventArgs e) { UserAccessValidation(); RequestID = Convert.ToInt32(Request.QueryString["requestid"].ToString()); dvInvoice.Visible = false; if (!IsPostBack) { Attach_Type = UDFLib.ConvertStringToNull(Request.QueryString["AttType"]); if (Attach_Type != null) { ListItem liAttch = ddlAttachmentType.Items.FindByValue(Attach_Type); if (liAttch != null) { liAttch.Selected = true; } if (liAttch.Value == "INVOICE") { dvInvoice.Visible = true; } else { dvInvoice.Visible = false; } } if (UDFLib.ConvertStringToNull((Request.QueryString["REQSTS"])) == "APPROVED") { ddlAttachmentType.ClearSelection(); ddlAttachmentType.Items.FindByValue("ETICKET").Selected = true; } //string CkeckForInvoce = String.Format("CkeckForInvoce();"); //ScriptManager.RegisterStartupScript(Page, Page.GetType(), "CkeckForInvoce", CkeckForInvoce, true); } Attach_Type = ddlAttachmentType.SelectedValue; if (Attach_Type == "ETICKET") { lblhdrAttach.Visible = false; flName.Visible = false; cmdUpload.Visible = false; } else { lblhdrAttach.Visible = true; flName.Visible = true; cmdUpload.Visible = true; } GetAttachment(RequestID, Attach_Type); }
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 = objBLLAppLimit.Get_Approval_Limit_Search(txtfilter.Text != "" ? txtfilter.Text : null, UDFLib.ConvertIntegerToNull(DDLGroupFilter.SelectedValue) , UDFLib.ConvertIntegerToNull(DDLUserFilter.SelectedValue), sortbycoloumn, sortdirection , null, null, ref rowcount); string[] HeaderCaptions = { "Group Name", "User Name", "Approval Limit" }; string[] DataColumnsName = { "Group_Name", "UserName", "MAX_APPROVAL_LIMIT" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "ApprovalLimit", "Approval Limit", ""); }
/// <summary> /// To save or update oil major /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnsave_OnClick(object sender, EventArgs e) { try { if (Convert.ToInt32(hdnOilMajorID.Value) > 0) { OperationMode = "Edit Oil Major"; int rowcount = 0; DataSet dt = objBLL.CRUD_OilMajorsRules(txtOilMajorName.Text.Trim(), "U", GetSessionUserID(), Convert.ToInt32(hdnOilMajorID.Value), null, "", null, null, null, ref rowcount, ref Result); ///Result == 2 Already exists if (Result < 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("InformationMessage/DataExists") + "');showModal('divadd', false);", true); } else if (Result > 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/UpdateMessage") + "');hideModal('divadd');", true); BindOilMajorsRules(); } } else { int rowcount = 0; DataSet dt = objBLL.CRUD_OilMajorsRules(txtOilMajorName.Text.Trim(), "I", GetSessionUserID(), 0, null, "", null, null, null, ref rowcount, ref Result); ///Result == 2 Already exists if (Result < 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("InformationMessage/DataExists") + "');showModal('divadd', false);", true); } else if (Result > 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/SaveMessage") + "');hideModal('divadd');", true); BindOilMajorsRules(); } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void BindItems() { string sFromDate = ""; string sToDate = ""; if (ViewState["sFromDT"].ToString() == "") { sFromDate = "1900/01/01"; } else { sFromDate = ViewState["sFromDT"].ToString(); } if (ViewState["sToDT"].ToString() == "") { sToDate = "1900/01/01"; } else { sToDate = ViewState["sToDT"].ToString(); } int Record_count = 0; gvVoyageReport.DataSource = BLL_OPS_VoyageReports.Get_VoyageReportIndex(ViewState["sReportType"].ToString(), Convert.ToInt32(ViewState["iVesselID"]), Convert.ToInt32(ViewState["iLocationID"]), sFromDate, sToDate, Convert.ToInt32(ViewState["iFleetID"]), UDFLib.ConvertIntegerToNull(ucCustomPagerItems.CurrentPageIndex), UDFLib.ConvertIntegerToNull(ucCustomPagerItems.PageSize), ref Record_count, UDFLib.ConvertStringToNull(ViewState["Sort_Column"]), UDFLib.ConvertStringToNull(ViewState["Sort_Direction"])); gvVoyageReport.DataBind(); ucCustomPagerItems.CountTotalRec = Record_count.ToString(); ucCustomPagerItems.BuildPager(); }
protected void onDelete(object source, CommandEventArgs e) { try { int rowcount = 0; DataSet dt = objBLL.CRUD_OilMajorsRules("", "D", GetSessionUserID(), Convert.ToInt32(e.CommandArgument.ToString()), null, "", null, null, null, ref rowcount, ref Result); if (Result > 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ShowMessage", "alert('" + UDFLib.GetException("SuccessMessage/DeleteMessage") + "')", true); } BindOilMajorsRules(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
public void GetRelatedOpenObservationCount(int QuestionID, int FleetCode) { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); DataTable dtOpenObsCount = objBLLIndx.VET_Get_RelatedOpenObsCount(); string filterpenexpression = filterpenexpression = " Question_ID=" + UDFLib.ConvertToInteger(QuestionID) + " and FleetCode=" + UDFLib.ConvertToInteger(FleetCode); DataRow[] drOpnObsCount = dtOpenObsCount.Select(filterpenexpression); if (drOpnObsCount.Length <= 0) { lnkRelatedObs.Text = "0"; lnkRelatedObs.Enabled = false; } else { lnkRelatedObs.Text = drOpnObsCount[0][0].ToString(); lnkRelatedObs.Enabled = true; } }
protected void btnSave_Click(object sender, EventArgs e) { int Res = BLL_PB_PortageBill.INS_Crew_Salary_Instruction(GetCrewID(), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), GetVoyageID(), UDFLib.ConvertToInteger(rdoEarndeduction.SelectedValue), txtPBDate.Text, UDFLib.ConvertToInteger(ddlType.SelectedValue), UDFLib.ConvertToDecimal(txtAmount.Text), txtRemarks.Text, GetSessionUserID()); Load_SalInstructions(); if (Res == 1) { lblMessage.Text = "Salary instruction added for the crew"; } }
protected void ddlQuestion_SelectedIndexChanged(object sender, EventArgs e) { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); if (ddlQuestion.SelectedValue != "0") { ViewState["ddlQuestionNo"] = ddlQuestion.SelectedValue; DataTable dtQuestionNo = objBLLIndx.VET_Get_QuestionByQuestionNo(UDFLib.ConvertToInteger(ViewState["ddlQuestionNo"].ToString())); if (dtQuestionNo.Rows.Count > 0) { if (Convert.ToString(dtQuestionNo.Rows[0]["Question"]) != "") { lblQuestion.Text = dtQuestionNo.Rows[0]["Question"].ToString(); } } GetRelatedOpenObservationCount(UDFLib.ConvertToInteger(ddlQuestion.SelectedValue), UDFLib.ConvertToInteger(ViewState["FleetCode"].ToString())); dvbadge.Visible = true; lnkRelatedObs.Enabled = true; lnkRelatedObs.NavigateUrl = "Vetting_ObservationIndex.aspx?Question_ID=" + ddlQuestion.SelectedValue + "&FleetCode=" + ViewState["FleetCode"].ToString() + "&Vetting_Type_ID=" + ViewState["Vetting_Type_ID"].ToString() + "&Status=Open" + "&Parent=AON"; } else { lblQuestion.Text = ""; dvbadge.Visible = false; lnkRelatedObs.Enabled = false; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
//protected void ImgAdd_Click(object sender, EventArgs e) //{ // this.SetFocus("ctl00_MainContent_txtApprovalGroup"); // HiddenFlag.Value = "Add"; // OperationMode = "Add Approval Group"; // txtApprovalGroup.Text = ""; // string AddUserTypemodal = String.Format("showModal('divadd',false);"); // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddUserTypemodal", AddUserTypemodal, true); //} //protected void btnsave_Click(object sender, EventArgs e) //{ // if (HiddenFlag.Value == "Add") // { // int responseid = objBLLAppGroup.INS_Approval_Group(txtApprovalGroup.Text, Convert.ToInt32(Session["USERID"])); // } // else // { // int responseid = objBLLAppGroup.Upd_Approval_Group(Convert.ToInt32(txtGroupID.Text), txtApprovalGroup.Text, Convert.ToInt32(Session["USERID"])); // } // BindApprovalGroup(); // string hidemodal = String.Format("hideModal('divadd')"); // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); //} //protected void onUpdate(object source, CommandEventArgs e) //{ // HiddenFlag.Value = "Edit"; // OperationMode = "Edit Approval Group"; // DataTable dt = new DataTable(); // dt = objBLLAppGroup.Get_Approval_Group_List_DL(Convert.ToInt32(e.CommandArgument.ToString())); // dt.DefaultView.RowFilter = "Group_ID= '" + e.CommandArgument.ToString() + "'"; // txtGroupID.Text = dt.DefaultView[0]["Group_ID"].ToString(); // txtApprovalGroup.Text = dt.DefaultView[0]["Group_Name"].ToString(); // string AddUserTypemodal = String.Format("showModal('divadd',false);"); // ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddUserTypemodal", AddUserTypemodal, true); //} protected void onDelete(object source, CommandEventArgs e) { int retval = BLL_POLOG_Lib.Del_Approval_Group(UDFLib.ConvertStringToNull(e.CommandArgument.ToString()), Convert.ToInt32(Session["USERID"])); BindApprovalGroup(); }
/// <summary> /// Method is used to get observation related worklist jobs of particular vetting and observation. /// </summary> public void VET_Get_ObsRelatedJobs() { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); DataSet ds = new DataSet(); ds = objBLLIndx.VET_Get_ObsRelatedJobs(UDFLib.ConvertToInteger(ViewState["Vetting_ID"].ToString()), UDFLib.ConvertToInteger(ViewState["Observation_ID"].ToString())); if (ds != null) { gvRelatedJob.DataSource = ds.Tables[0]; gvRelatedJob.DataBind(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
protected void ImgExpExcel_Click(object sender, ImageClickEventArgs e) { int rowcount = int.Parse(ucCustomPagerItems.CountTotalRec); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataTable dt = objBLL.Get_SlopChestConsumptionReport(txtDate.Text != "" ? txtDate.Text : null, txtCrew.Text.Trim() != "" ? txtCrew.Text.Trim() : null, UDFLib.ConvertIntegerToNull(ddItem.SelectedValue), 1, rowcount, ref rowcount); string[] HeaderCaptions = { "Date", "Crew", "Item Description", "Item Price", "Quantity", "Final Amount" }; string[] DataColumnsName = { "DATE", "CrewDetail", "ITEM", "PRICE", "QUANTITY", "FINAL_AMOUNT" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "SlopChest Consumpsion Report", "SlopChest Consumpsion Report", ""); }
protected void gvRelatedJob_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { Label lblDateRaised = (Label)e.Row.FindControl("lblDateRaised"); HiddenField hdnWLID = (HiddenField)e.Row.FindControl("hdnWLID"); HiddenField hdnOFFID = (HiddenField)e.Row.FindControl("hdnOFFID"); HiddenField hdnVID = (HiddenField)e.Row.FindControl("hdnVID"); lblDateRaised.Text = UDFLib.ConvertUserDateFormat(lblDateRaised.Text, UDFLib.GetDateFormat()); HyperLink lnkVerJobsCnt = (HyperLink)e.Row.FindControl("lnkVerJobsCnt"); lnkVerJobsCnt.NavigateUrl = "../Worklist/ViewJob.aspx?Vetting_ID=" + ViewState["Vetting_ID"].ToString() + "&WLID=" + hdnWLID.Value + "&OFFID=" + hdnOFFID.Value + "&VID=" + hdnVID.Value; if (Vetting_Status == "Completed") { ImageButton ImglnkJob = (ImageButton)e.Row.FindControl("ImglnkJob"); ImglnkJob.Enabled = false; } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
public void BindConsumption() { int rowcount = ucCustomPagerItems.isCountRecord; //int comID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"]); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } //DataTable dt = objBLL.SearchCompany(txtfilter.Text != "" ? txtfilter.Text : null, UDFLib.ConvertIntegerToNull(ddlCompanyTypeFilter.SelectedValue), UDFLib.ConvertIntegerToNull(ddlCountryIncorpFilter.SelectedValue) // , UDFLib.ConvertIntegerToNull(ddlCurrencyFilter.SelectedValue), UDFLib.ConvertIntegerToNull(ddlCountryFilter.SelectedValue), sortbycoloumn, sortdirection // , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); DataTable dt = objBLL.Get_SlopChestConsumptionReport(txtDate.Text != "" ? txtDate.Text:null, txtCrew.Text.Trim() != "" ? txtCrew.Text.Trim() : null, UDFLib.ConvertIntegerToNull(ddItem.SelectedValue), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); //UDFLib.ConvertIntegerToNull(ddlYearFilter.SelectedItem.Text) if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } if (dt.Rows.Count != 0) { GvSCDisplayConsumption.DataSource = dt; GvSCDisplayConsumption.DataBind(); } else { GvSCDisplayConsumption.DataSource = dt; GvSCDisplayConsumption.DataBind(); } }
public void VET_Get_QuestionByVettingId_SectionNo() { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); ddlQuestion.DataSource = objBLLIndx.VET_Get_QuestionByVettingId_SectionNo(UDFLib.ConvertToInteger(ViewState["Vetting_ID"].ToString()), UDFLib.ConvertToInteger(ddlSection.SelectedValue), ViewState["Mode"].ToString()); ddlQuestion.DataTextField = "Question_No"; ddlQuestion.DataValueField = "ID"; ddlQuestion.DataBind(); ddlQuestion.Items.Insert(0, new ListItem("-Select-", "0")); }
protected void btnSaveCommand_Click(object sender, EventArgs e) { try { int PROCEDURE_ID = BLL_QMSDB_Procedures.QMSDBProcedures_InsertWithSection(txtProcedureCode.Text, txtProcedureName.Text, UDFLib.ConvertToInteger(ddlFolderName.SelectedValue), FileWateMark.Checked == true ? 1 : 0, UDFLib.ConvertIntegerToNull(ddlHeaderTemplate.SelectedValue), UDFLib.ConvertIntegerToNull(ddlFooterTemlate.SelectedValue), UDFLib.ConvertToInteger(Session["USERID"]), ""); if (PROCEDURE_ID > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "reloadparent", "parent.RealoadParent();", true); ResponseHelper.Redirect("ProcedureBuilder.aspx?PROCEDURE_ID=" + PROCEDURE_ID.ToString(), "blank", ""); } } catch (Exception ex) { string js = "alert('" + ex.Message.Replace("'", "") + "');"; Page.ClientScript.RegisterStartupScript(GetType(), "script", js, true); } }