protected void btnUpload_Click(object sender, EventArgs e) { Managerment_PageEntities db = new Managerment_PageEntities(); string sTenFile; int idAccount = Convert.ToInt32(Request.Params["idAccount"].ToString()); Account_Detail getOldNameImg = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); string imgAccountOld = getOldNameImg.imgAccount.ToString(); if (imgAccountOld.Equals("default-avatar.jpg") == false) { string filePath = MapPath("~/img/account/" + imgAccountOld); if (File.Exists(filePath)) { File.Delete(filePath); } } //Tách lấy tên tập tin sTenFile = FileUpload1.FileName; //Thực hiện chép tập tin lên thư mục Upload FileUpload1.SaveAs(MapPath("~/img/account/" + sTenFile)); lblNotice.Text = "Đã upload thành công"; Account_Detail acc_detail = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); acc_detail.imgAccount = sTenFile; db.SaveChanges(); GetData(); }
protected void CreateAccount_Click(object sender, EventArgs e) { string username = txtusername.Text; string password = getMd5Hash(txtpassword.Text); string fullname = txtFullname.Text; string DOB = txtDOB.Text; string Address = txtAddress.Text; string Email = txtEmail.Text; Managerment_PageEntities db = new Managerment_PageEntities(); Account newAccount = new Account(); newAccount.username = username; newAccount.password = password; db.Accounts.Add(newAccount); db.SaveChanges(); Account acc = db.Accounts.FirstOrDefault(x => x.username == username); int idAccount = acc.idAccount; Account_Detail newaccount_Detail = new Account_Detail(); newaccount_Detail.idAccount = idAccount; newaccount_Detail.fullname = fullname; newaccount_Detail.DOB = Convert.ToDateTime(DOB); newaccount_Detail.Address = Address; newaccount_Detail.Email = Email; newaccount_Detail.status = false; newaccount_Detail.imgAccount = "default-avatar.jpg"; db.Account_Detail.Add(newaccount_Detail); db.SaveChanges(); LoadData(); DeleteForm(); }
protected void btnXoa_Command(object sender, CommandEventArgs e) { int idAccount = int.Parse(e.CommandArgument.ToString()); Managerment_PageEntities db = new Managerment_PageEntities(); Account_Detail obj = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); db.Account_Detail.Remove(obj); db.SaveChanges(); Account objAcc = db.Accounts.FirstOrDefault(x => x.idAccount == idAccount); db.Accounts.Remove(objAcc); db.SaveChanges(); LoadData(); }
protected void btnEditAccount_Click(object sender, EventArgs e) { int idAccount = Convert.ToInt32(Request.Params["idAccount"].ToString()); string fullname = txtFullname.Text; string DOB = txtDOB.Text; string Address = txtAddress.Text; string Email = txtEmail.Text; Managerment_PageEntities db = new Managerment_PageEntities(); Account_Detail acc_detail = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); acc_detail.fullname = fullname; acc_detail.DOB = Convert.ToDateTime(DOB); acc_detail.Address = Address; acc_detail.Email = Email; db.SaveChanges(); lblNotice.Text = "Đã Cập nhật thông tin thành công!"; GetData(); }
protected void btnLogin_Click(object sender, EventArgs e) { string taikhoan = txtusername.Text; string matkhau = getMd5Hash(txtpassword.Text); if (taikhoan.Length == 0 && matkhau.Length == 0) { txtError.Text = "Vui lòng nhập tài khoản và mật khẩu!"; } else if (taikhoan.Length == 0) { txtError.Text = "Vui lòng nhập tài khoản!"; } else if (matkhau.Length == 0) { txtError.Text = "Vui lòng nhập mật khẩu!"; } else { Managerment_PageEntities db = new Managerment_PageEntities(); int check = db.Accounts.Count(x => x.username == taikhoan && x.password == matkhau); Account acc = db.Accounts.FirstOrDefault(x => x.username == taikhoan); int idAccount = Convert.ToInt32(acc.idAccount.ToString()); Account_Detail acc_detail = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); Boolean checkStatus = Convert.ToBoolean(acc_detail.status.ToString()); if (check == 1) { if (checkStatus == true) { Session["username"] = taikhoan; Response.Redirect("Index_ManagermentPage.aspx"); } else { txtError.Text = "Tài khoản của bạn đã bị Vô hiệu hóa!"; } } else { txtError.Text = "Tài khoản và mật khẩu sai!"; } } }
protected void btnUpdateStatus_Command(object sender, CommandEventArgs e) { int idAccount = int.Parse(e.CommandArgument.ToString()); Managerment_PageEntities db = new Managerment_PageEntities(); Account_Detail acc_detail = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); Boolean status = Convert.ToBoolean(acc_detail.status.ToString()); Boolean statusafterupdate = true; if (status == true) { statusafterupdate = false; } else { statusafterupdate = true; } acc_detail.status = statusafterupdate; db.SaveChanges(); LoadData(); }
void GetData() { int idAccount = Convert.ToInt32(Request.Params["idAccount"].ToString()); Managerment_PageEntities db = new Managerment_PageEntities(); Account acc = db.Accounts.FirstOrDefault(x => x.idAccount == idAccount); Account_Detail acc_detail = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); txtusername.Text = acc.username; txtFullname.Text = acc_detail.fullname; DateTime date = Convert.ToDateTime(acc_detail.DOB); string formatted = date.ToString("yyyy-MM-dd"); txtDOB.Text = formatted; txtAddress.Text = acc_detail.Address; txtEmail.Text = acc_detail.Email; img.ImageUrl = "img/account/" + acc_detail.imgAccount; List <Comic> listComic = db.Comics.Where(x => x.idAccount == idAccount).ToList(); dgvComic.DataSource = listComic; dgvComic.DataBind(); }
void LoadData() { if (Session["username"] == null) { Response.Redirect("Login.aspx"); } else { string username = Session["username"].ToString(); Managerment_PageEntities db = new Managerment_PageEntities(); Account obj = db.Accounts.FirstOrDefault(x => x.username == username); int idAccount = obj.idAccount; Account_Detail obj2 = db.Account_Detail.FirstOrDefault(y => y.idAccount == idAccount); Username.Text = obj2.fullname; string queryimg = "select imgAccount from Account_Detail where idAccount='" + idAccount + "'"; SqlCommand cmd2 = new SqlCommand(queryimg, conn); conn.Open(); img.ImageUrl = "img/account/" + cmd2.ExecuteScalar().ToString(); conn.Close(); } }
void LoadData() { int idComic = Convert.ToInt32(Request.Params["idComic"]); Managerment_PageEntities db = new Managerment_PageEntities(); Comic obj = db.Comics.FirstOrDefault(x => x.idComic == idComic); txtIdComic.Text = obj.idComic.ToString(); txtnameComic.Text = obj.nameComic.ToString(); cmbNameType.SelectedValue = obj.idTypeComic.ToString(); txtDecription.Text = obj.decription.ToString(); txtAuthor.Text = obj.author.ToString(); int idAccount = Convert.ToInt32(obj.idAccount.ToString()); Account_Detail obj2 = db.Account_Detail.FirstOrDefault(x => x.idAccount == idAccount); txtPoster.Text = obj2.fullname.ToString(); List <Chuong> data = db.Chuongs.Where(x => x.idComic == idComic).ToList(); dgvChuong.DataSource = data; dgvChuong.DataBind(); Comic obj3 = db.Comics.FirstOrDefault(x => x.idComic == idComic); img.ImageUrl = "img/Comic/" + obj3.imgComic.ToString(); }