protected void CreateUser_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();
User newUser = new User();
newUser.username = username;
newUser.password = password;
db.Users.Add(newUser);
db.SaveChanges();
User acc = db.Users.FirstOrDefault(x => x.username == username);
int idAccount = acc.idAccount;
User_Detail newuser_Detail = new User_Detail();
newuser_Detail.idAccount = idAccount;
newuser_Detail.fullname = fullname;
newuser_Detail.DOB = Convert.ToDateTime(DOB);
newuser_Detail.Address = Address;
newuser_Detail.Email = Email;
newuser_Detail.status = false;
newuser_Detail.imgAccount = "default-avatar.jpg";
db.User_Detail.Add(newuser_Detail);
db.SaveChanges();
LoadData();
}
protected void btnXoa_Command(object sender, CommandEventArgs e)
{
int idAccount = int.Parse(e.CommandArgument.ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
User_Detail obj = db.User_Detail.FirstOrDefault(x => x.idAccount == idAccount);
db.User_Detail.Remove(obj);
db.SaveChanges();
User objAcc = db.Users.FirstOrDefault(x => x.idAccount == idAccount);
db.Users.Remove(objAcc);
db.SaveChanges();
LoadData();
}
protected void btnUpload_Click(object sender, EventArgs e)
{
Managerment_PageEntities db = new Managerment_PageEntities();
string sTenFile;
int idAccount = Convert.ToInt32(Request.Params["idAccount"].ToString());
User_Detail getOldNameImg = db.User_Detail.FirstOrDefault(x => x.idAccount == idAccount);
string imgAccountOld = getOldNameImg.imgAccount.ToString();
if (imgAccountOld.Equals("default-avatar.jpg") == false)
{
string filePath = MapPath("~/img/customer/" + 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/customer/" + sTenFile));
lblNotice.Text = "Đã upload thành công";
User_Detail acc_detail = db.User_Detail.FirstOrDefault(x => x.idAccount == idAccount);
acc_detail.imgAccount = sTenFile;
db.SaveChanges();
LoadData();
}
protected void btnSubmitUpdatePassword_Click(object sender, EventArgs e)
{
string taikhoan = txtusernamemodel.Text;
string matkhaucu = getMd5Hash(txtoldpasswordmodel.Text);
string matkhaumoi = txtnewpasswordmodel.Text;
string rematkhaumoi = txtrenewpasswordmodel.Text;
Managerment_PageEntities db = new Managerment_PageEntities();
Account acc = db.Accounts.FirstOrDefault(x => x.username == taikhoan);
if (matkhaucu.Equals(acc.password.ToString()))
{
if (matkhaumoi.Equals(rematkhaumoi))
{
acc.password = getMd5Hash(matkhaumoi);
db.SaveChanges();
lbError.Text = "Đổi mật khẩu thành công!";
XoaThongTinModel();
}
else
{
lbError.Text = "Mật khẩu mới không khớp nhau!";
XoaThongTinModel();
}
}
else
{
lbError.Text = "Mật khẩu cũ không đúng!";
XoaThongTinModel();
}
}
protected void btnEditAccount_Click(object sender, EventArgs e)
{
try
{
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();
User_Detail user_detail = db.User_Detail.FirstOrDefault(x => x.idAccount == idAccount);
user_detail.fullname = fullname;
user_detail.DOB = Convert.ToDateTime(DOB);
user_detail.Address = Address;
user_detail.Email = Email;
db.SaveChanges();
lblNotice.Text = "Đã Cập nhật thông tin thành công!";
LoadData();
}
catch
{
lblNotice.Text = "Thất Bại!";
LoadData();
}
}
protected void btnDeleteComic_Command(object sender, CommandEventArgs e)
{
int idComic = int.Parse(e.CommandArgument.ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
Comic obj = db.Comics.FirstOrDefault(x => x.idComic == idComic);
db.Comics.Remove(obj);
db.SaveChanges();
LoadData();
}
protected void btnDeleteFavouriteComic_Command(object sender, CommandEventArgs e)
{
int idComic = int.Parse(e.CommandArgument.ToString());
int idAccount = Convert.ToInt32(Session["idKhachHang"].ToString());
ListFavourite lf = db.ListFavourites.FirstOrDefault(x => x.idComic == idComic && x.idAccount == idAccount);
db.ListFavourites.Remove(lf);
db.SaveChanges();
LoadData();
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
int idChuong = Convert.ToInt32(e.CommandArgument.ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
Chuong obj = db.Chuongs.FirstOrDefault(x => x.idChuong == idChuong);
db.Chuongs.Remove(obj);
db.SaveChanges();
LoadData();
getNameTypeComic();
}
protected void btnResetPassword_Command(object sender, CommandEventArgs e)
{
string passwordmacdinh = "admin123";
string password = getMd5Hash(passwordmacdinh);
int idAccount = int.Parse(e.CommandArgument.ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
User acc = db.Users.FirstOrDefault(x => x.idAccount == idAccount);
acc.password = password;
db.SaveChanges();
LoadData();
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string sTenFile;
int idComic = Convert.ToInt32(Request.Params["idComic"].ToString());
sTenFile = FileUpload1.FileName;
FileUpload1.SaveAs(MapPath("~/img/Comic/" + sTenFile));
lblNotice.Text = "Đã upload thành công";
Managerment_PageEntities db = new Managerment_PageEntities();
Comic obj = db.Comics.FirstOrDefault(x => x.idComic == idComic);
obj.imgComic = sTenFile;
db.SaveChanges();
LoadData();
getNameTypeComic();
}
protected void CreateChuong_Click(object sender, EventArgs e)
{
int idComic = Convert.ToInt32(Request.Params["idComic"]);
string tenChuong = txtTenChuong.Text;
string content = txtContent.Text;
Managerment_PageEntities db = new Managerment_PageEntities();
Chuong newChuong = new Chuong();
newChuong.idComic = idComic;
newChuong.tenChuong = tenChuong;
newChuong.content = content;
db.Chuongs.Add(newChuong);
db.SaveChanges();
LoadData();
getNameTypeComic();
}
protected void btnSaveContent_Click(object sender, EventArgs e)
{
int idChuong = Convert.ToInt32(Request.Params["idChuong"]);
string txtContentUpdate = txtContent.Text;
string txttenChuong = txtTenChuong.Text;
Managerment_PageEntities db = new Managerment_PageEntities();
Chuong obj = db.Chuongs.FirstOrDefault(x => x.idChuong == idChuong);
obj.tenChuong = txttenChuong;
obj.content = txtContentUpdate;
db.SaveChanges();
Status.Text = "Cập nhật thành công!";
/*Thread.Sleep(2000);
* Response.Redirect("DS_Truyen.aspx");*/
}
protected void btnUpdateComicDetail_Command(object sender, CommandEventArgs e)
{
int idComic = Convert.ToInt32(Request.Params["idComic"]);
string nameComic = txtnameComic.Text;
int typeComic = Convert.ToInt32(cmbNameType.SelectedValue);
string decription = txtDecription.Text;
string author = txtAuthor.Text;
Managerment_PageEntities db = new Managerment_PageEntities();
Comic obj = db.Comics.FirstOrDefault(x => x.idComic == idComic);
obj.nameComic = nameComic;
obj.idTypeComic = typeComic;
obj.decription = decription;
obj.author = author;
db.SaveChanges();
LoadData();
}
protected void btnUpdateStatus_Command(object sender, CommandEventArgs e)
{
int idComic = int.Parse(e.CommandArgument.ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
Chuong chuong = db.Chuongs.FirstOrDefault(x => x.idComic == idComic);
Boolean status = Convert.ToBoolean(chuong.status.ToString());
Boolean statusafterupdate = true;
if (status == true)
{
statusafterupdate = false;
}
else
{
statusafterupdate = true;
}
chuong.status = statusafterupdate;
db.SaveChanges();
LoadData();
}
protected void btnUpdateStatus_Command(object sender, CommandEventArgs e)
{
int idAccount = int.Parse(e.CommandArgument.ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
User_Detail acc_detail = db.User_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();
}
protected void CreateAccount_Click(object sender, EventArgs e)
{
string nameComic = txtNameComic.Text;
string typeofComic = cmbNameType.SelectedValue;
string decription = txtDecription.Text;
string author = txtAuthor.Text;
string username = Session["username"].ToString();
Managerment_PageEntities db = new Managerment_PageEntities();
Account obj = db.Accounts.FirstOrDefault(x => x.username == username);
int idAccount = obj.idAccount;
Comic newComic = new Comic();
newComic.nameComic = nameComic;
newComic.idTypeComic = Convert.ToInt32(typeofComic);
newComic.imgComic = "avatar.jpg";
newComic.decription = decription;
newComic.author = author;
newComic.idAccount = idAccount;
newComic.status = false;
db.Comics.Add(newComic);
db.SaveChanges();
LoadData();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
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();
lbError.Text = "Cập nhật thành công!";
LoadData();
}
catch
{
lbError.Text = "Cập nhật thất bại!";
}
}