public Dictionary <string, object> AgentGetAll(int start_index, int count) { Console.WriteLine($"start_index={start_index}, count={count}"); if (count < 1) { count = 10; } if (start_index < 0) { start_index = 0; } SQLiteDataReader reader = client.Query( $"select Id, TotalDeals, MonthDeals, MonthPayment from Agent limit {count} offset {start_index};"); return(CommonDataview.Build(reader)); }
public Dictionary <string, object> PersonGetAll(int start_index, int count) { Console.WriteLine($"start_index={start_index}, count={count}"); if (count < 1) { count = 10; } if (start_index < 0) { start_index = 0; } SQLiteDataReader reader = client.Query( $"select Id, Surname, Name, Phone from Person limit {count} offset {start_index};"); return(CommonDataview.Build(reader)); }
public Dictionary <string, object> EstateObjectGetAll(int start_index, int count) { Console.WriteLine($"start_index={start_index}, count={count}"); if (count < 1) { count = 10; } if (start_index < 0) { start_index = 0; } SQLiteDataReader reader = client.Query( $"select Id, LocationId, Price, Description from EstateObject limit {count} offset {start_index};"); return(CommonDataview.Build(reader)); }
public Dictionary <string, object> DealGetAll(int start_index, int count) { Console.WriteLine($"start_index={start_index}, count={count}"); if (count < 1) { count = 10; } if (start_index < 0) { start_index = 0; } SQLiteDataReader reader = client.Query( $"select Id, SellerId, BuyerId, AgentId, Price, DealDate from Deal limit {count} offset {start_index};"); return(CommonDataview.Build(reader)); }
public Dictionary <string, object> ClientWishGetAll(int start_index, int count) { Console.WriteLine($"start_index={start_index}, count={count}"); if (count < 1) { count = 10; } if (start_index < 0) { start_index = 0; } SQLiteDataReader reader = client.Query( $"select Id, PersonId, PostDate, Variant, Price from ClientWish limit {count} offset {start_index};"); return(CommonDataview.Build(reader)); }
public Dictionary <string, object> RawSql(Dictionary <string, string> Data) { if (Data.ContainsKey("Query")) { string op = Data["Query"].Split(' ')[0].ToLower(); if (op != "select") { return new Dictionary <string, object>() { ["Good"] = 0, ["Message"] = "Only select operation is supported, for your own safety!" } } ; try { var reader = client.Query(Data["Query"]); var result = CommonDataview.Build(reader); result["Good"] = 1; return(result); } catch (Exception ee) { return(new Dictionary <string, object>() { ["Good"] = 0, ["Message"] = ee.Message }); } } return(new Dictionary <string, object>() { ["Good"] = 0 }); } }