protected void btnPublish_Click(object sender, EventArgs e) { try { BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); DataSet ds = new DataSet(); ds = objBLLQuest.VET_Get_ExistQuestionForQuestionnaire(UDFLib.ConvertToInteger(ViewState["Questionnaire_ID"].ToString())); if (ds.Tables[0].Rows.Count == 0) { string jsSqlError2 = "alert('Add Question for this Questionnaire.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError2", jsSqlError2, true); } else { int res = objBLLQuest.VET_Upd_QuestionnaireStatus(ViewState["Version"].ToString(), ViewState["Number"].ToString(), Convert.ToInt32(Session["USERID"].ToString()), UDFLib.ConvertToInteger(ViewState["Questionnaire_ID"].ToString())); if (res > 0) { string jsSqlError3 = "alert('Questionnaire published.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError3", jsSqlError3, true); VET_Get_QuestionnaireDetails(); btnPublish.Enabled = false; btnSave.Enabled = false; } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
/// <summary> /// To bind Questionnaire details by ID /// </summary> public void VET_Get_QuestionnaireDetailsByID() { try { BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); DataTable dtAllFields = objBLLQuest.VET_Get_QuestionnaireDetailsByID(UDFLib.ConvertToInteger(ViewState["Questionnaire_ID"].ToString())); if (Convert.ToString(dtAllFields.Rows[0]["Module"]) != "") { txtModule.Text = dtAllFields.Rows[0]["Module"].ToString(); } if (Convert.ToString(dtAllFields.Rows[0]["VesselTypes"]) != "") { txtVesselType.Text = dtAllFields.Rows[0]["VesselTypes"].ToString(); } if (Convert.ToString(dtAllFields.Rows[0]["Name"]) != "") { txtQuestionnaire.Text = dtAllFields.Rows[0]["Name"].ToString(); } if (Convert.ToString(dtAllFields.Rows[0]["Vetting_Type_Name"]) != "") { txtVettingType.Text = dtAllFields.Rows[0]["Vetting_Type_Name"].ToString(); } if (Convert.ToString(dtAllFields.Rows[0]["Number"]) != "") { txtNumber.Text = dtAllFields.Rows[0]["Number"].ToString(); ViewState["Number"] = dtAllFields.Rows[0]["Number"].ToString(); } if (Convert.ToString(dtAllFields.Rows[0]["Version"]) != "") { txtVersion.Text = dtAllFields.Rows[0]["Version"].ToString(); ViewState["Version"] = dtAllFields.Rows[0]["Version"].ToString(); } if (Convert.ToString(dtAllFields.Rows[0]["Status"]) != "") { ViewState["Status"] = dtAllFields.Rows[0]["Status"].ToString(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
/// <summary> /// Get question no by section no /// </summary> public void VET_Get_QuestionNoBySectionNo() { try { BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); DDLQuestion.DataSource = objBLLQuest.VET_Get_QuestionNoBySectionNo(UDFLib.ConvertToInteger(ViewState["Questionnaire_ID"].ToString()), DDLSection.SelectedValues); DDLQuestion.DataTextField = "Question_No"; DDLQuestion.DataValueField = "ID"; DDLQuestion.DataBind(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
/// <summary> /// To change Questionnire status to 'Archived' /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void onDelete(object source, CommandEventArgs e) { Questionnaire_ID = Convert.ToInt32(e.CommandArgument); try { BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); int res = objBLLQuest.VET_Del_Questionnaire(Questionnaire_ID, Convert.ToInt32(Session["USERID"])); if (res > 0) { BindQuestionnaire(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
/// <summary> /// Bind all vetting Questionnaire /// </summary> public void BindQuestionnaire() { try { BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); DataSet ds = new DataSet(); 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()); } ds = objBLLQuest.VET_Get_Questionnaire(UDFLib.ConvertIntegerToNull(DDLModule.SelectedValue), DDLVeseelType.SelectedValues, DDLVetType.SelectedValues, DDLStatus.SelectedValues, txtNumber.Text != "" ? txtNumber.Text.Trim() : null, txtVersion.Text != "" ? txtVersion.Text.Trim() : null, txtQuestionnaire.Text != "" ? txtQuestionnaire.Text.Trim() : null, sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } gvQuestionnaire.DataSource = ds.Tables[0]; gvQuestionnaire.DataBind(); if (ds.Tables[0].Rows.Count > 0) { btnExport.Enabled = true; } else { btnExport.Enabled = false; } UpdPnlGrid.Update(); UpdPnlFilter.Update(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
/// <summary> /// To insert Questionnaire /// </summary> public void VET_Ins_Questionnaire() { try { string strQuestionnaireName = txtQuestionnaireName.Text.Trim(); string strNumber = txtNumber.Text.Trim(); string strVersion = txtVersion.Text.Trim(); BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); DataSet ds = new DataSet(); //DDLVesselType.SelectedValues added for multiple vessel type selection ds = objBLLQuest.VET_Get_ExistQuestinnaire(UDFLib.ConvertIntegerToNull(DDLModule.SelectedValue), UDFLib.ConvertIntegerToNull(DDLVetType.SelectedValue), DDLVesselType.SelectedValues, strNumber, strVersion); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { string jsSqlError2 = "alert('Questionnaire already exist.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError2", jsSqlError2, true); } else { DataTable dtQuestionnaire = new DataTable(); dtQuestionnaire = objBLLQuest.VET_Ins_Questionnaire(UDFLib.ConvertIntegerToNull(DDLModule.SelectedValue), UDFLib.ConvertIntegerToNull(DDLVetType.SelectedValue), DDLVesselType.SelectedValues, strQuestionnaireName, strNumber, strVersion, Convert.ToInt32(Session["USERID"])); if (dtQuestionnaire.Rows.Count > 0) { hdnQuestionnaireId.Value = dtQuestionnaire.Rows[0]["Questionnaire_ID"].ToString(); hdnQuestnirStatus.Value = dtQuestionnaire.Rows[0]["Status"].ToString(); } string jsSqlError2 = "alert('Questionnaire created.');"; 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); } }
/// <summary> /// Export to excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExport_Click(object sender, ImageClickEventArgs e) { try { BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); DataSet ds = new DataSet(); 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()); } ds = objBLLQuest.VET_Get_Questionnaire(UDFLib.ConvertIntegerToNull(DDLModule.SelectedValue), DDLVeseelType.SelectedValues, DDLVetType.SelectedValues, DDLStatus.SelectedValues, txtNumber.Text != "" ? txtNumber.Text.Trim() : null, txtVersion.Text != "" ? txtVersion.Text.Trim() : null, txtQuestionnaire.Text != "" ? txtQuestionnaire.Text.Trim() : null, sortbycoloumn, sortdirection, null, null, ref rowcount); string[] HeaderCaptions = { "Module", "Vetting Type", "Vessel Type", "Questionnaire Name", "Number", "Version", "Status" }; string[] DataColumnsName = { "Module", "Vetting_Type_Name", "Vessel_Type", "Questionnaire_Name", "Number", "Version", "Status" }; string FileName = "VettingQuestionnaire" + "_" + DateTime.Now.ToString("yyyy-MM-dd HH.mm.ss"); string FilePath = Server.MapPath(@"~/Uploads\\Temp\\"); string ExportTempFilePath = Server.MapPath(@"~/Uploads\\ExportTemplete\\"); if ((sender as ImageButton).CommandArgument == "ExportFrom_IE") { GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, FileName, "Vetting Questionnaire Index", ""); } else { GridViewExportUtil.Export_To_Excel_Interop(ds.Tables[0], HeaderCaptions, DataColumnsName, "Vetting Questionnaire", FilePath + FileName, ExportTempFilePath, @"~\\Uploads\\Temp\\" + FileName); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }
protected void btnSave_Click(object sender, EventArgs e) { try { BLL_VET_Questionnaire objBLLQuest = new BLL_VET_Questionnaire(); DataSet ds = new DataSet(); ds = objBLLQuest.VET_Get_VersionNumber(txtNumber.Text.Trim().ToString(), txtVersion.Text.Trim().ToString()); if (ds.Tables[0].Rows.Count > 0) { string jsSqlError2 = "alert('Version already exist.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError2", jsSqlError2, true); } else { DataTable dtQuestionnaire = new DataTable(); dtQuestionnaire = objBLLQuest.VET_Ins_NewVersionQuestionDetails(txtNumber.Text.Trim(), ViewState["Version"].ToString(), txtVersion.Text.Trim(), UDFLib.ConvertToInteger(ViewState["Questionnaire_ID"].ToString()), ViewState["Status"].ToString(), Convert.ToInt32(Session["USERID"])); if (dtQuestionnaire.Rows.Count > 0) { hfQuestionnaireID.Value = dtQuestionnaire.Rows[0]["Questionnaire_ID"].ToString(); ViewState["Questionnaire_ID"] = dtQuestionnaire.Rows[0]["Questionnaire_ID"].ToString(); UpdatePanel1.Update(); } string jsSqlError3 = "alert('Data saved successfully.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "jsSqlError3", jsSqlError3, true); VET_Get_QuestionnaireDetails(); } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }