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