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();
}
