void LoadData()
{
int idAccount = Convert.ToInt32(Request.Params["idAccount"].ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
User acc = db.Users.FirstOrDefault(x => x.idAccount == idAccount);
User_Detail acc_detail = db.User_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/customer/" + acc_detail.imgAccount;
List <ListFavourite> listidFavourties = db.ListFavourites.Where(x => x.idAccount == idAccount).ToList();
List <Comic> viewList = new List <Comic>();
foreach (ListFavourite items in listidFavourties)
{
int idComic = Convert.ToInt32(items.idComic.ToString());
Comic comic = db.Comics.FirstOrDefault(x => x.idComic == idComic);
viewList.Add(comic);
}
dgvListFavourite.DataSource = viewList;
dgvListFavourite.DataBind();
}
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 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 imbLogin_Click(object sender, ImageClickEventArgs e)
{
if (txtName.Text != "" && txtPass.Text != "")
{
string taikhoan = txtName.Text;
string matkhau = getMd5Hash(txtPass.Text);
Managerment_PageEntities db = new Managerment_PageEntities();
int check = db.Users.Count(x => x.username == taikhoan && x.password == matkhau);
if (check == 1)
{
User acc = db.Users.FirstOrDefault(x => x.username == taikhoan);
int idAccount = Convert.ToInt32(acc.idAccount.ToString());
User_Detail acc_detail = db.User_Detail.FirstOrDefault(x => x.idAccount == idAccount);
Boolean checkStatus = Convert.ToBoolean(acc_detail.status.ToString());
if (checkStatus == true)
{
Session["idKhachHang"] = idAccount;
Response.Redirect("index.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!";
}
}
else
{
lbThongBao.Text = "Tên đăng nhập hoặc mật khẩu trống!";
}
}
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();
}
void LoadData()
{
Managerment_PageEntities db = new Managerment_PageEntities();
List <User_Detail> data = db.User_Detail.ToList <User_Detail>();
dgvUser.DataSource = data;
dgvUser.DataBind();
}
void LoadData()
{
Managerment_PageEntities db = new Managerment_PageEntities();
List <Account_Detail> data = db.Account_Detail.ToList <Account_Detail>();
dgvTaiKhoan.DataSource = data;
dgvTaiKhoan.DataBind();
}
void LoadData()
{
Managerment_PageEntities db = new Managerment_PageEntities();
List <Comic> data = db.Comics.ToList <Comic>();
dgvComic.DataSource = data;
dgvComic.DataBind();
getNameTypeComic();
}
protected void btnResetContent_Click(object sender, EventArgs e)
{
string idChuong = Request.Params["idChuong"].ToString();
Managerment_PageEntities db = new Managerment_PageEntities();
Chuong obj = db.Chuongs.FirstOrDefault(x => x.idChuong.ToString() == idChuong.ToString());
txtTenChuong.Text = obj.tenChuong.ToString();
txtContent.Text = obj.content.ToString();
}
void GetData()
{
int idChuong = Convert.ToInt32(Request.Params["idChuong"].ToString());
Managerment_PageEntities db = new Managerment_PageEntities();
Chuong obj = db.Chuongs.FirstOrDefault(x => x.idChuong == idChuong);
txtTenChuong.Text = obj.tenChuong.ToString();
txtContent.Text = obj.content.ToString();
}
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 btnProfile_Click(object sender, EventArgs e)
{
string username = Session["username"].ToString();
Managerment_PageEntities db = new Managerment_PageEntities();
Account obj = db.Accounts.FirstOrDefault(x => x.username == username);
int idAccount = obj.idAccount;
string url = "Profile.aspx?idAccount=" + idAccount;
Response.Redirect(url);
}
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();
}
void LoadData()
{
string query = "exec TinhTiLeTaiKhoan";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
string ketqua = cmd.ExecuteScalar().ToString();
conn.Close();
txtstatus.Text = ketqua + "%";
Label1.Text = "";
Label1.Text += "<div class='progress-bar bg-info' role='progressbar' runat='server' style='width:" + ketqua + "%; height: 100%;' aria-valuenow='" + ketqua + "' aria-valuemin='0' aria-valuemax='100'></div>";
string queryTiLETrang = "exec TinhTiLeComicActive";
SqlCommand cmd2 = new SqlCommand(queryTiLETrang, conn);
conn.Open();
float codeStatusTrang = float.Parse(cmd2.ExecuteScalar().ToString());
conn.Close();
Label2.Text = codeStatusTrang + "%";
Label3.Text = "<div class='progress-bar bg-info' role='progressbar' runat='server' style='width:" + codeStatusTrang + "%; height: 100%;' aria-valuenow='" + codeStatusTrang + "' aria-valuemin='0' aria-valuemax='100'></div>";
Managerment_PageEntities db = new Managerment_PageEntities();
int countComic = db.Comics.Count();
txtTotalComic.Text = countComic.ToString();
int countChapter = db.Chuongs.Count();
txtTotalChapter.Text = countChapter.ToString();
int countAccount = db.Accounts.Count();
txtTotalAccount.Text = countAccount.ToString();
int countUser = db.Users.Count();
txtTotalUser.Text = countUser.ToString();
string queryChuong = "exec TinhTiLeChuongActive";
SqlCommand cmd3 = new SqlCommand(queryChuong, conn);
conn.Open();
string ketquaChuong = cmd3.ExecuteScalar().ToString();
conn.Close();
txtStatusChuong.Text = ketquaChuong + "%";
Label4.Text = "<div class='progress-bar bg-info' role='progressbar' runat='server' style='width:" + ketquaChuong + "%; height: 100%;' aria-valuenow='" + ketquaChuong + "' aria-valuemin='0' aria-valuemax='100'></div>";
string queryUser = "******";
SqlCommand cmd4 = new SqlCommand(queryUser, conn);
conn.Open();
string ketquaUser = cmd4.ExecuteScalar().ToString();
conn.Close();
lbPercentUser.Text = ketquaUser + "%";
lbPercentUserBar.Text = "<div class='progress-bar bg-info' role='progressbar' runat='server' style='width:" + ketquaUser + "%; height: 100%;' aria-valuenow='" + ketquaUser + "' aria-valuemin='0' aria-valuemax='100'></div>";
}
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();
}
public string getURLAvatar(object idComic)
{
try
{
Managerment_PageEntities db = new Managerment_PageEntities();
Comic obj = db.Comics.FirstOrDefault(x => x.idComic.ToString() == idComic.ToString());
return("./img/comic/" + obj.imgComic);
}
catch
{
return("./img/comic/default-avatar.jpg");
}
}
public string getusernameUser(object idAccount)
{
try
{
Managerment_PageEntities db = new Managerment_PageEntities();
User obj = db.Users.FirstOrDefault(x => x.idAccount.ToString() == idAccount.ToString());
return(obj.username);
}
catch
{
return("Đã xóa");
}
}
public string getnameComic(object idComic)
{
try
{
Managerment_PageEntities db = new Managerment_PageEntities();
Comic obj = db.Comics.FirstOrDefault(x => x.idComic.ToString() == idComic.ToString());
return(obj.nameComic);
}
catch
{
return("Đã xóa");
}
}
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();
}
public void getNameTypeComic()
{
try
{
Managerment_PageEntities db = new Managerment_PageEntities();
List <Type_Comic> dataTypeComic = db.Type_Comic.ToList();
cmbNameType.DataSource = dataTypeComic;
cmbNameType.DataTextField = "nameTypeComic";
cmbNameType.DataValueField = "idTypeComic";
cmbNameType.DataBind();
}
catch
{
}
}
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 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 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 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!";
}
}
}
public string getStatus(object idComic)
{
try
{
Managerment_PageEntities db = new Managerment_PageEntities();
Comic obj = db.Comics.FirstOrDefault(x => x.idComic.ToString() == idComic.ToString());
if (obj.status == true)
{
return("Kích Hoạt");
}
else
{
return("Vô Hiệu Hóa");
}
}
catch
{
return("");
}
}
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();
}
public string getStatus(object idComic)
{
try
{
Managerment_PageEntities db = new Managerment_PageEntities();
Comic obj = db.Comics.FirstOrDefault(x => x.idComic.ToString() == idComic.ToString());
if (obj.status == true)
{
return("Đang kích hoạt!");
}
else
{
return("Vô hiệu hóa!");
}
}
catch
{
return("Không có!");
}
}