public List <Event> GetAllEvent(string username)
{
string query = "SELECT * FROM Users WHERE Username='******'";
SqlDataReader reader = this.dataAcces.GetAll(query);
reader.Read();
int id = (int)reader["UserId"];
string query1 = "SELECT * FROM Event2 WHERE UserId=" + id;
dataAcces = new DataAcces();
reader = this.dataAcces.GetAll(query1);
List <Event> list = new List <Event>();
while (reader.Read())
{
Event note = new Event();
note.EventId = (int)reader["EventId"];
note.Title = reader["Title"].ToString();
note.WriteTab = reader["WriteTab"].ToString();
note.Priority = reader["Priority"].ToString();
note.Date = reader["Date"].ToString();
note.Id = (int)reader["UserId"];
list.Add(note);
}
return(list);
}
public int Add(Event events)
{
string query = "INSERT INTO Event2(Title,WriteTab,Priority,Date,UserId) VALUES('" + events.Title + "','" + events.WriteTab + "','" + events.Priority + "','" + events.Date + "','" + events.Id + "')";
dataAcces = new DataAcces();
int result = this.dataAcces.ExecuteQuery(query);
return(result);
}
public ModifyEventDataAccess()
{
this.dataAcces = new DataAcces();
}
public AddEventDataAccess()
{
this.dataAcces = new DataAcces();
}
public SignUpDataAccess()
{
this.dataAcces = new DataAcces();
}
public HomeDataAccess()
{
this.dataAcces = new DataAcces();
}
public DeleteEventDataAccess()
{
this.dataAcces = new DataAcces();
}
public LoginDataAcces()
{
this.dataAcces = new DataAcces();
}