public void setUsers(string sql_query)
{
SqlConnModel.setData(sql_query);
MySqlDataReader reader = SqlConnModel.getData();
if (reader.HasRows)
{
while (reader.Read())
{
int id = reader.GetInt32(reader.GetOrdinal("id"));
String name = reader.GetString(reader.GetOrdinal("name"));
String email = reader.GetString(reader.GetOrdinal("email"));
String cellnumber = reader.GetString(reader.GetOrdinal("cellnumber"));
String profile_pic = reader.GetString(reader.GetOrdinal("profile_pic"));
String type = reader.GetString(reader.GetOrdinal("type"));
var columns = new JObject();
columns["id"] = id.ToString();
columns["name"] = name;
columns["email"] = email;
columns["cellnumber"] = cellnumber;
columns["profile_pic"] = profile_pic;
columns["type"] = type;
this.rows.Add(columns);
}
}
}
public void setStyles(string sql_query)
{
SqlConnModel.setData(sql_query);
MySqlDataReader reader = SqlConnModel.getData();
if (reader.HasRows)
{
while (reader.Read())
{
int id = reader.GetInt32(reader.GetOrdinal("id"));
String name = reader.GetString(reader.GetOrdinal("name"));
String email = reader.GetString(reader.GetOrdinal("details"));
int price = reader.GetInt32(reader.GetOrdinal("price"));
String image = reader.GetString(reader.GetOrdinal("image"));
var columns = new JObject();
columns["id"] = id.ToString();
columns["name"] = name;
columns["email"] = email;
columns["price"] = price;
columns["image"] = image;
this.rows.Add(columns);
}
}
}
internal void setBooking(string sql_query)
{
//execute sql query
SqlConnModel.setData(sql_query);
MySqlDataReader reader = SqlConnModel.getData();
if (reader.HasRows)
{
int n = 1;
//if query results are returned... build a Json array for the results
while (reader.Read())
{
int id = reader.GetInt32(reader.GetOrdinal("id"));
int _styleid = reader.GetInt32(reader.GetOrdinal("style_id"));
string start = reader.GetDateTime(reader.GetOrdinal("start")).ToString("yyyy-MM-dd HH:mm:ss");
String end = reader.GetDateTime(reader.GetOrdinal("end")).ToString("yyyy-MM-dd HH:mm:ss");
//get style name by id
dynamic responseListObj = this.stylesArray.OfType <JObject>().ToList();
int styleID = _styleid - 1;
string styleName = responseListObj[styleID]["name"];
//"[{\"id\":\"5\",\"text\":\"Germen Cut\",\"start\":\"2019-10-18T10:30:00\",\"end\":\"2019-10-18T11:30:00\"}]"
var columns = new JObject();
columns["id"] = n;
columns["text"] = styleName;
columns["start"] = start.Replace(" ", "T");
columns["end"] = end.Replace(" ", "T");
this.rows.Add(columns);
n++;
}
}
}