public static int UpdateScore(EventFassDetail ev)
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("Update EventDetail set Skor=" + ev.skor + " where EventID='" + ev.eventID + "' " +
"and FestivalID='" + ev.festivalID + "' and PesertaID='" + ev.pesertaID + "' and PoinID=" + ev.poinID, con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
return(cmd.ExecuteNonQuery());
}
public static IEnumerable <EventFassDetail> getPoinPenilaianByPeserta(EventFassDetailParent ev)
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("Select EventID,a.PesertaID,a.FestivalID,a.PoinID, PoinPenilaian, Skor from EventDetail a " +
"join FestivalDetail b on a.FestivalID=b.FestivalID and a.PoinID=b.PoinID where EventID='" + ev.eventID + "' and a.FestivalID='" + ev.festivalID + "' and a.PesertaID='" + ev.pesertaID + "' ", con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
List <EventFassDetail> newEvent = new List <EventFassDetail>();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
EventFassDetail newev = new EventFassDetail(rd.GetGuid(0), rd.GetGuid(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetDouble(5));
newEvent.Add(newev);
}
return(newEvent);
}
public static int UpdateScore(EventFassDetail ev)
{
return(EventFassModel.UpdateScore(ev));
}
