public static FAQDetail GetFaQDetail(int Id) { FAQ objFAQ = new FAQ(); DataTable dt=objFAQ.GetFAQs(1,10000,"","id",1); string filterExp; string sortExp = "id asc"; DataRow[] drarray; filterExp = " id = '" + Id.ToString() + "'"; drarray = dt.Select(filterExp, sortExp, DataViewRowState.CurrentRows); FAQDetail objFaqdetail = new FAQDetail(); objFaqdetail.IndQuestion = drarray[0]["tanya"].ToString(); objFaqdetail.IndAnswer = drarray[0]["jawab"].ToString(); objFaqdetail.EngQuestion = drarray[0]["entanya"].ToString(); objFaqdetail.EngAnswer = drarray[0]["enjawab"].ToString(); return objFaqdetail; }
public static string GetFAQs(int PageIndex, int PageSize, string SortCol, string SortDir, string SearchFilter) { FAQ objFAQ = new FAQ(); Hashtable objHT = new Hashtable(); string totalRecords = ""; string totalDisplayRecords = ""; int count = 0; string rowClass = ""; var sb = new StringBuilder(); string outputJson = string.Empty; DataTable dtFAQ = new DataTable(); string SortBy = "id"; int SortDirection = 1; if (SortCol == "0") { SortBy = "id"; } else if (SortCol == "1") { SortBy = "tanya"; } else if (SortCol == "2") { SortBy = "count"; } if (SortDir == "asc") { SortDirection = 1; } else { SortDirection = 0; } dtFAQ = objFAQ.GetFAQs(PageIndex, PageSize, SearchFilter, SortBy, SortDirection); if (dtFAQ.Rows.Count > 0) { for (int i = 0; i < dtFAQ.Rows.Count; i++) { if (totalRecords.Length == 0) { totalRecords = dtFAQ.Rows.Count.ToString(); totalDisplayRecords = dtFAQ.Rows.Count.ToString(); } sb.Append("{"); sb.AppendFormat(@"""id"": ""{0}""", count++); sb.Append(","); sb.AppendFormat(@"""DT_RowClass"": ""{0}""", rowClass); sb.Append(","); sb.AppendFormat(@"""0"": ""{0}""", "<div style='text-overflow: ellipsis; width: 50px;overflow: hidden;'><nobr>" + dtFAQ.Rows[i]["id"].ToString().Replace("\"", "\\" + "\"") + "</nobr></div>"); sb.Append(","); sb.AppendFormat(@"""1"": ""{0}""", "<div style='text-overflow: ellipsis; width: 250px;overflow: hidden;'><nobr>" + dtFAQ.Rows[i]["tanya"].ToString().Replace("\"", "\\" + "\"") + "</nobr></div>"); sb.Append(","); sb.AppendFormat(@"""2"": ""{0}""", "<div style='text-overflow: ellipsis; width: 40px;overflow: hidden;'><nobr>" + dtFAQ.Rows[i]["count"].ToString().Replace("\"", "\\" + "\"") + "</nobr></div>"); sb.Append(","); sb.AppendFormat(@"""3"": ""{0}""", "<div><a class='edit' href='javascript:void(0)' data-id='" + dtFAQ.Rows[i]["id"].ToString().Replace("\"", "\\" + "\"") + "' data-toggle='tooltip' title='update data faq'><i class='fa fa-edit fa-border'></i></a><a class='delete' href='javascript:void(0)' data-id='" + dtFAQ.Rows[i]["id"].ToString().Replace("\"", "\\" + "\"") + "' data-toggle='tooltip' title='delete data tags'><i class='fa fa-trash-o fa-border'></i></a></div>"); sb.Append("},"); } outputJson = sb.Remove(sb.Length - 1, 1).ToString(); sb.Clear(); sb.Append("{"); sb.Append(@"""sEcho"": "); sb.AppendFormat(@"""{0}""", sEcho++); sb.Append(","); sb.Append(@"""iTotalRecords"": "); sb.Append(totalRecords); sb.Append(","); sb.Append(@"""iTotalDisplayRecords"": "); sb.Append(totalDisplayRecords); sb.Append(", "); sb.Append(@"""aaData"": [ "); sb.Append(outputJson); sb.Append("]}"); outputJson = sb.ToString(); } else { sb.Append("{"); sb.Append(@"""sEcho"": "); sb.AppendFormat(@"""{0}""", sEcho++); sb.Append(","); sb.Append(@"""iTotalRecords"": 0"); sb.Append(","); sb.Append(@"""iTotalDisplayRecords"": 0"); sb.Append(", "); sb.Append(@"""aaData"": [ "); sb.Append("]}"); outputJson = sb.ToString(); } return outputJson; }