public TAI_KHOAN GetDVByMa(int pMa)
{
TAI_KHOAN result = new TAI_KHOAN();
result = context.TAI_KHOAN.FirstOrDefault(m => m.MA_TK == pMa);
return(result);
}
//cập nhật tiền khi thêm
public void update_tien_them(PHIEU_THU p)
{
TAI_KHOAN tk = qlt.TAI_KHOANs.Where(t => t.MATK == p.MATK).FirstOrDefault();
tk.SODUHT += p.TIEN;
qlt.SubmitChanges();
}
public TAI_KHOAN GetByUsername(string username)
{
TAI_KHOAN result = new TAI_KHOAN();
result = context.TAI_KHOAN.FirstOrDefault(m => m.USERNAME == username);
return(result);
}
private void ProccessLogin()
{
LoginResult res = dal_login.checkUser(txtTenDangNhap.Text, txtMatKhau.Text);
if (res == LoginResult.Invalid)
{
MessageBox.Show("Sai mật khẩu hoặc password !");
return;
}
if (res == LoginResult.Invalid)
{
MessageBox.Show("Tài khoảng bị khóa !");
return;
}
if (res == LoginResult.Success)
{
nhanVien = dal_login.getTaiKhoan(txtTenDangNhap.Text, txtMatKhau.Text);
if (Program.frmMain == null || Program.frmMain.IsDisposed)
{
Program.frmMain = new frmMain();
}
this.Visible = false;
Program.frmMain.Show();
}
}
private void Add()
{
var id = data.TAI_KHOANs.Where(u => u.TaiKhoan == txt_username.Text.Trim()).SingleOrDefault <TAI_KHOAN>();
if (id != null)
{
tb_thongbao.Text = "Tên Tài khoản đã tồn tại.";
return;
}
else
{
try
{
TAI_KHOAN tk = new TAI_KHOAN();
tk.TaiKhoan = txt_username.Text;
tk.MatKhau = txt_password.Text;
tk.MaLoai = int.Parse(cb_loai.SelectedValue.ToString());
data.TAI_KHOANs.InsertOnSubmit(tk);
data.SubmitChanges();
}
catch
{
}
finally
{
GetData();
}
}
}
protected void btn_dangky_Click(object sender, EventArgs e)
{
KHACH_HANG kh = new KHACH_HANG();
TAI_KHOAN tk = new TAI_KHOAN();
kh.PHONE = txt_phone.Text;
kh.EMAIL = txt_email.Text;
kh.TEN_KH = txt_name.Text;
if (khachHangService.Add(kh) == 1)
{
tk.MA_KH = kh.MA_KH;
tk.USERNAME = txt_username.Text;
byte[] pass = Encoding.ASCII.GetBytes(txt_password.Text);
tk.PASSWORD = pass;
tk.TRANG_THAI = true;
if (taiKhoanService.Add(tk) == 1)
{
lbResult.Visible = true;
lbResult.Text = "Đăng ký thành công";
hyperlink.Visible = true;
hyperlink.Text = "Chuyển sang trang login";
}
else
{
lbResult.Visible = true;
lbResult.Text = "Đăng ký không thành công";
}
}
else
{
lbResult.Visible = true;
lbResult.Text = "Đăng ký không thành công";
}
}
public int Add(TAI_KHOAN p)
{
int result = 0;
context.TAI_KHOAN.Add(p);
result = context.SaveChanges();
return(result);
}
public void create_TAI_KHOAN(string tk)
{
TAI_KHOAN tAI_KHOAN = new TAI_KHOAN();
tAI_KHOAN.TAI_KHOAN1 = tk;
tAI_KHOAN.MAT_KHAU = "123";
db.TAI_KHOAN.Add(tAI_KHOAN);
db.SaveChanges();
}
public int Delete(int pMa)
{
int result = 0;
TAI_KHOAN k = context.TAI_KHOAN.FirstOrDefault(m => m.MA_TK == pMa);
context.TAI_KHOAN.Remove(k);
result = context.SaveChanges();
return(result);
}
// kiểm tra trùng khóa chính
public int KT_KhoaChinh(string ma)
{
TAI_KHOAN tk = qlq.TAI_KHOANs.Where(t => t.MATK == ma).FirstOrDefault();
if (tk != null)
{
return(1);// trùng mã
}
return(0);
}
public int Them_TK(TAI_KHOAN tk)
{
try
{
qlq.TAI_KHOANs.InsertOnSubmit(tk);
qlq.SubmitChanges();
return(0);
}
catch (Exception ex) { return(1); }
}
public int KT_KhoaNgoai(int ma)
{
TAI_KHOAN tk = qlltk.TAI_KHOANs.Where(t => t.MA_LOAI_TK == ma).FirstOrDefault();
if (tk != null)
{
return(1);
}
return(0);
}
//kiểm tra khóa ngoại
public int KT_KhoaNgoai(string ma)
{
TAI_KHOAN a = qltt.TAI_KHOANs.Where(t => t.MALOAI == ma).FirstOrDefault();
if (a != null)//
{
return(1);
}
return(0);
}
public ActionResult DeleteConfirmed(string id)
{
GIAO_VIEN gIAO_VIEN = db.GIAO_VIEN.Find(id);
db.GIAO_VIEN.Remove(gIAO_VIEN);
TAI_KHOAN tAI_KHOAN = db.TAI_KHOAN.Find(id);
db.TAI_KHOAN.Remove(tAI_KHOAN);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//update tien khi cap nhat
public int update_tien_lan2(string matk, decimal?tiencu, decimal?tienmoi)
{
try
{
TAI_KHOAN tk = qlt.TAI_KHOANs.Where(t => t.MATK == matk).FirstOrDefault();
tk.SODUHT = tk.SODUHT - tiencu + tienmoi;
qlt.SubmitChanges();
return(1);
}
catch (Exception ex)
{ return(0); }
}
//xóa phiếu chi
public int Xoa_PhieuThu(string ma)
{
try
{
PHIEU_THU p = qlt.PHIEU_THUs.Where(t => t.MAPTHU == ma).FirstOrDefault();
TAI_KHOAN tk = qlt.TAI_KHOANs.Where(t => t.MATK == p.MATK).FirstOrDefault();
tk.SODUHT -= p.TIEN;
qlt.PHIEU_THUs.DeleteOnSubmit(p);
qlt.SubmitChanges();
return(0);
}
catch (Exception ex) { return(1); }
}
//xóa phiếu chi
public int Xoa_PhieuChi(string ma)
{
try
{
PHIEU_CHI p = qlc.PHIEU_CHIs.Where(t => t.MA_PCHI == ma).FirstOrDefault();
TAI_KHOAN tk = qlc.TAI_KHOANs.Where(t => t.MATK == p.MATK).FirstOrDefault();
tk.SODUHT += p.SO_TIEN;
qlc.PHIEU_CHIs.DeleteOnSubmit(p);
qlc.SubmitChanges();
return(0);
}
catch (Exception ex) { return(1); }
}
public int Update(TAI_KHOAN p)
{
int result = 0;
TAI_KHOAN k = context.TAI_KHOAN.FirstOrDefault(m => m.MA_TK == p.MA_TK);
if (k != null)
{
k.USERNAME = p.USERNAME;
k.PASSWORD = p.PASSWORD;
k.TRANG_THAI = p.TRANG_THAI;
}
result = context.SaveChanges();
return(result);
}
private void btn_luu_Click(object sender, EventArgs e)
{
try
{
if (btn_sua.Enabled == false) //đang thêm
{
if (txt_matk.Text == string.Empty)
{
MessageBox.Show("Vui lòng nhập mã tài khoản");
txt_matk.Focus();
return;
}
TAI_KHOAN tk = new TAI_KHOAN();
tk.MATK = txt_matk.Text;
tk.TENTK = txt_tentk.Text;
tk.MALOAI = cbo_tiente.SelectedValue.ToString();
tk.MANGUOIDUNG = manguoidung;
tk.SODUBD = (txt_sodubd.Text == null ? 0 : decimal.Parse(txt_sodubd.Text));
tk.SODUHT = tk.SODUBD;
tk.TRANGTHAI = true;
tk.DIENGIAI = txt_chuthich.Text;
tk.MA_LOAI_TK = int.Parse(cbo_loaitk.SelectedValue.ToString());
int kq = qlq.Them_TK(tk);
Load_DATA();
btn_luu.Enabled = false;
btn_sua.Enabled = btn_xoa.Enabled = true;
txt_matk.Enabled = txt_sodubd.Enabled = txt_soduht.Enabled = txt_tentk.Enabled = cbo_loaitk.Enabled = cbo_tiente.Enabled = txt_chuthich.Enabled = false;
if (kq == 0)
{
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Thêm thất bại");
}
}
if (btn_them.Enabled == false) //đang sửa
{
qlq.Sua_TK(txt_matk.Text, txt_tentk.Text, cbo_tiente.SelectedValue.ToString(), int.Parse(cbo_loaitk.SelectedValue.ToString()), decimal.Parse(txt_sodubd.Text), txt_chuthich.Text);
txt_matk.Enabled = txt_sodubd.Enabled = txt_soduht.Enabled = txt_tentk.Enabled = cbo_loaitk.Enabled = cbo_tiente.Enabled = txt_chuthich.Enabled = btn_luu.Enabled = false;
btn_xoa.Enabled = btn_them.Enabled = true;
Load_DATA();
MessageBox.Show("Sửa thành công");
}
}
catch (Exception ex)
{
}
}
// cập nhật tài khoản
public int Sua_TK(string ma, string ten, string maloai, int maloaitk, decimal sodubd, string chuthich)
{
TAI_KHOAN tk = qlq.TAI_KHOANs.Where(t => t.MATK == ma).FirstOrDefault();
tk.MATK = ma;
tk.TENTK = ten;
tk.MALOAI = maloai;
tk.MA_LOAI_TK = maloaitk;
tk.SODUBD = sodubd;
tk.SODUHT = sodubd + TienThu(ma) - TienChi(ma);
tk.DIENGIAI = chuthich;
qlq.SubmitChanges();
return(0);
}
public override bool ValidateUser(string username, string password)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username == username
select u;
if (user.Count() == 1)
{
TAI_KHOAN tk = user.Single();
if (tk.Password.Equals(CryptographicHelper.CreatePasswordHash(password, tk.Salt)))
{
return(true);
}
}
return(false);
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username == username
select u;
if (user.Count() == 1)
{
TAI_KHOAN tk = user.Single();
int userID = tk.MaTaiKhoan;
string email = tk.Email;
bool isLockedOut = false;
return(new CustomMembershipUser(username, userID, email, isLockedOut));
}
return(null);
}
//xóa tài khoản
public int Xoa_Tk(string ma)
{
TAI_KHOAN tk = qlq.TAI_KHOANs.Where(t => t.MATK == ma).FirstOrDefault();
if (KT_KhoaNgoai(ma) == 1)
{
return(1);
}
try
{
qlq.TAI_KHOANs.DeleteOnSubmit(tk);
qlq.SubmitChanges();
return(0);
}
catch (Exception ex)
{ return(1); }
}
public override string ResetPassword(string username, string answer)
{
string newPassword = "";
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username == username
select u;
if (user.Count() == 1)
{
//newPassword = CryptographicHelper.GenerateKey();
newPassword = Membership.GeneratePassword(10, 3);
TAI_KHOAN tk = user.Single();
tk.Password = CryptographicHelper.CreatePasswordHash(newPassword, tk.Salt);
dataContext.SubmitChanges();
}
return(newPassword);
}
private void Remove()
{
try
{
if (System.Windows.Forms.MessageBox.Show("Xác nhận xoá? ", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
TAI_KHOAN tk = data.TAI_KHOANs.Single(item => item.TaiKhoan == txt_username.Text);
data.TAI_KHOANs.DeleteOnSubmit(tk);
data.SubmitChanges();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
GetData();
}
}
private void Update()
{
TAI_KHOAN tk = (data.TAI_KHOANs.Where(t => t.TaiKhoan == txt_username.Text).SingleOrDefault <TAI_KHOAN>());
try
{
tk.MatKhau = txt_password.Text;
tk.MaLoai = int.Parse(cb_loai.SelectedValue.ToString());
data.SubmitChanges();
tb_thongbao.Text = "Chỉnh sửa thành công!";
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message, "Lỗi");
}
finally
{
GetData();
}
}
public override bool ChangePassword(string username, string oldPassword, string newPassword)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username == username
select u;
if (user.Count() == 1)
{
TAI_KHOAN tk = user.Single();
oldPassword = CryptographicHelper.CreatePasswordHash(oldPassword, tk.Salt);
newPassword = CryptographicHelper.CreatePasswordHash(newPassword, tk.Salt);
if (oldPassword == tk.Password && oldPassword != newPassword)
{
tk.Password = newPassword;
dataContext.SubmitChanges();
return(true);
}
}
return(false);
}
//Trả về vai trò và mã nhân viên
public override string[] GetRolesForUser(string username)
{
TRAVEL_WEBDataContext dataContext = new TRAVEL_WEBDataContext();
var user = from u in dataContext.TAI_KHOANs
where u.Username.Equals(username)
select u;
if (user.Count() == 1)
{
TAI_KHOAN tk = user.Single();
var loaitk = from l in dataContext.LOAI_TAI_KHOANs
where l.MaLoaiTaiKhoan == tk.LoaiTaiKhoan
select l;
if (loaitk.Count() == 1)
{
LOAI_TAI_KHOAN ltk = loaitk.Single();
return(new string[] { ltk.TenLoaiTaiKhoan, tk.MaNhanVien.ToString() });
}
}
return(new string[] { "", "" });
}
private void datagrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
int rowindex = datagrid.SelectedIndex;
if (rowindex == -1)
{
Clear();
}
else
{
TAI_KHOAN tk = (TAI_KHOAN)datagrid.SelectedItem;
txt_username.Text = tk.TaiKhoan;
txt_password.Text = tk.MatKhau;
cb_loai.SelectedValue = tk.MaLoai;
}
}
catch (Exception ex)
{
throw;
}
}
protected void btn_dangnhap_Click(object sender, EventArgs e)
{
string username = txt_email.Text;
string password = txt_password.Text;
byte[] pass = Encoding.ASCII.GetBytes(password);
if (taiKhoanService.Login(username, pass))
{
//TAI_KHOAN
//Session["user_id"] =
TAI_KHOAN tk = taiKhoanService.GetByUsername(username);
Session["MA_KH"] = tk.MA_KH;
KHACH_HANG kh = khachHangService.GetDVByMa(tk.MA_KH);
Session["TEN_KH"] = kh.TEN_KH;
Session["EMAIL"] = kh.EMAIL;
Session["PHONE"] = kh.PHONE;
Response.Redirect("../../Default.aspx");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Alert", "alert('Đăng nhập không thành công')", true);
}
}
