public static int InsertEvent(EventFass ev)
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("insert into Events values(@eventID,@eventDate ,@closed ,@namaEvent)", con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
cmd.Parameters.AddWithValue("@eventID", ev.eventID);
cmd.Parameters.AddWithValue("@eventDate", ev.eventDate);
cmd.Parameters.AddWithValue("@closed", ev.closed);
cmd.Parameters.AddWithValue("@namaEvent", ev.namaEvent);
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public static IEnumerable <EventFass> getEventList()
{
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand("Select * from Events where closed=0", con);
if (con.State.Equals(ConnectionState.Closed))
{
con.Open();
}
List <EventFass> newEvent = new List <EventFass>();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
EventFass ev = new EventFass(rd.GetGuid(0), rd.GetDateTime(1), rd.GetBoolean(2), rd.GetString(3));
newEvent.Add(ev);
}
return(newEvent);
}
public static int InsertEvent(EventFass evdetail)
{
return(EventFassModel.InsertEvent(evdetail));;
}
