public static string getGCFiledataByID(string fileID, string sortBy, string arrange) { DataTable table = ModelSearchClass.GetFileDataByFileID_json(fileID, sortBy, arrange); JavaScriptSerializer jsSerializer = new JavaScriptSerializer(); var lst = table.AsEnumerable().Select(r => r.Table.Columns.Cast <DataColumn>().Select(c => new KeyValuePair <string, object>(c.ColumnName, r[c.Ordinal])).ToDictionary(z => z.Key, z => z.Value)).ToList(); return(jsSerializer.Serialize(lst)); }
public static string DeleteSearchedword(string Data) { ModelSearchClass searchClass = new ModelSearchClass(); int _EmployeeId = Convert.ToInt32(HttpContext.Current.Session["PP_EmployeeID"]); try { JavaScriptSerializer jsSerializer = new JavaScriptSerializer(); DataTable dt = searchClass.DeleteRecentWordSearched(Data, Convert.ToString(HttpContext.Current.Session["PP_Domain"]), Convert.ToString(HttpContext.Current.Session["PP_NTID"])); var lst = dt.AsEnumerable().Select(r => r.Table.Columns.Cast <DataColumn>().Select(c => new KeyValuePair <string, object>(c.ColumnName, r[c.Ordinal])).ToDictionary(z => z.Key, z => z.Value)).ToList(); return(jsSerializer.Serialize(lst)); } catch (Exception Ex) { Utility.MessageBox("Error Occurred !!! Please contact system administrator."); Utility.CreateErrorLog(Ex.Message.ToString(), "Home.aspx", "Save", "../ErrorLog/"); } return(""); }
public static string getBCFile_Detailsdata_ByID(string fileID) { ModelSearchClass searchClass = new ModelSearchClass(); int _EmployeeId = Convert.ToInt32(HttpContext.Current.Session["PP_EmployeeID"]); try { JavaScriptSerializer jsSerializer = new JavaScriptSerializer(); DataSet dt = searchClass.getBCFile_Detailsdata_ByID(fileID, Convert.ToString(HttpContext.Current.Session["PP_Domain"]), Convert.ToString(HttpContext.Current.Session["PP_NTID"])); // var lst = dt.Tables[0].AsEnumerable().Select(r => r.Table.Columns.Cast<DataColumn>().Select(c => new KeyValuePair<string, object>(c.ColumnName, r[c.Ordinal])).ToDictionary(z => z.Key, z => z.Value)).ToList(); //return jsSerializer.Serialize(dt); //return dt.GetXml(); return(DataSetExt.GetJSON(dt)); } catch (Exception Ex) { Utility.MessageBox("Error Occurred !!! Please contact system administrator."); Utility.CreateErrorLog(Ex.Message.ToString(), "Home.aspx", "Save", "../ErrorLog/"); } return(""); }