private void btnluu_Click(object sender, EventArgs e)
{
string matkhaucu = dataMatKhau.layMatKhau();
if (txtmatkhaucu.Text != matkhaucu)
{
MessageBox.Show("Sai mật khẩu cũ!");
return;
}
if (txtmkmoi.Text != txtmkmoi2.Text)
{
MessageBox.Show("Mật khẩu mới không khớp nhau!");
return;
}
MATKHAU mkcu = new MATKHAU();
mkcu.matkhau1 = txtmatkhaucu.Text;
MATKHAU mkmoi = new MATKHAU();
mkmoi.matkhau1 = txtmatkhaucu.Text;
mkmoi = dataMatKhau.tim(mkmoi);
mkmoi.matkhau1 = txtmkmoi.Text;
dataMatKhau.suaMatKhau(mkcu, mkmoi);
MessageBox.Show("Đã luu!");
Close();
}
public void suaMatKhau(MATKHAU bef, MATKHAU aft)
{
SqlCommand sql = new SqlCommand();
sql.CommandText = "update MATKHAU set matkhau = @mk, candangnhap = @tt where matkhau = @mk1";
sql.CommandType = CommandType.Text;
sql.Parameters.AddWithValue("@mk", aft.matkhau1);
sql.Parameters.AddWithValue("@tt", aft.candangnhap);
sql.Parameters.AddWithValue("mk1", bef.matkhau1);
sql.Connection = DataProvider.con;
sql.ExecuteNonQuery();
}
public MATKHAU tim(MATKHAU inf)
{
return data.tim(inf);
}
public void suaMatKhau(MATKHAU bef, MATKHAU aft)
{
data.suaMatKhau(bef, aft);
}
public MATKHAU tim(MATKHAU inf)
{
return data.MATKHAUs.Find(inf.matkhau1);
}
private void btnsua_Click(object sender, EventArgs e)
{
try
{
int x = Convert.ToInt32(txthandungthe.Text);
int y = Convert.ToInt32(txtsolantrehen.Text);
int z = Convert.ToInt32(txtsongaykhoathe.Text);
int t = Convert.ToInt32(txtsongaymuon.Text);
int w = Convert.ToInt32(txtsosachmuon.Text);
THAMSO songaymuon = new THAMSO();
songaymuon.tenthamso = "songaymuon";
songaymuon = data.timThamSo(songaymuon);
songaymuon.giatri = txtsongaymuon.Text;
data.suaThamSo(songaymuon);
THAMSO handungthe = new THAMSO();
handungthe.tenthamso = "handungthe";
handungthe = data.timThamSo(handungthe);
handungthe.giatri = txthandungthe.Text;
data.suaThamSo(handungthe);
THAMSO solantrehen = new THAMSO();
solantrehen.tenthamso = "solantrehen";
solantrehen = data.timThamSo(solantrehen);
if (cbsolantrehen.Checked == true)
{
solantrehen.tinhtrang = true;
solantrehen.giatri = txtsolantrehen.Text;
}
else
{
solantrehen.giatri = txtsolantrehen.Text;
solantrehen.tinhtrang = false;
}
data.suaThamSo(solantrehen);
THAMSO songaykhoathe = new THAMSO();
songaykhoathe.tenthamso = "songaykhoathe";
songaykhoathe = data.timThamSo(songaykhoathe);
if (cbsolantrehen.Checked == true)
{
songaykhoathe.tinhtrang = true;
songaykhoathe.giatri = txtsongaykhoathe.Text;
}
else
{
songaykhoathe.giatri = txtsolantrehen.Text;
songaykhoathe.tinhtrang = false;
}
data.suaThamSo(songaykhoathe);
THAMSO sosachmuon = new THAMSO();
sosachmuon.tenthamso = "sosachmuon";
sosachmuon = data.timThamSo(sosachmuon);
if (cbsosachmuon.Checked == true)
{
sosachmuon.giatri = txtsosachmuon.Text;
}
else
{
sosachmuon.giatri = txtsosachmuon.Text;
sosachmuon.tinhtrang = false;
}
data.suaThamSo(sosachmuon);
string matkhau = dataMatKhau.layMatKhau();
MATKHAU mkcu = new MATKHAU();
mkcu.matkhau1 = matkhau;
mkcu = dataMatKhau.tim(mkcu);
MATKHAU mkmoi = new MATKHAU();
mkmoi.matkhau1 = matkhau;
if (cbcandangnhap.Checked == true)
mkmoi.candangnhap = true;
else
mkmoi.candangnhap = false;
dataMatKhau.suaMatKhau(mkcu, mkmoi);
MessageBox.Show("Đã lưu!");
Close();
noticeUpdateThamSo();
}
catch (FormatException)
{
MessageBox.Show("Chỉnh sửa không hợp lệ!");
}
}