public string Get_Topic_FAQList(int Topic_ID, int FAQ_ID, string Description, string TableStyleCSS, string QuestionCSS, string AnswerCSS, string TopicListCSS, string CategoryCss, int?Page_Index, int?Page_Size, int UserID)
{
int is_Fetch_Count = 1;
string result = "";
string mode = "";
int TopicID = 0;
int FAQID = 0;
string description = "";
if (Topic_ID != 0)
{
TopicID = Topic_ID;
mode = "Topic";
}
else if (FAQ_ID != 0)
{
FAQID = FAQ_ID;
mode = "FAQ";
}
else
{
description = Description;
mode = "Desc";
}
DataTable dtFAQ = BLL_FAQ_Item.Get_Topic_FAQList(UDFLib.ConvertIntegerToNull(TopicID), UDFLib.ConvertIntegerToNull(FAQID), description, UDFLib.ConvertIntegerToNull(Page_Index), UDFLib.ConvertIntegerToNull(Page_Size), ref is_Fetch_Count, UserID).Tables[0];
result = CreateFAQFromDataTable(mode, dtFAQ, TableStyleCSS, QuestionCSS, AnswerCSS, TopicListCSS, CategoryCss, Description, TopicID);
return(result + "~totalrecordfound~" + is_Fetch_Count.ToString());
}
protected void onUpdateTopic(object source, CommandEventArgs e)
{
int rowcount = ucCustomPagerItems.isCountRecord;
HiddenFlag.Value = "Edit";
OperationMode = "Edit Topic";
lblName.Text = "Topic Name :";
ddlModule.Visible = true;
lblModule.Visible = true;
td_Relation.Visible = true;
BindModule();
DataTable dt = new DataTable();
dt = BLL_FAQ_Item.Get_ModuleTopic_Details("", null, null, "Topic", Convert.ToInt32(e.CommandArgument.ToString()), null, ref rowcount).Tables[0];
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";
}
txtName.Text = dt.DefaultView[0]["Description"].ToString();
txtID.Text = dt.DefaultView[0]["Topic_ID"].ToString();
hdnMode.Value = "Topic";
string UpdateCompmodal = String.Format("showModal('divadd',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "UpdateCompmodal", UpdateCompmodal, true);
}
protected void FillItemType()
{
ListItem li0 = new ListItem("-- Select --", null);
ddlItemType.Items.Insert(0, li0);
ListItem li1 = new ListItem("RESOURCE", "1");
ddlItemType.Items.Insert(1, li1);
ListItem li2 = new ListItem("FBM", "2");
ddlItemType.Items.Insert(2, li2);
ListItem li3 = new ListItem("ARTICLE", "3");
ddlItemType.Items.Insert(3, li3);
ListItem li4 = new ListItem("VIDEO MATERIALS", "4");
ddlItemType.Items.Insert(4, li4);
ddlMenuLink.Items.Clear();
ddlMenuLink.DataTextField = "Menu_Link";
ddlMenuLink.DataValueField = "Menu_Link";
ddlMenuLink.DataSource = BLL_FAQ_Item.Get_Menu_Link().Tables[0];
ddlMenuLink.DataBind();
ListItem lim = new ListItem("--Select--", "0");
ddlMenuLink.Items.Insert(0, lim);
}
protected void BindChapterItem()
{
string Search_Text = txtSearchItemName.Text;
DataSet ds = BLL_FAQ_Item.Get_FAQ_Items(Convert.ToInt32(ViewState["FAQ_ID"]), UDFLib.ConvertStringToNull(Search_Text));
gvItemList.DataSource = ds;
gvItemList.DataBind();
}
public string Get_HelpPage(string TableStyleCSS, string HeaderStyleCSS, string QuestionCSS, string AnswerCSS, string Keywords, int CompanyID, string VideoCSS, string SearchUrl)
{
int is_Fetch_Count = 1;
DataSet ds = BLL_FAQ_Item.Get_HelpPage_List(null, ref is_Fetch_Count, null, null, Keywords, CompanyID, SearchUrl);
string result = CreateHelpPageListFromDataTable(ds, TableStyleCSS, HeaderStyleCSS, QuestionCSS, AnswerCSS, VideoCSS);
return(result + "~totalrecordfound~" + is_Fetch_Count.ToString());
}
protected void BindModule()
{
ddlModule.Items.Clear();
ddlModule.DataTextField = "Module_Description";
ddlModule.DataValueField = "Module_ID";
ddlModule.DataSource = BLL_FAQ_Item.Get_FAQModule_List().Tables[0];
ddlModule.DataBind();
ListItem li = new ListItem("--Select--", "0");
ddlModule.Items.Insert(0, li);
}
protected void onDeleteModule(object source, CommandEventArgs e)
{
//string Mode;
//if (rdoStatus.SelectedValue == "1")
// Mode = "Topic";
//else
// Mode = "Module";
// BLL_LMS_FAQ.Del_ModuleTopic(Mode, Convert.ToInt32(e.CommandArgument.ToString()), UDFLib.ConvertToInteger(Session["UserID"]));
// BindGrid();
BLL_FAQ_Item.Del_ModuleTopic("Module", Convert.ToInt32(e.CommandArgument.ToString()), UDFLib.ConvertToInteger(Session["UserID"]));
BindModuleGrid();
BindTopicGrid();
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (HiddenFlag.Value == "Add")
{
if (hdnMode.Value == "Topic")
{
int responseid = BLL_FAQ_Item.Update_ModuleTopic(txtName.Text.Trim(), null, "Topic", Convert.ToInt32(ddlModule.SelectedValue), UDFLib.ConvertToInteger(Session["UserID"]));
BindTopicGrid();
//if (responseid == -1)
//{
// string js1 = "alert('Topic name already exists');";
// ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser", js1, true);
//}
}
else
{
int responseid = BLL_FAQ_Item.Update_ModuleTopic(txtName.Text.Trim(), null, "Module", null, UDFLib.ConvertToInteger(Session["UserID"]));
BindModuleGrid();
//if (responseid == -1)
//{
// string js1 = "alert('Topic name already exists');";
// ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser", js1, true);
//}
}
}
else
{
if (hdnMode.Value == "Topic")
{
int responseid = BLL_FAQ_Item.Update_ModuleTopic(txtName.Text.Trim(), Convert.ToInt32(txtID.Text), "Topic", Convert.ToInt32(ddlModule.SelectedValue), UDFLib.ConvertToInteger(Session["UserID"]));
BindTopicGrid();
}
else
{
int responseid = BLL_FAQ_Item.Update_ModuleTopic(txtName.Text.Trim(), Convert.ToInt32(txtID.Text), "Module", null, UDFLib.ConvertToInteger(Session["UserID"]));
BindModuleGrid();
BindTopicGrid();
}
}
//BindGrid();
string hidemodal = String.Format("hideModal('divadd')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true);
}
protected void BindTopic()
{
ListItem liselect = new ListItem("--Select--", "0", true);
ddlTopic.Items.Clear();
if (ddlModule.SelectedValue != "0")
{
DataTable dtproj = BLL_FAQ_Item.Get_FAQTopic_List(Convert.ToInt32(ddlModule.SelectedValue)).Tables[0];
ddlTopic.DataSource = dtproj;
ddlTopic.DataValueField = "Topic_ID";
ddlTopic.DataTextField = "Description";
ddlTopic.DataBind();
}
ddlTopic.Items.Insert(0, liselect);
}
public string Get_FAQ_ModuleList(string TableStyleCSS, string ModuleCSS, string TopicListCSS)
{
int i = 0;
System.Text.StringBuilder strTable = new System.Text.StringBuilder();
DataTable dt = BLL_FAQ_Item.Get_FAQModule_List().Tables[0];
strTable.Append("<table id='__tbl_remark' CELLPADDING='2' CELLSPACING='0' style='border-collapse:collapse' ");
if (!string.IsNullOrWhiteSpace(TableStyleCSS))
{
strTable.Append(" class='" + TableStyleCSS + "' ");
}
strTable.Append(" > ");
strTable.Append("<tr>");
foreach (DataRow row in dt.Rows)
{
if (i < 3)
{
i = i + 1;
DataTable dtTopic = BLL_FAQ_Item.Get_FAQTopic_List(Convert.ToInt32(row["Module_ID"].ToString())).Tables[0];
strTable.Append("<td style='vertical-align:top; margin:1%; width:33.33%'>");
strTable.Append("<h2 class='" + ModuleCSS + "'>" + row["Module_Description"].ToString() + "</h2>");
strTable.Append("<ul class=\"" + TopicListCSS + "\">");
foreach (DataRow row1 in dtTopic.Rows)
{
strTable.Append("<li ><a style='color:#627A62;font-size:medium;text-decoration: none !important;' target=" + "_blank" + " href=\"LMS_Topic_List.aspx?Topic_ID=" + row1["Topic_ID"].ToString() + "\">" + row1["Description"].ToString() + "</a></li>");
}
strTable.Append("</ul></td>");
if (i == 3)
{
strTable.Append("</tr><tr>");
i = 0;
}
}
}
strTable.Append("</tr></table>");
return(strTable.ToString());
}
public void BindModuleGrid()
{
int rowcount = ucCustomPager1.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = BLL_FAQ_Item.Get_ModuleTopic_Details(""
, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, "Module", null, null, ref rowcount).Tables[0];
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
grdModule.DataSource = dt;
grdModule.DataBind();
}
protected void btnSaveandClose_Click(object sender, EventArgs e)
{
DataTable dtFAQ_Items = new DataTable();
dtFAQ_Items.Columns.Add("ID");
DataRow dr;
foreach (GridViewRow row in gvItemList.Rows)
{
CheckBox chkProjectAssigned = (row.Cells[0].FindControl("chkSelected") as CheckBox);
if (chkProjectAssigned.Checked)
{
dr = dtFAQ_Items.NewRow();
dr["ID"] = gvItemList.DataKeys[row.RowIndex].Value.ToString();
dtFAQ_Items.Rows.Add(dr);
}
}
int rs = BLL_FAQ_Item.Update_FAQ_Items(Convert.ToInt32(ViewState["FAQ_ID"]), dtFAQ_Items, UDFLib.ConvertIntegerToNull(Session["USERID"]));
string js = String.Format("parent.ReloadParent_ByButtonID();");
ScriptManager.RegisterStartupScript(this, this.GetType(), "ReloadParent", js, true);
}
public void BindTopicGrid()
{
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 = BLL_LMS_FAQ.Get_ModuleTopic_Details(txtfilter.Text != "" ? txtfilter.Text : null
// , ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, "Topic", null, UDFLib.ConvertIntegerToNull(ddlfltModule.SelectedValue), ref rowcount).Tables[0];
DataTable dt = BLL_FAQ_Item.Get_ModuleTopic_Details(""
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, "Topic", null, UDFLib.ConvertIntegerToNull(hdnModuleID.Value), ref rowcount).Tables[0];
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
grdTopic.DataSource = dt;
grdTopic.DataBind();
}
protected void onDeleteTopic(object source, CommandEventArgs e)
{
BLL_FAQ_Item.Del_ModuleTopic("Topic", Convert.ToInt32(e.CommandArgument.ToString()), UDFLib.ConvertToInteger(Session["UserID"]));
BindTopicGrid();
}
public int UpdateVideo_IsHelpful(int Video_ID, int IsHelpful, int UserID)
{
int i = BLL_FAQ_Item.Update_TrainingItem_IsHelpful(Video_ID, IsHelpful, UserID);
return(Video_ID);
}
public string ADDFAQ(int FAQ_ID, string Question, string Answer, int UserID, int TopicID, string Topic_Description, int ModuleID, string Module_Description)
{
BLL_FAQ_Item.Upd_Faq_ServiceDetails(FAQ_ID, Question, Answer, UserID, TopicID, Topic_Description, ModuleID, Module_Description);
return("true");
}
public string[] GetFAQDescList(string prefixText, int count)
{
BLL_FAQ_Item al = new BLL_FAQ_Item();
DataTable dt;
List <string> RetVal = new List <string>();
string strReturn;
try
{
dt = al.GetFAQDescList(prefixText).Tables[0];
dt.Rows.Cast <System.Data.DataRow>().Take(count);
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((dt.Rows[i]["Answer"].ToString().ToUpper()).Contains(prefixText.ToUpper()))
{
string strAnswer = dt.Rows[i]["Answer"].ToString().ToUpper();
int l = dt.Rows[i]["Answer"].ToString().IndexOf("<");
if (l > 0)
{
strReturn = dt.Rows[i]["Answer"].ToString().Substring(0, l);
if (!RetVal.Contains(strReturn))
{
RetVal.Add(strReturn);
}
}
else if ((dt.Rows[i]["Answer"].ToString()).Contains("<"))
{
strReturn = dt.Rows[i]["Answer"].ToString().Substring(strAnswer.IndexOf(prefixText.ToUpper()), strAnswer.IndexOf("<", strAnswer.IndexOf(prefixText.ToUpper())) - strAnswer.IndexOf(prefixText.ToUpper()));
if (!RetVal.Contains(strReturn))
{
RetVal.Add(strReturn);
}
}
else
{
strReturn = dt.Rows[i]["Answer"].ToString();
if (!RetVal.Contains(strReturn))
{
RetVal.Add(strReturn);
}
}
}
else if ((dt.Rows[i]["Question"].ToString().ToUpper()).Contains(prefixText.ToUpper()))
{
int l = dt.Rows[i]["Question"].ToString().IndexOf("<");
if (l > 0)
{
strReturn = dt.Rows[i]["Question"].ToString().Substring(0, l);
if (!RetVal.Contains(strReturn))
{
RetVal.Add(strReturn);
}
}
else
{
strReturn = dt.Rows[i]["Question"].ToString();
if (!RetVal.Contains(strReturn))
{
RetVal.Add(strReturn);
}
}
}
}
return(RetVal.ToArray());
}
catch { throw; }
finally { al = null; }
}
public int UpdateIsHelpful(int FAQ_ID, int IsHelpful, int UserID)
{
int i = BLL_FAQ_Item.Update_FAQ_List(FAQ_ID, IsHelpful, UserID);
return(FAQ_ID);
}
public static string CreateFAQFromDataTable(string mode, DataTable dtTable, string TableCss, string QuestionCSS, string AnswerCSS, string TopicListCSS, string CategoryCss, string Description, int TopicID)
{
System.Text.StringBuilder strTable = new System.Text.StringBuilder();
string title = "";
try
{
switch (mode.ToUpper())
{
case "TOPIC":
if (dtTable.Rows.Count > 0)
{
int icol = 0;
title = "Help/FAQ/" + dtTable.Rows[0]["Description"].ToString();
strTable.Append("<table id='__tbl_remark' CELLPADDING='2' CELLSPACING='0' style='border-collapse:collapse' ");
if (!string.IsNullOrWhiteSpace(TableCss))
{
strTable.Append(" class='" + TableCss + "' ");
}
strTable.Append(" > ");
strTable.Append("<tr class='" + QuestionCSS + "'><td>" + dtTable.Rows[0]["Module_Description"].ToString() + "/" + dtTable.Rows[0]["Description"].ToString() + "</td></tr>");
//Start Question TR
strTable.Append("<tr >");
strTable.Append("<td class=\"" + QuestionCSS + "-FAQ\">");
strTable.Append("<ul class=\"" + TopicListCSS + "\">");
foreach (DataRow dr in dtTable.Rows)
{
strTable.Append("<li id='ID" + dr["FAQ_ID"].ToString() + "' tabindex='1' onclick=\"javascript:Description('" + dr["FAQ_ID"].ToString() + "') \"><span style='color:#627A62;font-size:medium;'>" + dr["Question"].ToString() + "</span></li>");
//strTable.Append("<li><a style='color:#627A62;font-size:medium;text-decoration: none !important;' href=\"javascript:Description('" + dr["FAQ_ID"].ToString() + "') \">" + dr["Question"].ToString() + "</a></li>");
icol++;
}
strTable.Append("</ul></td></tr>");
strTable.Append("</table>");
}
else
{
DataTable dtFAQ = BLL_FAQ_Item.Get_TopicModule(TopicID);
title = "Help/FAQ/" + dtFAQ.Rows[0]["Description"].ToString();
strTable.Append("<table id='__tbl_remark' CELLPADDING='2' CELLSPACING='0' style='border-collapse:collapse' ");
if (!string.IsNullOrWhiteSpace(TableCss))
{
strTable.Append(" class='" + TableCss + "' ");
}
strTable.Append(" > ");
strTable.Append("<tr class='" + QuestionCSS + "'><td>" + dtFAQ.Rows[0]["Module_Description"].ToString() + "/" + dtFAQ.Rows[0]["Description"].ToString() + "</td></tr>");
//Start Question TR
strTable.Append("<tr >");
strTable.Append("<td class=\"" + QuestionCSS + "-FAQ\">");
strTable.Append("<span style='color:maroon;padding:2px'> No record found !</span>");
strTable.Append("</td></tr>");
strTable.Append("</table>");
}
return(title + "~totalrecordfound~" + strTable.ToString());
case "FAQ":
if (dtTable.Rows.Count > 0)
{
strTable.Append("<table id='__tbl_remark1' CELLPADDING='2' CELLSPACING='0' style='border-collapse:collapse' ");
if (!string.IsNullOrWhiteSpace(TableCss))
{
strTable.Append(" class='" + TableCss + "' ");
}
strTable.Append(" > ");
strTable.Append("<tr><td align='left'><h2><b>" + dtTable.Rows[0]["Question"].ToString() + "</b></h2></td>");
strTable.Append("<td style='width:250px;' ><div id='dvVideo' style='position:absolute;'>");
DataTable dt = BLL_FAQ_Item.Get_FAQ_Link(Convert.ToInt32(dtTable.Rows[0]["FAQ_ID"].ToString())).Tables[0];
if (dt.Rows.Count > 0)
{
strTable.Append("<span class='FAQ-Video'>Related Videos</span><ul class=\"" + TopicListCSS + "-show\">");
foreach (DataRow dr in dt.Rows)
{
strTable.Append("<li><a style='color:#627A62;text-align:left; ' href=\"javascript:Play('" + dr["ITEM_PATH"].ToString() + "','" + dr["Item_name"].ToString() + "') \">" + dr["Item_name"].ToString() + "</a></li>");
}
strTable.Append("</ul><div></td></tr>");
}
//Start Question TR
strTable.Append("<tr >");
strTable.Append("<td class='" + AnswerCSS + "-desc'>" + dtTable.Rows[0]["Answer"].ToString());
strTable.Append("</td><td class=\"" + AnswerCSS + "-FAQ\"></td>");
strTable.Append("</tr>");
if (dtTable.Rows[0]["Status"].ToString() == "")
{
strTable.Append("<tr>");
strTable.Append("<td class='" + AnswerCSS + "' style='font-size:small'>Was this helpful?<a style='text-decoration:none !important;color: #86868D; font-size:x-small' href=\"javascript:IsHelpful('Yes','" + dtTable.Rows[0]["FAQ_ID"].ToString() + "') \">Yes</a>/<a style='text-decoration:none !important;color: #86868D;font-size:x-small' href=\"javascript:IsHelpful('No','" + dtTable.Rows[0]["FAQ_ID"].ToString() + "') \">No</a>");
strTable.Append("</td><td class=\"" + AnswerCSS + "-FAQ\"></td></tr>");
}
strTable.Append("</table><br/>");
}
else
{
strTable.Append("<span style='color:maroon;padding:2px'> No record found !</span>");
}
return(strTable.ToString());
case "DESC":
// string Solution;
strTable.Append("<table id='__tbl_remark' CELLPADDING='2' CELLSPACING='0' style='border-collapse:collapse' ");
if (!string.IsNullOrWhiteSpace(TableCss))
{
strTable.Append(" class='" + TableCss + "' ");
}
strTable.Append(" > ");
strTable.Append("<tr><td class=\"" + QuestionCSS + "-FAQ\">Search results for <span style='background-color:#FFFFCC'>" + Description + "</span><br/><br/></td></tr>");
strTable.Append("<tr>");
strTable.Append("<td align='left' style='vertical-align:top;'><div class='SpanCss'>?</div><div style='float:left; color:Gray; font-weight: bold;font-size: large;'> Frequently Asked Questions:</div></td></tr><tr><td><br/></td></tr>");
if (dtTable.Rows.Count > 0)
{
foreach (DataRow dr in dtTable.Rows)
{
strTable.Append("<tr style=' background-color:#E0EBEB' >");
strTable.Append("<td align='left' class=\"" + QuestionCSS + "-FAQ\">");
strTable.Append("<a href=\"javascript:Expand('" + dr["FAQ_ID"].ToString() + "') \">" + dr["Question"].ToString() + "</a>");
strTable.Append("</td></tr>");
strTable.Append("<tr><td align='left' class='" + CategoryCss + "'>Category:<b style='color:black'>" + dr["Module_Description"].ToString() + "/" + dr["Description"].ToString() + "</b></td></tr>");
strTable.Append("<tr >");
//if (dtTable.Rows[0]["Answer"].ToString().Length > 50)
//{
// int iNextSpace = dtTable.Rows[0]["Answer"].ToString().LastIndexOf(" ", 20);
// Solution=string.Format("{0}...", dtTable.Rows[0]["Answer"].ToString().Substring(0, (iNextSpace > 0) ? iNextSpace : 180).Trim());
//}
//else
//{
// Solution = dtTable.Rows[0]["Answer"].ToString();
//}
strTable.Append("<td class='" + AnswerCSS + "'><div style='height:30px;overflow: hidden;line-height:30px;'><div>" + dr["Answer"].ToString());
strTable.Append("</div><div></td></tr><tr><td class='" + AnswerCSS + "'><hr></td></tr>");
}
strTable.Append("<tr><td><br/></td></tr></table>");
}
else
{
strTable.Append("<tr><td><span class='" + AnswerCSS + "' style='color:maroon;padding:2px'> No record found !</span></td></tr></table>");
}
return(strTable.ToString());
}
return("");
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public string DeleteFAQ(int FAQ_ID, int UserID)
{
BLL_FAQ_Item.Del_Faq_ServiceDetails(FAQ_ID, UserID);
return("true");
}