protected void btn_savePassword_Click(object sender, EventArgs e) { var item = from u in db.tbl_users where u.UserID == int.Parse(Session["userID"].ToString()) select u; foreach (var z in item) { if (TextBoxPasswordOld.Text != z.Password) { lbl_introPass.Text = "Please enter old password correctly!"; return; } } if (isCorrectPassword()) { foreach (var z in item) { z.Password = TextBoxPassword.Text; db.SubmitChanges(); } lnkbtn_changePassword.Visible = true; lbl_passwordAgain.Visible = false; lbl_passwordOld.Visible = false; TextBoxPassagain.Visible = false; TextBoxPasswordOld.Visible = false; TextBoxPassword.Visible = false; btn_savePassword.Visible = false; lbl_introPass.ForeColor = Color.Green; lbl_introPass.Text = "Your password has been changed successfully!"; } }
protected void Btn_Barrow_Click(object sender, EventArgs e) { if (Session["cart"] != null) { tbl_order ne = new tbl_order(); ne.UserID = int.Parse(Session["userID"].ToString()); ne.StartDate = DateTime.Now; ne.State = "Waiting"; db.tbl_orders.InsertOnSubmit(ne); db.SubmitChanges(); var item = from o in db.tbl_orders select o; int id = 0; foreach (var z in item) { id = z.OrderID; } string cart = Session["cart"].ToString(); string[] crt = cart.Split('+'); for (int i = 0; i < crt.Length; i++) { tbl_indexOrder n = new tbl_indexOrder(); n.OrderID = id; n.BookID = int.Parse(crt[i]); db.tbl_indexOrders.InsertOnSubmit(n); db.SubmitChanges(); } Session["cart"] = ""; Label1.Text = "Your Cart has sent succesfully"; Response.Redirect("Cart.aspx"); } }
protected void btn_addCategory_Click(object sender, EventArgs e) { if (TextBoxCategoryName.Text == "" || TextBoxCategoryName.Text.Length > 20) { lbl_intro.ForeColor = Color.Red; lbl_intro.Text = "Please Enter The Category Name That Length is Shorter Than 20!"; return; } var item = from u in db.tbl_Categories where u.CategoryName == TextBoxCategoryName.Text select u; foreach (var z in item) { lbl_intro.ForeColor = Color.Red; lbl_intro.Text = TextBoxCategoryName.Text + " Has Been Added Allready!"; return; } tbl_Category a = new tbl_Category(); a.CategoryName = TextBoxCategoryName.Text; db.tbl_Categories.InsertOnSubmit(a); db.SubmitChanges(); lbl_intro.ForeColor = Color.Green; lbl_intro.Text = TextBoxCategoryName.Text + " Has Added Successfuly!"; DropDownList1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox_title.Text.Length == 0) { lbl_info.ForeColor = Color.Red; lbl_info.Text = "Please enter new title!"; return; } else if (TextBox_content.Text.Length == 0) { lbl_info.ForeColor = Color.Red; lbl_info.Text = "Please enter new content!"; return; } tbl_New nw = new tbl_New(); nw.Title = TextBox_title.Text; nw.NewContent = TextBox_content.Text; nw.Date = DateTime.Now; lbl_info.ForeColor = Color.Green; lbl_info.Text = "New added Successfully!"; db.tbl_News.InsertOnSubmit(nw); db.SubmitChanges(); }
protected void Button1_Click(object sender, EventArgs e) { if (TextBox_title.Text.Length == 0) { lbl_info.ForeColor = Color.Red; lbl_info.Text = "Please enter new title!"; return; } else if (TextBox_content.Text.Length == 0) { lbl_info.ForeColor = Color.Red; lbl_info.Text = "Please enter new content!"; return; } string id = Request.QueryString["nid"]; var item = from u in db.tbl_News where u.NewID == int.Parse(id) select u; foreach (var z in item) { z.Title = TextBox_title.Text; z.NewContent = TextBox_content.Text; } db.SubmitChanges(); lbl_info.ForeColor = Color.Green; lbl_info.Text = "The New Has Been Updated Successfully"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["bid"] != null) { tbl_BlockedBook ne = new tbl_BlockedBook(); ne.BookId = int.Parse(Request.QueryString["bid"]); db.tbl_BlockedBooks.InsertOnSubmit(ne); db.SubmitChanges(); } var ite = from b in db.tbl_BlockedBooks select b.BookId; var item = from b in db.tbl_Books join c in db.tbl_Categories on b.CategoryID equals c.CategoryId where !ite.Contains(b.BookId) select new { b.BookId, b.BookTitle, b.Author, desc = b.BookDesc.Substring(0, 50) + "...", b.Year, b.Publisher, b.ImagePath, c.CategoryName, b.CategoryID }; DataList1.DataSource = item; DataList1.DataBind(); } }
protected void btn_accept_Click(object sender, EventArgs e) { bool flag = true; int oid = int.Parse(lbl_orderid.Text); var item = from i in db.tbl_indexOrders where i.OrderID == oid select i.BookID; var ite = from o in db.tbl_orders join x in db.tbl_indexOrders on o.OrderID equals x.OrderID where o.State == "Accepted" && item.Contains(x.BookID) select new { x.BookID }; foreach (var z in ite) { Label1.ForeColor = Color.Red; Label1.Text = "You cannot add this book Because, This book Barrowed please try again Later."; flag = false; } if (flag) { var it = from o in db.tbl_orders where o.OrderID == int.Parse(Request.QueryString["oid"].ToString()) select o; foreach (var z in it) { z.State = "Accepted"; db.SubmitChanges(); tbl_Message ne = new tbl_Message(); ne.message = "Your Order whose number is " + Request.QueryString["oid"].ToString() + " Has Been Accepted Succesfully"; ne.userID = z.UserID; ne.state = "Unreaded"; db.tbl_Messages.InsertOnSubmit(ne); db.SubmitChanges(); Response.Redirect("AcceptOrders.aspx"); } } }
protected void lnkbtn_delete_Click(object sender, EventArgs e) { for (int i = 0; i < GridView1.Rows.Count; i++) { if (((CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBoxSelect")).Checked) { var item = from u in db.tbl_users where u.UserName == GridView1.Rows[i].Cells[1].Text select u; foreach (var z in item) { db.tbl_users.DeleteOnSubmit(z); db.SubmitChanges(); } } } GridView1.DataBind(); lbl_intro.Text = "All Selected Supporters Have Been Deleted!"; }
protected void Session_Start(object sender, EventArgs e) { int b = int.Parse(Application["hit"].ToString()); totalNumberOfUsers += 1; b++; Application["hit"] = b; currentNumberOfUsers += 1; Session.Timeout = 90; if (Request.Cookies["userID"] != null) { tbl_AccountLog ne = new tbl_AccountLog(); int a = int.Parse(Request.Cookies["userID"].Value.ToString()); ne.UserID = a; ne.Date = DateTime.Now; ne.Type = "Log in"; db.tbl_AccountLogs.InsertOnSubmit(ne); db.SubmitChanges(); } }
protected void btn_Register_Click(object sender, EventArgs e) { if (TextBoxEmail.Text == "" || TextBoxName.Text == "" || TextBoxPassagain.Text == "" || TextBoxPassword.Text == "" || TextBoxSurname.Text == "" || TextBoxUsername.Text == "" || Calendar1.SelectedDate == null) { lbl_intro.Text = "Please fill empty places!"; return; } if (isThereUsername()) { lbl_intro.Text = "This username has already registered!"; return; } if (TextBoxUsername.Text.Length < 8 || TextBoxUsername.Text.Length > 15) { lbl_intro.Text = "The length of password should be 8-15 !"; return; } if (!isCorrectPassword()) { return; } if (TextBoxEmail.Text.IndexOf('@') == -1 || TextBoxEmail.Text.IndexOf('.', TextBoxEmail.Text.IndexOf('@')) == -1) { lbl_intro.Text = "Please enter correct E-mail adress!"; return; } if (Calendar1.SelectedDate.Year == 1) { lbl_intro.Text = "Please choose your birthday!"; return; } tbl_user newUser = new tbl_user(); newUser.UserName = TextBoxUsername.Text; newUser.Password = TextBoxPassword.Text; newUser.Name = TextBoxName.Text; newUser.Surname = TextBoxSurname.Text; newUser.Email = TextBoxEmail.Text; newUser.Birthday = Calendar1.SelectedDate; newUser.Type = 1; db.tbl_users.InsertOnSubmit(newUser); db.SubmitChanges(); Response.Redirect("Login.aspx"); }
protected void lnkbtnLogout_Click(object sender, EventArgs e) { if (Session["userID"] != null) { tbl_AccountLog ne = new tbl_AccountLog(); ne.UserID = int.Parse(Session["userID"].ToString()); ne.Date = DateTime.Now; ne.Type = "Log out"; db.tbl_AccountLogs.InsertOnSubmit(ne); db.SubmitChanges(); } Session["userID"] = null; Response.Cookies["userID"].Expires = DateTime.Now.AddDays(-1); Response.Redirect("Default.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["nid"] != null) { tbl_New ne = new tbl_New(); var item = from u in db.tbl_News where u.NewID == int.Parse(Request.QueryString["nid"]) select u; foreach (var z in item) { db.tbl_News.DeleteOnSubmit(z); } db.SubmitChanges(); } } }
protected void LinkButton1_Click(object sender, EventArgs e) { GenelDataContext db = new GenelDataContext(); for (int i = 0; i < GridView1.Rows.Count; i++) { if (((CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1")).Checked) { var item = from m in db.tbl_Messages where m.MessageID == int.Parse(GridView1.Rows[i].Cells[1].Text) select m; foreach (var z in item) { z.state = "Readed"; db.SubmitChanges(); GridView1.DataBind(); } } } }
protected void LinkButton1_Click(object sender, EventArgs e) { GenelDataContext db = new GenelDataContext(); for (int i = 0; i < GridView1.Rows.Count; i++) { if (((CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_Select")).Checked) { var item = from o in db.tbl_orders where o.OrderID == int.Parse(GridView1.Rows[i].Cells[1].Text) select o; foreach (var z in item) { z.State = "Done"; z.FinishDate = DateTime.Now; db.SubmitChanges(); GridView1.DataBind(); } } } }
protected void btn_Login_Click(object sender, EventArgs e) { if (txbox_password.Text == "" || txbox_Username.Text == "") { lbl_Intro.Text = "Please Fill The Empty Places!"; return; } var item = from x in db.tbl_users where x.UserName == txbox_Username.Text select x; int us = 0; foreach (var u in item) { us = 1; if (u.Password != txbox_password.Text) { lbl_Intro.Text = "You entered wrong password, Please try again!"; return; } } if (us == 0) { lbl_Intro.Text = "There is not such a username, Please click register button to register!"; return; } foreach (var u in item) { Session["userID"] = u.UserID; if (Session["userID"] != null) { tbl_AccountLog ne = new tbl_AccountLog(); ne.UserID = int.Parse(Session["userID"].ToString()); ne.Date = DateTime.Now; ne.Type = "Log in"; db.tbl_AccountLogs.InsertOnSubmit(ne); db.SubmitChanges(); } if (checkbox_rememberMe.Checked) { Response.Cookies["userID"].Value = u.UserID.ToString(); Response.Cookies["userID"].Expires = DateTime.Now.AddDays(30); } if (u.Type == 1 || u.Type == 3) { Response.Redirect("Default.aspx"); } else if (u.Type == 0) { Response.Redirect("DefaultAdmin.aspx"); } else { Response.Redirect("DefaultSupporter.aspx"); } } }
protected void btn_add_Click(object sender, EventArgs e) { lbl_intro.ForeColor = Color.Red; if (TextBoxTitle.Text.Length == 0 || TextBoxTitle.Text.Length > 50) { lbl_intro.Text = "Length of Title should be 1-50"; return; } if (ddl_category.SelectedIndex == -1) { lbl_intro.Text = "Please Choose Category!"; return; } if (TextBoxAuthor.Text.Length < 3) { lbl_intro.Text = "Author is too short!"; return; } int year; if (!int.TryParse(TextBoxYear.Text, out year)) { lbl_intro.Text = "Please enter year correctly!"; return; } if (year > DateTime.Now.Year || year < 1600) { lbl_intro.Text = "Year should be 1600-" + DateTime.Now.Year.ToString(); return; } if (TextBoxPublisher.Text.Length < 3) { lbl_intro.Text = "Publisher is too short!"; return; } if (TextBoxDesc.Text.Length < 50) { lbl_intro.Text = "Desc is too short!"; return; } if (!regexValidator.IsValid) { lbl_intro.Text = "Please Choose only .jpg .jpeg .png"; return; } tbl_Book newBook = new tbl_Book(); newBook.Author = TextBoxAuthor.Text; newBook.BookDesc = TextBoxDesc.Text; newBook.BookTitle = TextBoxTitle.Text; newBook.CategoryID = int.Parse(ddl_category.SelectedValue.ToString()); newBook.Publisher = TextBoxPublisher.Text; newBook.Year = year; newBook.ImagePath = "~/images/" + FileUploadImage.FileName; if (FileUploadImage.HasFile) { FileUploadImage.SaveAs(Server.MapPath("~/images/" + FileUploadImage.FileName)); } db.tbl_Books.InsertOnSubmit(newBook); db.SubmitChanges(); lbl_intro.ForeColor = Color.Green; lbl_intro.Text = newBook.BookTitle + " Has Been Added Successfully"; Response.Redirect("AdminBooks.aspx"); }
protected void btn_Update_Click(object sender, EventArgs e) { lbl_intro.ForeColor = Color.Red; if (TextBoxTitle.Text.Length == 0 || TextBoxTitle.Text.Length > 50) { lbl_intro.Text = "Length of Title should be 1-50"; return; } if (ddl_category.SelectedIndex == -1) { lbl_intro.Text = "Please Choose Category!"; return; } if (TextBoxAuthor.Text.Length < 3) { lbl_intro.Text = "Author is too short!"; return; } int year; if (!int.TryParse(TextBoxYear.Text, out year)) { lbl_intro.Text = "Please enter year correctly!"; return; } if (year > DateTime.Now.Year || year < 1600) { lbl_intro.Text = "Year should be 1600-" + DateTime.Now.Year.ToString(); return; } if (TextBoxPublisher.Text.Length < 3) { lbl_intro.Text = "Publisher is too short!"; return; } if (TextBoxDesc.Text.Length < 50) { lbl_intro.Text = "Desc is too short!"; return; } if (!regexValidator.IsValid) { lbl_intro.Text = "Please Choose only .jpg .jpeg .png"; return; } string id = Request.QueryString["bid"]; var item = from u in db.tbl_Books where u.BookId == int.Parse(id) select u; foreach (var z in item) { z.Author = TextBoxAuthor.Text; z.BookDesc = TextBoxDesc.Text; z.BookTitle = TextBoxTitle.Text; z.CategoryID = int.Parse(ddl_category.SelectedValue.ToString()); z.Publisher = TextBoxPublisher.Text; z.Year = year; if (FileUploadImage.HasFile) { z.ImagePath = "~/images/" + FileUploadImage.FileName; FileUploadImage.SaveAs(Server.MapPath("~/images/" + FileUploadImage.FileName)); } db.SubmitChanges(); lbl_intro.ForeColor = Color.Green; lbl_intro.Text = z.BookTitle + " Has Been Updated Successfully"; } }