protected void submitComment_Click(object sender, EventArgs e)
{
if (Session ["user"] == null)
{
Response.Redirect("~/Site/Login.aspx");
}
AlgonquinCollegeUser user = (AlgonquinCollegeUser)Session ["user"];
UInt64 productID = Convert.ToUInt64(Server.UrlDecode(Request.QueryString ["productID"]));
using (MySqlConnection database = new MySqlConnection(ConnectionStrings.DBConnectionString))
{
database.Open();
using (MySqlCommand insertComment = new MySqlCommand("Insert into comments (productID, commentName, commentRating, commentText) values (@productID, @commentName, @commentRating, @commentText)", database))
{
insertComment.Parameters.AddWithValue("@productID", productID);
insertComment.Parameters.AddWithValue("@commentName", user.FirstName + " " + user.LastName);
insertComment.Parameters.AddWithValue("@commentRating", Convert.ToInt16(rating.Text));
insertComment.Parameters.AddWithValue("@commentText", comment.Text.Trim());
insertComment.ExecuteNonQuery();
}
bindComments(database);
comment.Text = "";
rating.Text = "0";
}
}
protected void login_Authenticate(object sender, AuthenticateEventArgs e)
{
AuthenticateServiceSoapClient client = new AuthenticateServiceSoapClient();
client.Open();
AlgonquinCollegeUser user = client.AuthenticateUser(Server.HtmlDecode(login.UserName.Trim()), Server.HtmlDecode(login.Password.Trim()));
client.Close();
if (user == null)
{
e.Authenticated = false;
return;
}
e.Authenticated = true;
Session ["user"] = user;
if (Session ["previousPage"] == null)
{
System.Diagnostics.Debug.WriteLine("Not referred");
Response.Redirect("~/Site/Default.aspx");
}
else
{
string previousPage = Convert.ToString(Session ["previousPage"]);
Session.Remove("previousPage");
System.Diagnostics.Debug.WriteLine("Referred by: " + previousPage);
Response.Redirect(previousPage);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
return;
}
if (Session ["breadcrumb"] == null)
{
Session ["breadcrumb"] = new List <string> ();
}
List <string> breadcrumb = (List <string>)Session ["breadcrumb"];
string pageName = Path.GetFileName(Page.AppRelativeVirtualPath);
string pagePath = HttpContext.Current.Request.Url.AbsolutePath;
string pageLink = "<a href = \"" + pagePath + "\">" + pageName + "</a>";
if (!breadcrumb.Contains(pageLink))
{
breadcrumb.Add(pageLink);
}
for (Int32 pageIndex = 0; pageIndex < breadcrumb.Count; ++pageIndex)
{
visited.Text += breadcrumb.ElementAt(pageIndex);
}
if (Session ["user"] != null)
{
AlgonquinCollegeUser user = (AlgonquinCollegeUser)Session ["user"];
login.Text = "Welcome " + user.FirstName + " " + user.LastName + "!";
}
else
{
login.Text = "Would you like to <a href = \"Login.aspx\">login?</a>";
}
using (MySqlConnection database = new MySqlConnection(ConnectionStrings.DBConnectionString))
{
database.Open();
using (MySqlDataAdapter select = new MySqlDataAdapter(new MySqlCommand("Select * from categories", database)))
{
using (DataTable table = new DataTable())
{
select.Fill(table);
categories.DataSource = table;
categories.DataBind();
}
}
}
directory.Items.Clear();
directory.Items.Add(new ListItem("Home", "~/Site/Default.aspx"));
if (Session ["user"] == null)
{
directory.Items.Insert(1, new ListItem("Login", "~/Site/Login.aspx"));
}
else
{
directory.Items.Add(new ListItem("Cart", "~/Site/Cart.aspx"));
directory.Items.Add(new ListItem("Admin Home", "~/Admin/AdminDefault.aspx"));
}
if (Session ["user"] == null)
{
logout.Visible = false;
}
else
{
logout.Visible = true;
}
}