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