public static List <String> GetJoinData(string sql, params object[] values) { List <String> tablo = new List <string>(); int kayit = 0; try { if (sql.IndexOf("INNER JOIN") != -1 || sql.IndexOf("LEFT JOIN") != -1 || sql.IndexOf("Inner Join") != -1 || sql.IndexOf("Left Join") != -1 || sql.IndexOf("inner join") != -1 || sql.IndexOf("left join") != -1) { DataSet ds = WebFramework.DataSetFill(sql, values); String verikumesi = null; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { verikumesi += ds.Tables[0].Rows[i][j] + Config.parse.ToString(); } verikumesi = verikumesi.Remove(verikumesi.Length - 1); tablo.Add(verikumesi); verikumesi = null; } kayit = ds.Tables[0].Rows.Count; if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + "Count: " + kayit); } return(tablo); } else { if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + System.Environment.NewLine + "Count: " + kayit); } tablo.Add(""); return(tablo); } } else { if (Config.debug == true) { FrameworkHandler.DebugLogger(sql + System.Environment.NewLine + "Could not execute SQL query could not be found in the inner join and left join, please check your query."); } tablo.Add("Couldn't run Sql in question, please check your query."); return(tablo); } } catch (Exception hata) { if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } tablo.Add("Error:" + hata.Message); return(tablo); } }
public static string GetJSONData(string sql, params object[] values) { try { WebFramework web = new WebFramework(); DataTable dt = web.DataTableGetir(sql, values); if (Config.debug == true) { FrameworkHandler.DebugLogger("SQL Execute: " + sql + " \nCount: " + dt.Rows.Count); } return(Utils.GetJson(dt)); } catch (Exception hata) { if (Config.debug == true) { FrameworkHandler.DebugLogger(hata.ToString()); } return("Error: " + hata.Message); } }