protected void btnCreatePost_Click(object sender, EventArgs e)
{
string text = txtPost.Text;
DateTime dt = DateTime.Now; //gets current Date and Time from the system
if (txtPost.Text == String.Empty) //validation to make sure the textbox has been filled in
{
lblCreatePostMessage.Text = "You have not completed one or more required fields";
lblCreatePostMessage.Visible = true;
return;
}
SQLDatabase.DatabaseTable tPosts = new SQLDatabase.DatabaseTable("Posts");
SQLDatabase.DatabaseRow row = tPosts.NewRow();
row.Add("ID", tPosts.GetNextID().ToString()); // adding all the information neccessary to create a post in the db
row.Add("Text", text);
row.Add("CreatorID", Session["UserID"].ToString()); //need to make it so it displays the user ID.
row.Add("CreatorName", Session["Name"].ToString());
row.Add("BoardID", Session["BoardID"].ToString()); //need to make it so it displays the user ID.
row.Add("BoardName", Session["BoardName"].ToString());
row.Add("DateCreated", dt.ToString("dddd, dd MMMM yyyy"));
row.Add("TimeCreated", dt.ToString("h: mm tt"));
tPosts.Insert(row);
Response.Redirect("Boards.aspx"); // takes you back to the boards page after you have created the post
}
protected void btnCreateBoard_Click(object sender, EventArgs e)
{
string subject = txtSubject.Text;
DateTime dt = DateTime.Now; //gets current Date and Time from the system
//Session["BoardName"] = subject; //stores the boardname in a session for later use
if (txtSubject.Text == String.Empty) // validation for empty textboxes
{
lblCreateBoardMessage.Text = "You have not completed one or more required fields";
lblCreateBoardMessage.Visible = true;
return;
}
SQLDatabase.DatabaseTable tBoards = new SQLDatabase.DatabaseTable("Boards");
SQLDatabase.DatabaseRow row = tBoards.NewRow();
row.Add("ID", tBoards.GetNextID().ToString()); // adds all the info needed to create a new board in the db
row.Add("Name", subject);
row.Add("CreatorID", Session["UserID"].ToString()); //need to make it so it displays the user ID.
row.Add("CreatorName", Session["Name"].ToString());
row.Add("DateCreated", dt.ToString("dddd, dd MMMM yyyy"));
row.Add("TimeCreated", dt.ToString("h: mm tt"));
tBoards.Insert(row);
Response.Redirect("Boards.aspx");
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string email = txtEmail.Text;
string password = txtPassword.Text;
DateTime dt = DateTime.Now; //gets current Date and Time from the system
SQLDatabase.DatabaseTable usernames = new SQLDatabase.DatabaseTable("Users", "SELECT * FROM Users");
for (int i = 0; i < usernames.RowCount; i++) //loops through the users table to validate if the username and password are linked to a user in the db
{
SQLDatabase.DatabaseRow row = usernames.GetRow(i);
if (row["Username"] == email && row["Password"] == password)
{
Session["TempLastLoginDate"] = row["LastLoginDate"]; //stores the last login date/time before they log in and it is updated.
Session["TempLastLoginTime"] = row["LastLoginTime"]; //this is to show them their last login date/time after they login
row.Add("LastLoginDate", dt.ToString("dddd, dd MMMM yyyy")); //updates their last login date/time to the current date/time
row.Add("LastLoginTime", dt.ToString("h: mm tt"));
usernames.Update(row);
Session["UserID"] = row["ID"]; //stores all their info in sessions for easy access later.
Session["Name"] = row["Name"];
Session["Username"] = row["Username"];
Session["UserType"] = row["UserType"];
Session["LastLoginDate"] = row["LastLoginDate"];
Session["LastLoginTime"] = row["LastLoginTime"];
Response.Redirect("Boards.aspx");
}
}
lblLogMessage.Text = "Username or Password not valid";
lblLogMessage.Visible = true;
}
protected void btnRegister_Click1(object sender, EventArgs e)
{
string id;
string email = txtEmail.Text;
string password = txtPassword.Text;
string displayName = txtDisplayName.Text;
string userType = "User";
bool emailFound = false;
bool nameFound = false;
if (txtDisplayName.Text == String.Empty || txtEmail.Text == String.Empty || txtPassword.Text == String.Empty) //validation for empty textboxes
{
lblRegMessage.Text = "You have not completed one or more required fields";
lblRegMessage.Visible = true;
return;
}
SQLDatabase.DatabaseTable tUsers = new SQLDatabase.DatabaseTable("Users");
SQLDatabase.DatabaseRow row = tUsers.NewRow();
row.Add("ID", tUsers.GetNextID().ToString()); // adds all required details to create a user
row.Add("Name", displayName);
row.Add("Username", email);
row.Add("Password", password);
row.Add("UserType", userType);
SQLDatabase.DatabaseTable usernames = new SQLDatabase.DatabaseTable("Users", "SELECT * FROM Users");
for (int i = 0; i < usernames.RowCount; i++) //loops through the user table to check if the inputted email is already taken by another user
{
if (usernames.GetRow(i)["Username"] == email)
{
emailFound = true;
break;
}
}
for (int n = 0; n < usernames.RowCount; n++) //loops through the user table to check if the inputted email is already taken by another user
{
if (usernames.GetRow(n)["Name"] == displayName)
{
nameFound = true;
break;
}
}
if (!emailFound && !nameFound) // if neither are duplicates then add the user
{
tUsers.Insert(row);
}
else
{
if (emailFound && !nameFound) //if email is taken but display name not, tell the user
{
lblRegMessage.Text = "That Email Address is already taken, please enter a different one.";
}
if (nameFound && !emailFound) //if display name is taken but email not, tell the user
{
lblRegMessage.Text = "That Display Name is already taken, please enter a different one.";
}
if (nameFound && emailFound) //if display name and email are taken, tell the user
{
lblRegMessage.Text = "That Display Name and Email Address is already taken, please enter a different one.";
}
lblRegMessage.Visible = true;
return;
}
SQLDatabase.User u = tUsers.GetUser(0); // stores the users into a class incase they are needed in the future
id = u.ID;
displayName = u.displayName;
email = u.email;
password = u.password;
u.userType = userType;
Response.Redirect("Default.aspx");
}
