private static List <UnionEvent> GetListOfEventsBySqlRequest(string sql)
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
var cmd = new SqlCommand(sql, con);
var events = new List <UnionEvent>();
var sqlDataReader = cmd.ExecuteReader();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
var unionEvent = new UnionEvent(
Convert.ToInt32(sqlDataReader["id"].ToString()),
sqlDataReader["name"].ToString(),
Convert.ToDateTime(sqlDataReader["date"]),
sqlDataReader["Adress"].ToString());
//while() - get members
// unionEvent.FollowUser(findedStudent)
}
}
con.Close();
return(events);
}
public static bool AddEvent(UnionEvent unionEvent)
{
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [Events_] (name,Adress,Date) VALUES(@name,@Adress,@Date);", con);
cmd.Parameters.AddWithValue("@name", unionEvent.Name);
cmd.Parameters.AddWithValue("@Adress", unionEvent.Place);
cmd.Parameters.AddWithValue("@Date", unionEvent.Date);
var result = cmd.ExecuteNonQuery();
con.Close();
return(result > 0);
}
public static bool UpdateEvent(UnionEvent oldEvent, UnionEvent newEvent)
{
con.Open();
var cmd = new SqlCommand("UPDATE [Events_] SET [name]=@name,[Adress]= @Adress,[Date]=@Date where [id]=@id", con);
cmd.Parameters.AddWithValue("@id", oldEvent.Id);
cmd.Parameters.AddWithValue("@name", newEvent.Name);
cmd.Parameters.AddWithValue("@Adress", newEvent.Place);
cmd.Parameters.AddWithValue("@Date", newEvent.Date);
var result = cmd.ExecuteNonQuery();
con.Close();
return(result > 0);
}
