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