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));
}