public string Get_FAQ_List(string SearchFaq, int?Page_Index, int?Page_Size, string TableStyleCSS, string HeaderStyleCSS, string QuestionCSS, string AnswerCSS, int Edit) { int is_Fetch_Count = 1; DataTable dt = BLL_LMS_FAQ.Get_FAQ_List(UDFLib.ConvertStringToNull(SearchFaq), UDFLib.ConvertIntegerToNull(Page_Index), UDFLib.ConvertIntegerToNull(Page_Size), ref is_Fetch_Count).Tables[0]; string result = CreateFAQListFromDataTable(dt, TableStyleCSS, HeaderStyleCSS, QuestionCSS, AnswerCSS, Edit); return(result + "~totalrecordfound~" + is_Fetch_Count.ToString()); }
public bool check(string s, string a) { //DataTable dt = BLL_LMS_FAQ.Check_Faq_List(s,a); DataTable dt = BLL_LMS_FAQ.Check_Faq_List(s, a, UDFLib.ConvertToInteger(ddlTopic.SelectedValue)); if (dt.Rows.Count > 0) { return(false); } else { return(true); } }
protected void btnPublishToCrew_Click(object sender, EventArgs e) { int ItemId = 0; string sFileName = "CTRN_" + Guid.NewGuid().ToString() + ".pdf"; string htmlStr = ""; string Question = ""; string Answer = ""; if (Get_FAQ_ID() > 0) { DataTable dt = BLL_LMS_FAQ.Get_FAQ_Details(Get_FAQ_ID()); Question = Convert.ToString(dt.Rows[0]["Question"]); Answer = Convert.ToString(dt.Rows[0]["Answer"]); htmlStr += "<table style='width:100%' ><tr><td style='font-size:14;color:navy;font-family:verdana;border-bottom:1px solid black' ><b> " + Question + "</b></td> </tr> <tr> <td style='font-size:11;color:black;font-family:verdana' >" + Answer + "</td> </tr></table> "; string filePath = Server.MapPath("~/") + "Uploads\\TrainingItems\\" + sFileName; EO.Pdf.HtmlToPdf.Options.AfterRenderPage = new EO.Pdf.PdfPageEventHandler(On_AfterRenderPage); // This use For IIS EO.Pdf.HtmlToPdf.Options.BaseUrl = "http://" + HttpContext.Current.Request.Url.Host + "/"; //This use For Local machine EO.Pdf.HtmlToPdf.ConvertHtml(@"<html><head></head><body><div>" + htmlStr + "</div></body></html> ", filePath); if (Question.Length > 250) { Question = Question.Substring(0, 250); } int Result = BLL_LMS_Training.Ins_Training_Items(Question, null, "ARTICLE", "0", sFileName, sFileName, Convert.ToInt32(Session["USERID"]), 1, ref ItemId); string js = "alert(' FAQ published successfully! !');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert2", js, true); txtquestion.Text = string.Empty; txtProcedureSectionDetails.Content = string.Empty; } else { string js = "alert('Please save the FAQ to proceed!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert3", js, true); } }
protected void btnSave_FAQ_Click(object sender, EventArgs e) { //if (!check(txtquestion.Text.ToString(), (txtProcedureSectionDetails.Content))) //{ // string js = "alert('Faq Question AllReady Exist!');"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "alert9", js, true); // txtquestion.Focus(); // return; //} if (ddlModule.SelectedValue == "0") { string js2 = "alert('Please select Module to save FAQ!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert11", js2, true); ddlTopic.Focus(); return; } if (ddlTopic.SelectedValue == "0") { string js1 = "alert('Please select Topic to save FAQ!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert10", js1, true); ddlTopic.Focus(); return; } int FAQ_ID = Get_FAQ_ID(); string successmsg = ""; if (FAQ_ID == 0) { successmsg = "FAQ created successfully!"; } else { successmsg = "FAQ updated successfully!"; } int Sync_To_Vessel = 0; if (chkvessel.Checked) { Sync_To_Vessel = 1; } try { // Validate your data, if any //FAQ_ID = BLL_LMS_FAQ.Upd_Faq_Details(FAQ_ID, txtquestion.Text.Trim(), txtProcedureSectionDetails.Content, UDFLib.ConvertToInteger(Session["userid"])); FAQ_ID = BLL_LMS_FAQ.Upd_Faq_Details(FAQ_ID, txtquestion.Text.Trim(), txtProcedureSectionDetails.Content, UDFLib.ConvertToInteger(Session["userid"]), UDFLib.ConvertToInteger(ddlTopic.SelectedValue)); if (FAQ_ID > 0) { DataTable dt_FAQ_Attachments = new DataTable(); dt_FAQ_Attachments.Columns.Add("ID", typeof(Int32)); dt_FAQ_Attachments.Columns.Add("ATTACHMENT_NAME", typeof(String)); string[] FAQ_Attachs = txtProcedureSectionDetails.Content.Split(new string[] { "Uploads/FAQ/" }, StringSplitOptions.None); foreach (string Attach in FAQ_Attachs) { if (Attach.StartsWith("FAQ_", StringComparison.OrdinalIgnoreCase)) { DataRow dr = dt_FAQ_Attachments.NewRow(); dr["ID"] = FAQ_ID.ToString(); dr["ATTACHMENT_NAME"] = Attach.Substring(0, 44); dt_FAQ_Attachments.Rows.Add(dr); } } DataTable dtAttachToDelete = BLL_LMS_FAQ.Ins_Attachment(FAQ_ID, Convert.ToInt32(Session["userid"]), dt_FAQ_Attachments, Sync_To_Vessel); // delete file not in use foreach (DataRow drAttach in dtAttachToDelete.Rows) { File.Delete(HttpContext.Current.Server.MapPath("~/Uploads/FAQ/" + drAttach["ATTACHMENT_NAME"])); BLL_LMS_FAQ.Del_Faq_Attachment(Convert.ToString(drAttach["ATTACHMENT_NAME"]), Sync_To_Vessel); } btnPublishToCrew.Enabled = true; btnSave_FAQ.Visible = false; btn_Update_FAQ.Visible = true; string js = "alert('" + successmsg + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert1", js, true); btnSave_FAQ.Attributes.Add("OnClick", "self.close()"); } else { btnPublishToCrew.Enabled = false; string js = "alert('Question and Answer is mandatory field...!');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert2", js, true); } hdnFaq_Id.Value = UDFLib.ConvertToInteger(FAQ_ID).ToString(); } catch (Exception ee) { //"Error occured. " + ee.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindModule(); if (Request.QueryString["FAQ_ID"] != null) { DataTable dt = BLL_LMS_FAQ.Get_FAQ_Details(Convert.ToInt16(Request.QueryString["FAQ_ID"])); txtquestion.Text = Convert.ToString(dt.Rows[0]["Question"]); if (dt.Rows[0]["Sync_To_Vessel"].ToString() == "1") { chkvessel.Checked = true; } if (ddlModule.Items.FindByValue(dt.DefaultView[0]["Module_ID"].ToString()) != null) { ddlModule.SelectedValue = dt.DefaultView[0]["Module_ID"].ToString() != "" ? dt.DefaultView[0]["Module_ID"].ToString() : "0"; } else { ddlModule.SelectedValue = "0"; } BindTopic(); if (ddlTopic.Items.FindByValue(dt.DefaultView[0]["Topic_ID"].ToString()) != null) { ddlTopic.SelectedValue = dt.DefaultView[0]["Topic_ID"].ToString() != "" ? dt.DefaultView[0]["Topic_ID"].ToString() : "0"; } else { ddlTopic.SelectedValue = "0"; } hdnFaq_Id.Value = UDFLib.ConvertToInteger(Request.QueryString["FAQ_ID"]).ToString(); txtProcedureSectionDetails.Content = "<html><body>" + Convert.ToString(dt.Rows[0]["Answer"]) + "</body></html>"; btnSave_FAQ.Visible = false; btn_Update_FAQ.Visible = true; btnPublishToCrew.Enabled = true; btnAttach.Visible = true; } else { btnSave_FAQ.Visible = true; btn_Update_FAQ.Visible = false; btnPublishToCrew.Enabled = false; ListItem liselect = new ListItem("--Select--", "0", true); ddlTopic.Items.Clear(); ddlTopic.Items.Insert(0, liselect); ddlModule.SelectedValue = "0"; } Session["UploadsFiles_Name"] = ""; } string js = "initScripts();"; ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js, true); }