private void btnCapNhat_Click(object sender, EventArgs e)
{
if (ctrl.KiemTra(txtHoTen, txtuser, txtpas, txtrepas, cmbQuyen))
{
group.Enabled = false;
listDSNguoiDung.Enabled = true;
btnThem.Enabled = true;
btnXoa.Enabled = true;
btnSua.Enabled = true;
btnCapNhat.Enabled = false;
btnBoQua.Visible = false;
if (adding == true)
{
NguoiDungInfo NguoiDung = ctrl.ControlToInfo(txtMa, txtHoTen, txtuser, txtpas, cmbQuyen);
if (ctrl.Them(NguoiDung))//Thêm thành công thì thêm một dòng trên LISTVIEW
{
listDSNguoiDung.Items.Add(ctrl.InfoToItem(NguoiDung));
}
}
else if (updating == true)
{
NguoiDungInfo NguoiDung = ctrl.ControlToInfo(txtMa, txtHoTen, txtuser, txtpas, cmbQuyen);
if (ctrl.Sua(NguoiDung))//Sửa thành công thì sửa một dòng trên LISTVIEW
{
ctrl.SuaListView(listDSNguoiDung, NguoiDung);
}
}
ctrl.HienThi(listDSNguoiDung);
}
}
protected void btn_login_Click(object sender, EventArgs e)
{
NguoiDungController kt = new NguoiDungController();
string ad = txt_user.Text;
NguoiDungInfo info = kt.Check_Login(txt_user.Text, txt_pass.Text);
if (info != null)
{
if (info.Quyen)
{
Session["TenDangNhap"] = info.TenDangNhap;
Response.Redirect("~/Admin/ADIndex.aspx");
}
else
{
Session["TenDangNhap"] = info.TenDangNhap;
}
Session["Email"] = info.Email;
Session["HoTen"] = info.HoTen;
Session["SDT"] = info.SDT;
Session["DiaChi"] = info.DiaChi;
Session["quyen"] = info.Quyen;
Response.Redirect("~/Home.aspx");
}
else
{
tb.Text = "Sai Tên Hoặc Mật Khẩu!";
}
}
public DataTable DangNhap(NguoiDungInfo nguoidung)
{
SqlCommand com = new SqlCommand("select * from nguoidung where [USER]=@user");
com.Parameters.Add("@user", SqlDbType.Char, 32).Value = nguoidung.Username;
ser.Load(com);
return(ser);
}
public bool Update(NguoiDungInfo info, string newPassword)
{
if (this.m_Data == null)
{
this.m_Data = new NguoiDungData();
}
return(this.m_Data.Update(info.MaNguoiDung, newPassword));
}
public ListViewItem InfoToItem(NguoiDungInfo NguoiDung)
{
ListViewItem item = new ListViewItem();
item.Text = NguoiDung.Ma.ToString();
item.SubItems.Add(NguoiDung.HoTen);
item.SubItems.Add(NguoiDung.Username);
item.SubItems.Add(NguoiDung.Password);
item.SubItems.Add(NguoiDung.Quyen.ToString());
return(item);
}
public NguoiDungInfo ControlToInfo(TextBox ma, TextBox ten, TextBox user, TextBox pass, ComboBox quyen)
{
NguoiDungInfo NguoiDung = new NguoiDungInfo();
NguoiDung.Ma = Convert.ToInt32(ma.Text);
NguoiDung.HoTen = ten.Text;
NguoiDung.Username = user.Text;
NguoiDung.Password = Md5(pass.Text);
NguoiDung.Quyen = quyen.Text.ToCharArray()[0];
return(NguoiDung);
}
public void RowToControl(ListView list, TextBox ma, TextBox ten, TextBoxX user, TextBoxX pass, ComboBoxEx quyen)
{
if (list.SelectedItems.Count > 0)
{
NguoiDungInfo NguoiDung = (NguoiDungInfo)list.SelectedItems[0].Tag;
ma.Text = NguoiDung.Ma.ToString();;
ten.Text = NguoiDung.HoTen;
user.Text = NguoiDung.Username;
pass.Text = NguoiDung.Password;
quyen.Text = NguoiDung.Quyen.ToString();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có muốn xóa " + (listDSNguoiDung.SelectedItems.Count > 1 ? listDSNguoiDung.SelectedItems.Count.ToString() + " " : "") + "dòng này không?", "Phòng", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
IEnumerator list = listDSNguoiDung.SelectedItems.GetEnumerator();
while (list.MoveNext())
{
ListViewItem item = (ListViewItem)list.Current;
NguoiDungInfo NguoiDung = (NguoiDungInfo)item.Tag;
ctrl.Xoa(NguoiDung);
}
}
ctrl.HienThi(listDSNguoiDung);
}
public NguoiDungInfo RowToInfo(DataRow row)
{
NguoiDungInfo NguoiDung = new NguoiDungInfo();
NguoiDung.Ma = Convert.ToInt32(row["MA"].ToString());
NguoiDung.HoTen = row["HOTEN"].ToString();
NguoiDung.Username = row["USER"].ToString();
NguoiDung.Password = row["PASS"].ToString();
NguoiDung.Quyen = row["QUYEN"].ToString().ToCharArray()[0];
return(NguoiDung);
}
/// <summary>
/// Sửa một dòng trên LISTVIEW có cùng Mã với phòng vừa sửa
/// </summary>
/// <param name="list">Listview cần sửa</param>
/// <param name="NguoiDung">Phòng có khóa cần sửa</param>
public void SuaListView(ListView list, NguoiDungInfo NguoiDung)
{
ListViewItem itemNguoiDung = InfoToItem(NguoiDung);
for (int i = 0; i < list.Items.Count; i++)
{
if (list.Items[i].Text == itemNguoiDung.Text)
{
//Thay đổi nội dung từng ô một trên dòng cần sửa
for (int j = 1; j < list.Items[i].SubItems.Count; j++)
{
list.Items[i].SubItems[j] = itemNguoiDung.SubItems[j];
}
}
}
}
protected void btn_DangKy_Click(object sender, EventArgs e)
{
NguoiDungInfo nd = layDuLieuForm();
NguoiDungController taikhoan = new NguoiDungController();
bool kt = taikhoan.NguoiDung_Insert(nd);
if (kt)
{
lbTB.Text = "Đăng ký thành công";
Response.Redirect("~/HienThi.aspx");
}
else
{
lbTB.Text = "Đăng ký thất bại";
}
}
public NguoiDungInfo layDuLieuForm()
{
string TenDN = txt_Ten.Text;
string MatKhau = txtMatKhau.Text;
string HoTen = txtHoTen.Text;
string Email = txtEmail.Text;
NguoiDungInfo info = new NguoiDungInfo
{
TenDN = TenDN.ToString(),
MatKhau = MatKhau.ToString(),
HoTen = HoTen.ToString(),
Email = Email.ToString()
};
return(info);
}
public bool Xoa(NguoiDungInfo NguoiDung)
{
SqlCommand command = new SqlCommand("Delete NguoiDung where MA = @ma");
command.Parameters.Add("@ma", SqlDbType.Int).Value = NguoiDung.Ma;
try
{
ser.Load(command);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
protected void btn_DangNhap_Click(object sender, EventArgs e)
{
NguoiDungController kt = new NguoiDungController();
string ten = txtTen.Text;
NguoiDungInfo info = kt.Check_Login(txtTen.Text, txtMatKhau.Text);
if (info != null)
{
Session["TenDN"] = info.TenDN;
Session["HoTen"] = info.HoTen;
Session["NgaySinh"] = info.NgaySinh;
Session["GioiTinh"] = info.GioiTinh;
Session["DiaChi"] = info.DiaChi;
Session["Email"] = info.Email;
Response.Redirect("~/Home.aspx");
}
else
{
lbTB.Text = "Sai Tên Hoặc Mật Khẩu!";
}
}
public bool Them(NguoiDungInfo NguoiDung)
{
SqlCommand command = new SqlCommand("insert into NGUOIDUNG(MA,HOTEN,[USER],PASS,QUYEN)"
+ " values(@ma,@hoten,@user,@pass,@quyen)");
command.Parameters.Add("@ma", SqlDbType.Int).Value = NguoiDung.Ma;
command.Parameters.Add("@hoten", SqlDbType.NVarChar, 30).Value = NguoiDung.HoTen;
command.Parameters.Add("@user", SqlDbType.VarChar, 32).Value = NguoiDung.Username;
command.Parameters.Add("@pass", SqlDbType.VarChar, 32).Value = NguoiDung.Password;
command.Parameters.Add("@quyen", SqlDbType.Char, 1).Value = NguoiDung.Quyen;
try
{
ser.Load(command);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
/// <summary>
/// Kiem tra thong tin dang nhap va neu dang nhap thanh cong thi hien thi theo phan quyen
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public int CheckLogin(string tendangnhap, string matkhau)
{
//QLDiemSoHocSinhTHPT.Controlller.UserControl ctrlUser = new QLHocSinh.Control.UserControl();
NguoiDungController ctrlNguoiDung = new NguoiDungController();
NguoiDungInfo infoNguoiDung = ctrlNguoiDung.LayNguoiDung(tendangnhap);
//Neu tim thay username
if (infoNguoiDung != null)
{
//Neu password dung
if (infoNguoiDung.MatKhau == matkhau)
{
//Gan thong tin user vua dang nahp vao bien toan cuc de tien su dung
Utilities.TTNguoiDungDangNhap = infoNguoiDung;
//Disable Dang nhap va Enable Dang xuat
this.miDangNhap.Enabled = false;
this.miDangXuat.Enabled = true;
this.tiDangNhap.Enabled = false;
this.tiDangXuat.Enabled = true;
this.btDangNhap.Enabled = false;
this.btDangXuat.Enabled = true;
//Hien thi theo phan quyen
this.AuthorityShow();
return(0);
}
else //Password sai
{
Utilities.TTNguoiDungDangNhap = null;
return(1);
}
}
else //Khong ton tai username
{
Utilities.TTNguoiDungDangNhap = null;
return(2);
}
}
public bool Sua(NguoiDungInfo NguoiDung)
{
SqlCommand command = new SqlCommand("Update NguoiDung set HOTEN=@hoten,"
+ "[USER]=@user,PASS=@pass,QUYEN=@quyen" +
" where MA=@ma");
command.Parameters.Add("@ma", SqlDbType.Int).Value = NguoiDung.Ma;
command.Parameters.Add("@hoten", SqlDbType.NVarChar, 30).Value = NguoiDung.HoTen;
command.Parameters.Add("@user", SqlDbType.VarChar, 32).Value = NguoiDung.Username;
command.Parameters.Add("@pass", SqlDbType.VarChar, 32).Value = NguoiDung.Password;
command.Parameters.Add("@quyen", SqlDbType.Char, 1).Value = NguoiDung.Quyen;
try
{
ser.Load(command);
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
public void HienThi(ListView list)
{
NguoiDungData NguoiDung = new NguoiDungData();
list.Items.Clear();
DataTable table = NguoiDung.LayDSNguoiDung();
foreach (DataRow row in table.Rows)
{
NguoiDungInfo info = RowToInfo(row);
ListViewItem item = new ListViewItem();
item.Text = info.Ma.ToString();
item.SubItems.Add(info.HoTen);
item.SubItems.Add(info.Username);
item.SubItems.Add(info.Password);
item.SubItems.Add(info.Quyen.ToString());
item.Tag = info;
list.Items.Add(item);
}
//----------------
}
public int DangNhap(String username, String password)
{
DataTable pw = m_NguoiDungData.LayPassWord(password);
DataTable nd = m_NguoiDungData.LayNguoiDung(username);
if (nd.Rows.Count == 0)
{
return(0);
}
String matkhau_hethong = nd.Rows[0][3].ToString();
if (matkhau_hethong != password)
{
return(1);
}
else
{
NguoiDungInfo ndinfo = new NguoiDungInfo(nd.Rows[0][0].ToString(), nd.Rows[0][1].ToString(), nd.Rows[0][2].ToString(), nd.Rows[0][3].ToString(), Convert.ToInt32(nd.Rows[0][4]));
staticClass.nguoidungStatic = ndinfo;
return(2);
}
}
public bool Them(NguoiDungInfo NguoiDung)
{
NguoiDungData data = new NguoiDungData();
return(data.Them(NguoiDung));
}
public bool Sua(NguoiDungInfo NguoiDung)
{
NguoiDungData data = new NguoiDungData();
return(data.Sua(NguoiDung));
}