protected void Page_Load(object sender, EventArgs e)
{
var cur_user = (user)Session["current_user"];
if (cur_user != null)
{
using (var myDb = new ceng396())
{
var current = (from u in myDb.user
where u.user_id == cur_user.user_id
select u).SingleOrDefault();
LabelFname.Text = cur_user.fname;
LabelLname.Text = cur_user.lname;
LabelEmail.Text = cur_user.email;
LabelDep.Text = cur_user.major;
LabelFac.Text = cur_user.faculty;
LabelSchool.Text = cur_user.school;
LabelUserName.Text = cur_user.username;
Image1.ImageUrl = "data:image;base64," + Convert.ToBase64String(current.profile_photo);
Image1.Height = 100;
Image1.Width = 100;
}
}
else
{
Response.Redirect("Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
var current_user = (user)Session["current_user"];
Session["current_user"] = current_user;
if (current_user != null)
{
Session["current_user"] = current_user;
using (var myDb = new ceng396())
{
int itemid = Convert.ToInt32(Request.QueryString["id"]);
var itm = (from u in myDb.item
where u.item_id == itemid
select u).Single();
var currentimg = (from u in myDb.image
where u.item_id == itm.item_id
select u).Single();
int id = Convert.ToInt32(Request.QueryString["id"]);
Label1.Text = itm.title;
Label2.Text = itm.description;
Image1.ImageUrl = "data:image;base64," + Convert.ToBase64String(currentimg.img);
Image1.Height = 300;
Image1.Width = 300;
}
}
else
{
Response.Redirect("Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
var cur_user = (user)Session["current_user"];
Session["current_user"] = cur_user;
if (cur_user != null)
{
using (var myDb = new ceng396())
{
var allitems = (from u in myDb.item
where u.seller_id == cur_user.user_id
select u).ToList();
string code = "";
string url = "";
ContentPlaceHolder c = Page.Master.FindControl("ContentPlaceHolder1") as ContentPlaceHolder;
if (allitems.Count == 0)
{
Label1.Text = "Products are empty!";
Label1.Visible = true;
}
else
{
var i = 0;
foreach (var x in allitems)
{
var img1 = (from u in myDb.image
where u.item_id == x.item_id
select u.img).SingleOrDefault();
LiteralControl l = new LiteralControl();
code = "<div class='card' style='width: 20rem;'>";
l.Text = code;
c.Controls.Add(l);
c.FindControl("card");
LiteralControl l1 = new LiteralControl();
Image img = new Image();
img.ImageUrl = "data:image;base64," + Convert.ToBase64String(img1);
img.Height = 100;
img.Width = 100;
var id = "imge" + i.ToString();
img.ID = id;
c.FindControl(id);
img.CssClass = "card-img-top";
c.Controls.Add(img);
c.FindControl("imge");
url = "EditItem.aspx?id=" + x.item_id;
LiteralControl l2 = new LiteralControl();
code = "<div class='card-body'><h5 class='card-title'" + x.title + "</h5><p class='card-text'>" + x.description + "</p><a href ='" + url + "'class='btn btn-primary custom'>EditProduct</a></div></div>";
l2.Text = code;
c.Controls.Add(l2);
i++;
}
}
}
}
else
{
Response.Redirect("Login.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var myDB = new ceng396())
{
var user = (from u in myDB.user
select u).ToList();
if (Page.IsPostBack)
{
HttpPostedFile postedfile = FileUpload1.PostedFile;
string filename = Path.GetFileName(postedfile.FileName);
string fileextension = Path.GetExtension(filename);
if (fileextension.ToLower() == ".jpg" || fileextension.ToLower() == ".jpeg" || fileextension.ToLower() == ".png")
{
Stream stream = postedfile.InputStream;
BinaryReader binaryreader = new BinaryReader(stream);
byte[] bytes = binaryreader.ReadBytes((int)stream.Length);
var newuser = new user();
foreach (var x in user)
{
if (newuser.email == x.email)
{
Label1.Text = "Entered email is already in the database!";
Label1.Visible = true;
Response.Redirect("Register.aspx");
}
}
newuser.fname = TextBoxFname.Text;
newuser.lname = TextBoxLname.Text;
newuser.email = TextBoxEmail.Text;
newuser.school = DropDownList1.SelectedItem.Text;
newuser.faculty = DropDownList2.SelectedItem.Text;
newuser.major = DropDownList3.SelectedItem.Text;
newuser.username = TextBoxUserName.Text;
newuser.password = TextBoxPass.Text;
newuser.is_admin = false;
newuser.profile_photo = bytes;
myDB.user.Add(newuser);
myDB.SaveChanges();
Response.Write("Congratulations you are registered!");
Response.Redirect("Login.aspx");
Label1.Visible = true;
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var myDb = new ceng396())
{
var user = (user)Session["current_user"];
chat q = new chat();
q.sender_message = TextBox2.Text;
q.receiver_message = TextBox1.Text;
q.sender_id = user.user_id;
q.receiver_id = 2;
myDb.chat.Add(q);
myDb.SaveChanges();
Session["curuser"] = q;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var current_user = (user)Session["current_user"];
Session["current_user"] = current_user;
using (var myDb = new ceng396())
{
int itemid = Convert.ToInt32(Request.QueryString["id"]);
var itm = (from u in myDb.item
where u.item_id == itemid
select u).Single();
myDb.item.Remove(itm);
myDb.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var myDb = new ceng396())
{
var allusers = (from u in myDb.user
select u).ToList();
ContentPlaceHolder c = Page.Master.FindControl("ContentPlaceHolder1") as ContentPlaceHolder;
foreach (var x in allusers)
{
Label label = new Label();
label.Text = x.fname + " " + x.lname + " (" + x.username + ") " + " <br>";
c.Controls.Add(label);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var cur_user = (user)Session["current_user"];
Session["current_user"] = cur_user;
using (var myDb = new ceng396())
{
var user = (from u in myDb.user
where u.user_id == cur_user.user_id
select u).Single();
LabelFname.Text = user.fname;
LabelLname.Text = user.lname;
LabelEmail.Text = user.email;
LabelUserName.Text = user.username;
LabelDep.Text = user.major;
LabelFac.Text = user.faculty;
LabelSchool.Text = user.school;
TextBoxPass.Text = cur_user.password;
TextBoxUserName.Text = cur_user.username;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var myDB = new ceng396())
{
var cur_user = (user)Session["current_user"];
Session["current_user"] = cur_user;
item newitem = new item();
newitem.seller_id = cur_user.user_id;
newitem.title = TextBoxTitle.Text;
newitem.description = TextBoxDescription.Text;
int a = DropDownList1.SelectedIndex;
newitem.item_type_id = a;
HttpPostedFile postedfile1 = FileUpload1.PostedFile;
string filename1 = Path.GetFileName(postedfile1.FileName);
string fileextension1 = Path.GetExtension(filename1);
myDB.item.Add(newitem);
myDB.SaveChanges();
var c_item = (from u in myDB.item
where u.title == TextBoxTitle.Text && u.description == TextBoxDescription.Text
select u).SingleOrDefault();
Stream stream = postedfile1.InputStream;
BinaryReader binaryreader1 = new BinaryReader(stream);
byte[] bytes1 = binaryreader1.ReadBytes((int)stream.Length);
image newimage = new image();
newimage.img = bytes1;
newimage.item_id = c_item.item_id;
myDB.image.Add(newimage);
myDB.SaveChanges();
}
Response.Write("Item Successfully Added");
Response.Redirect("AdminHome.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
HttpPostedFile postedfile = FileUpload1.PostedFile;
string filename = Path.GetFileName(postedfile.FileName);
string fileextension = Path.GetExtension(filename);
if (fileextension.ToLower() == ".jpg" || fileextension.ToLower() == ".jpeg" || fileextension.ToLower() == ".png")
{
Stream stream = postedfile.InputStream;
BinaryReader binaryreader = new BinaryReader(stream);
byte[] bytes = binaryreader.ReadBytes((int)stream.Length);
var cur_user = (user)Session["current_user"];
Session["current_user"] = cur_user;
using (var myDb = new ceng396())
{
var user = (from u in myDb.user
where u.user_id == cur_user.user_id
select u).Single();
if (TextBoxUserName.Text != null)
{
user.username = TextBoxUserName.Text;
}
if (TextBoxPass.Text != null)
{
user.password = TextBoxPass.Text;
}
if (postedfile != null)
{
user.profile_photo = bytes;
}
myDb.SaveChanges();
}
Response.Redirect("Profil.aspx");
}
}
protected void Button_Click(object sender, System.EventArgs e)
{
using (var myDB = new ceng396())
{
var loggeduser = (from u in myDB.user
where u.username == TextBoxUserName.Text && u.password == TextBoxPass.Text
select u).SingleOrDefault();
if (loggeduser != null && loggeduser.is_admin)
{
Session["current_user"] = loggeduser;
Response.Redirect("AdminHome.aspx");
}
else if (loggeduser != null)
{
Session["current_user"] = loggeduser;
Response.Redirect("HomePage.aspx");
}
else
{
if (TextBoxUserName.Text == "")
{
Label1.Text = "Username cannot be empty!";
}
if (TextBoxPass.Text == "")
{
Label2.Text = "Password cannot be empty!";
}
else
{
Label1.Text = "Email or password is incorrect!";
Response.Write("Logging in!");
Response.Redirect("Login.aspx");
}
}
}
}
