public List <TB_Votation_Options> lstOptions(int id, OleDbConnection db)
{
List <TB_Votation_Options> lst = new List <TB_Votation_Options>();
DataSet ds = new DataSet();
try
{
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM TB_VOTATION_OPTIONS WHERE VOTATIONID =" + id, db);
da.Fill(ds);
db.Close();
DataTable dt = ds.Tables[0];
foreach (DataRow rows in dt.Rows)
{
TB_Votation_Options vO = new TB_Votation_Options();
vO.id = int.Parse(rows["Id"].ToString());
vO.votationId = int.Parse(rows["VotationId"].ToString());
vO.letter = rows["Letter"].ToString();
vO.valueoption = rows["ValueOption"].ToString();
vO.color = rows["Color"].ToString();
lst.Add(vO);
}
}
catch (Exception)
{
throw;
}
return(lst);
}
public string insertOptions(TB_Votation_Options tvo, OleDbConnection db)
{
string result = "";
try
{
string sql = @"INSERT INTO TB_Votation_Options(VotationId,Letter,ValueOption,Color) VALUES (" + tvo.votationId + ",'" + tvo.letter + "','" + tvo.valueoption + "','" + tvo.color + "')";
OleDbCommand cmd = new OleDbCommand(sql, db);
cmd.ExecuteNonQuery();
db.Close();
result = "VOTACIÒN INICIADA";
}
catch (Exception)
{
throw;
}
return(result);
}
public string addOptions(TB_Votation_Options tvo, OleDbConnection db)
{
return(_Votation.insertOptions(tvo, db));
}
public JsonResult CreateOptionvotation(TB_Votation_Options opt)
{
string respuesta = TB_vota.addOptions(opt, DBConnect.open());
return(Json(respuesta));
}
