public static List <PartiesDTO> GetParties()
{
DataTable _dt = new DataTable();
List <PartiesDTO> parties = new List <PartiesDTO>();
try
{
using (MySqlConnection cn = new MySqlConnection(cs))
{
cn.Open();
string query = "SELECT Id_partie, partieLibelle, partieOrdre FROM t_parties";
using (MySqlDataAdapter da = new MySqlDataAdapter(query, cn))
{
da.Fill(_dt);
}
cn.Close();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
foreach (DataRow row in _dt.Rows)
{
PartiesDTO partie = new PartiesDTO();
partie.ID = Convert.ToInt32(row["Id_partie"]);
partie.Libelle = row["partieLibelle"].ToString();
partie.Ordre = Convert.ToInt16(row["partieOrdre"]);
parties.Add(partie);
}
return(parties);
}
public HttpResponseMessage addVote(PartiesDTO givenParty, int id)
{
try
{
using (logic)
{
givenParty.id = id;
PartiesDTO updatedParty = logic.addVote(givenParty);
if (updatedParty == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK, updatedParty));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ErrorsManager.GetInnerMeesage(ex)));
}
}
