//gebruiker registreren
protected void btnRegister_Click(object sender, EventArgs e)
{
string loginname = tbRegUserLogin.Text;
string password = tbRegUserPassword.Text;
string name = tbRegName.Text;
string birthdate = calRegBirthday.SelectedDate.ToString();
string email = tbRegEmail.Text;
string gender = ddlRegGender.SelectedValue.ToString();
string soort = ddlRegType.SelectedValue.ToString(); //int a = "werkt niet meer? wisselt automatisch naar normaal";
if (soort == "Auteur")
{
User user = new AuthorUser(1, name, birthdate, email, loginname, gender, soort, 0);
if (ctrl.AddUser(user, password))
{
lblMessageRegister.Text = "Registreren is gelukt!";
}
else
{
lblMessageRegister.Text = "er is iets fout gegaan, probeer het nog eens";
}
}
else if (soort == "Normaal")
{
User user = new NormalUser(1, name, birthdate, email, loginname, gender, soort, 0);
ctrl.AddUser(user, password);
}
}
public bool AddArticle(Article article, AuthorUser author)
{
ArticleIdIn = GetInsertID("ArticleID", "ARTICLE");
ArticleIdIn++;
string sql = "INSERT INTO ARTICLE (ArticleID, Naam, Text, Author, DateAdded) Values ( :ArticleID, :Naam, :Text, :Author , :DateAdded)";
OracleCommand command = new OracleCommand(sql, conn);
command.Parameters.Add(":ArticleID", ArticleIdIn);
command.Parameters.Add(":Naam", article.Name);
command.Parameters.Add(":Text", article.Text);
command.Parameters.Add(":Author", author.Name);
command.Parameters.Add(":DateAdded", article.DateAdded);
try
{
conn.Open();
command.ExecuteNonQuery();
return(true);
}
catch
{
}
finally
{
conn.Close();
}
return(false);
}
public Article(int ID, string Name, string Text, AuthorUser Author, string DateAdded)
{
this.ID = ID;
this.Name = Name;
this.Text = Text;
this.Author = Author;
this.DateAdded = DateAdded;
}
protected void btnPlaceArticle_Click(object sender, EventArgs e)
{
string titel = tbArticleTitel.Text;
string text = tbArticleText.Text;
//als user een author is, wordt deze ook als author gecast en meegegeven aan het artikel.
if (user is AuthorUser)
{
AuthorUser author = user as AuthorUser;
Article article = new Article(1, titel, text, author, DateTime.Now.ToShortDateString());
ctrl.AddArticle(article, author);
lblMessage.Text = "het plaatsen van het artikel is gelukt";
}
else
{
lblMessage.Text = "Alleen een auteur kan artikelen plaatsen";
}
}
public List <Article> GetAllArticles()
{
string sql = "Select * FROM Article";
OracleCommand command = new OracleCommand(sql, conn);
command.CommandType = System.Data.CommandType.Text;
try
{
conn.Open();
List <Article> databaseArticles = new List <Article>();
OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int ArticleID = reader.GetInt32(0);
string Naam = reader["Naam"].ToString();
string Text = reader["Text"].ToString();
string Authorname = reader["Author"].ToString();
string Date = reader["DateAdded"].ToString();
User user = GetAuthorUser(Authorname);
AuthorUser author = user as AuthorUser; //dit werkt zolang author naam uniek is, beter author enkel als naam string meegeven aan article?
Article article = new Article(ArticleID, Naam, Text, author, Date);
databaseArticles.Add(article);
}
return(databaseArticles);
}
catch
{
}
finally
{
conn.Close();
}
return(null);
}
public Article GetArticle(int ID)
{
String cmd = "Select * from ARTICLE Where ArticleID = :ID";
OracleCommand command = new OracleCommand(cmd, conn);
command.CommandType = System.Data.CommandType.Text;
command.Parameters.Add(":ID", ID);
try
{
conn.Open();
OracleDataReader reader = command.ExecuteReader();
reader.Read();
int ArticleID = Convert.ToInt32(reader["ArticleID"]);
string Naam = reader["Naam"].ToString();
string Text = reader["Text"].ToString();
string Author = reader["Author"].ToString();
string DateAdded = reader["DateAdded"].ToString();
User user = GetAuthorUser(Author);
AuthorUser author = user as AuthorUser;
Article article = new Article(ArticleID, Naam, Text, author, DateAdded);
return(article);
}
catch
{
}
finally
{
conn.Close();
}
return(null);
}
public User GetAuthorUser(string accountname)
{
String cmd = "Select g.UserID, g.LoginName, g.Naam, g.Birthday, g.Gender, g.Email, g.Soort, au.AddedArticles From GEBRUIKER g, AUTHOR au Where g.LoginName = :LoginName and au.UserID = g.UserID";
OracleCommand command = new OracleCommand(cmd, conn);
command.CommandType = System.Data.CommandType.Text;
command.Parameters.Add(":LoginName", accountname);
try
{
conn.Open();
OracleDataReader reader = command.ExecuteReader();
reader.Read();
int UserID = Convert.ToInt32(reader["UserID"]);
string LoginName = reader["LoginName"].ToString();
string name = reader["Naam"].ToString();
string Birthday = reader["Birthday"].ToString();
string Gender = reader["Gender"].ToString();
string Email = reader["Email"].ToString();
string Soort = reader["Soort"].ToString();
int amountofarticles = Convert.ToInt32(reader["AddedArticles"]);
User user = new AuthorUser(UserID, name, Birthday, Email, LoginName, Gender, Soort, amountofarticles);
user.LoginName = accountname;
return(user);
}
catch
{
}
finally
{
conn.Close();
}
return(null);
}
//voegt artikel toe aan lijst van artikelen, ook db functie toevoegen
public bool AddArticle(Article article, AuthorUser author)
{
articles.Add(article);
db.AddArticle(article, author);
return(true);
}
