public List <Models.Occupation> Observer(KillPeoPle data)
{
var newline = _service.Observer(data);
//return Ok(newline);
return(newline);
}
public List <Models.Occupation> Observer(KillPeoPle data)
{
string connStr = "data source=werewolfkill.database.windows.net;initial catalog=Werewolfkill;persist security info=True;user id=Werewolfkill;password=Wolfpeoplekill_2020;MultipleActiveResultSets=True;";
List <Models.Occupation> r = null;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
var paramater = new KillPeoPle {
RoomId = data.RoomId, Player = data.Player
};
var sql = "select o.Occupation_GB from GameRoom g " +
"inner join Occupation o on o.Occupation_ID = g.OccupationId " +
"where RoomId = @RoomId and Players = @Player";
r = conn.Query <Models.Occupation>(sql, paramater).ToList();
}
return(r);
}
public List <Models.Occupation> Observer(KillPeoPle data)
{
var result = new DBModels.GameRoom();
string connStr = "data source=werewolfkill.database.windows.net;initial catalog=Werewolfkill;persist security info=True;user id=Werewolfkill;password=Wolfpeoplekill_2020;MultipleActiveResultSets=True;";
List <Models.Occupation> r = null;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
var paramater = new DBModels.GameRoom {
RoomId = data.RoomId, Players = data.Player
};
var sql = "select * from GameRoom where RoomId = 1 and Players = '*****@*****.**'";
conn.Query <Models.Occupation>(sql, paramater);
//r = conn.Query<KillPeoPle>(sql, paramater).FirstOrDefault();
}
return(r);
}
public List <Models.Occupation> Observer(KillPeoPle data)
{
return(_repo.Observer(data));
}
