public WhiteWalkerDTO GetWhiteWalkerById(int p_id)
{
WhiteWalkerDTO ww;
string sql = "SELECT * FROM WhiteWalkers WHERE WhiteWalkerId = @id";
using (SqlConnection sqlCon = new SqlConnection(_connectionString))
{
sqlCon.Open();
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlCon))
{
sqlCmd.Parameters.Add("@id", SqlDbType.Int).Value = p_id;
SqlDataReader rdr = sqlCmd.ExecuteReader();
if (rdr.Read())
{
int id = rdr.GetInt32(0);
int nOfU = rdr.GetInt32(1);
ww = new WhiteWalkerDTO(id, nOfU);
}
else
{
ww = new WhiteWalkerDTO(-1);
}
};
sqlCon.Close();
};
return(ww);
}
public IHttpActionResult GetWhiteWalkerById(int id)
{
WhiteWalkerDTO ww = GameManager.Instance.GetWhiteWalkerById(id);
if (ww.Id == 0)
{
return(NotFound());
}
else
{
return(Ok(ww));
}
}
public void AddWhiteWalker(WhiteWalkerDTO ww)
{
string sql = "INSERT INTO WhiteWalkers(NumberOfUnits) Values(@nbOfUnits)";
using (SqlConnection sqlCon = new SqlConnection(_connectionString))
{
sqlCon.Open();
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlCon))
{
sqlCmd.Parameters.Add("@nbOfUnits", SqlDbType.Int).Value = ww.NumberOfUnits;
sqlCmd.ExecuteNonQuery();
};
sqlCon.Close();
};
}
public void EditWhiteWalker(WhiteWalkerDTO ww)
{
string sql = "UPDATE WhiteWalkers SET NumberOfUnits = @nbOfUnits WHERE WhiteWalkerId = @id";
using (SqlConnection sqlCon = new SqlConnection(_connectionString))
{
sqlCon.Open();
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlCon))
{
sqlCmd.Parameters.Add("@nbOfUnits", SqlDbType.Int).Value = ww.NumberOfUnits;
sqlCmd.Parameters.Add("@id", SqlDbType.Int).Value = ww.Id;
sqlCmd.ExecuteNonQuery();
};
sqlCon.Close();
};
}
public void EditWhiteWalker(WhiteWalkerDTO ww)
{
DalManager.Instance.EditWhiteWalker(ww);
}
public void AddWhiteWalker(WhiteWalkerDTO ww)
{
DalManager.Instance.AddWhiteWalker(ww);
}
public IHttpActionResult PutWhiteWalker([FromBody] WhiteWalkerDTO ww)
{
GameManager.Instance.EditWhiteWalker(ww);
return(Ok());
}
public IHttpActionResult PostWhiteWalker(WhiteWalkerDTO ww)
{
GameManager.Instance.AddWhiteWalker(ww);
return(Ok());
}
public void EditWhiteWalker(WhiteWalkerDTO ww)
{
bddInterf.EditWhiteWalker(ww);
}
public void AddWhiteWalker(WhiteWalkerDTO ww)
{
bddInterf.AddWhiteWalker(ww);
}
public WhiteWalker(WhiteWalkerDTO wwdto)
{
Id = wwdto.Id;
NumberOfUnits = wwdto.NumberOfUnits;
}
