public User SignIn(User user, string ConnectionString) { var paramDict = new Dictionary <string, string>() { { "Email", user.Email }, { "Password", user.Password } }; var DataOperation = SQLOperation.ExecuteCommand(ConnectionString, "GetUser", paramDict); try { var DataRow = DataOperation.Rows[0]; return(new User { FirstName = DataRow["FirstName"].ToString(), LastName = DataRow["LastName"].ToString(), Email = DataRow["Email"].ToString(), Username = DataRow["Username"].ToString(), Role = DataRow["Role"].ToString(), }); } catch (Exception) { return(new User()); } }
public void Post([FromBody] string value) { var data = (SensorData)JsonConvert.DeserializeObject(value); var time = DateTime.Now; if (data.From == "dht") { //if (Convert.ToUInt32(data.Temparature) > 30); var Parameters = new Dictionary <string, string> { { "@time", time.ToString() }, { "@temperature", data.Temparature }, { "@humadity", data.Humadity } }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "InsertTemp", false, Parameters); //DataTable.Merge(SQLOperation.ExecuteCommand(Startup.ConnectionString, "getlastfive", Parameters)); } else { var Parameters = new Dictionary <string, string> { { "@time", time.ToString() }, { "@gasvalue", data.GasValue } }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "InsertAirQual", false, Parameters); } }
public string GetStockDataByDate(string date) { var Parameters = new Dictionary <string, string> { { "@date", date } }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "getstockbydate", Parameters); return(JsonConvert.SerializeObject(DataTable)); }
public string GetStockDataByName(string stock) { var Parameters = new Dictionary <string, string> { { "@symbol", stock.ToUpper() } }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "getstockbysymbol", Parameters); return(JsonConvert.SerializeObject(DataTable)); }
public string ForceMatch(string SGref, string CLRef) { var parameters = new Dictionary <string, string> { { "@SGRef", SGref }, { "@CLRef", CLRef } }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "forceMatch", parameters); return(JsonConvert.SerializeObject(DataTable)); }
public List <Parking> GetParkings(string ConnectionString) { var ParkingList = new List <Parking>(); var DataOperation = SQLOperation.ExecuteCommand(ConnectionString, "GetAllParkings"); foreach (var Data in DataOperation.Rows) { ParkingList.Add(new Parking((DataRow)Data)); } return(ParkingList); }
public string Get() { var date = "2016-12-30"; var Parameters = new Dictionary <string, string> { { "@date", date } }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "gettopfive", Parameters); DataTable.Merge(SQLOperation.ExecuteCommand(Startup.ConnectionString, "getlastfive", Parameters)); return(JsonConvert.SerializeObject(DataTable)); }
public string GetStockNames() { var stocks = new List <string> { }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "getsymbolnames"); foreach (DataRow row in DataTable.Rows) { stocks.Add(row["symbol"].ToString()); } return(JsonConvert.SerializeObject(stocks.ToArray())); }
public string Get(string sensor) { if (sensor == "dht") { var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "GetClimate", true); return(JsonConvert.SerializeObject(DataTable)); } else { var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "GetAirQuality", true); return(JsonConvert.SerializeObject(DataTable)); } }
public bool RegisterUser(User user, string ConnectionString) { var paramDict = new Dictionary <string, string>() { { "FirstName", user.FirstName }, { "LastName", user.LastName }, { "Email", user.Email }, { "Username", user.Username }, { "Password", user.Password }, { "Role", "User" } }; var DataOperation = SQLOperation.ExecuteCommand(ConnectionString, "InsertUser", paramDict); return(true); }
public IEnumerable <string> Get() { var clientFile = Environment.CurrentDirectory + "\\Data\\ClientProposedDataforSampleData\\"; var resDict = new List <List <List <string> > >(); for (int i = 1; i < 18; i++) { resDict.Add(Match.MatchOperation(clientFile + i.ToString() + "_message.txt")); } foreach (var masterList in resDict) { foreach (var parentList in masterList) { var Parameters = new Dictionary <string, string> { { "@SGRef", parentList[0] }, { "@CLRef", parentList[1] }, { "@Result", parentList[2] } }; var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "insertOneToOne", Parameters); } } return(new string[] { "value1", "value2" }); }
public string Get() { var DataTable = SQLOperation.ExecuteCommand(Startup.ConnectionString, "gethotels"); return(JsonConvert.SerializeObject(DataTable)); }