public void sua(string key, string hovaten, DateTime ngaysinh, string quequan, string quoctich, string cmnd, string idphong, string chucvu, byte[] hinhanh, DateTime ngayvaolam, DateTime ngaynghiviec, string sohd, string sodienthoai, string gioitinh, string email, string tinhtrang, string tieusu, string bangcap, string mota)
{
dbData = new KetNoiDBDataContext();
nhansu ns = (from a in dbData.nhansus select a).Single(t => t.key == key);
ns.hovaten = hovaten;
ns.ngaysinh = ngaysinh;
ns.quequan = quequan;
ns.quoctich = quoctich;
ns.cmnd = cmnd;
ns.idphong = idphong;
ns.chucvu = chucvu;
ns.hinhanh = hinhanh;
ns.ngayvaolam = ngayvaolam;
ns.ngaynghiviec = ngaynghiviec;
ns.sohdld = sohd;
ns.sodienthoai = sodienthoai;
ns.gioitinh = gioitinh;
ns.mota = mota;
ns.bangcap = bangcap;
ns.email = email;
ns.tinhtrang = tinhtrang;
ns.tieusu = tieusu;
dbData.SubmitChanges();
}
private void Xemykien_Click(object sender, EventArgs e)
{
DataGridViewRow dr = dataGridView1.SelectedRows[0];
string Mabantin = dr.Cells[0].Value.ToString();
int idbantin = int.Parse(Mabantin.Substring(Mabantin.LastIndexOf("T") + 1, 4));
bantin bantinmo = taikhoan.Laybantin(idbantin);
string ndykien = "";
int dem = 0;
if (taikhoan.Layykien(idbantin).Count == 0)
{
ndykien = "Bản tin chưa có ý kiến";
}
else
{
foreach (bantin_ykien_duyet item in taikhoan.Layykien(idbantin))
{
dem += 1;
nhansu nguoiviet = taikhoan.Laytaikhoan2(item.iduser);
ndykien += string.Format("Thời gian: {1:hh} giờ, {2:mm} phút, ngày {3:dd/MM/yyyy}", dem.ToString(), item.ngay, item.ngay, item.ngay);
ndykien += string.Format("\r\nÝ kiến {0}:", dem);
ndykien += string.Format("\r\n{0}", item.noidung.ToString());
ndykien += string.Format("\r\n{0}", nguoiviet.hoten);
ndykien += "\r\n" + "----------" + "\r\n";
}
}
Ykien.Text = ndykien;
}
public void Capnhatnhansu(int iduser, string hoten, string manv, short idkhoa, short idphongban, string nghenghiep,
string chucvu, string email, string sdt, string account)
{
nhansu themnhansu = (from tk in data.nhansus
where tk.iduser == iduser
select tk).Single();
themnhansu.hoten = hoten;
themnhansu.manv = manv;
if (idkhoa != 0)
{
themnhansu.idkhoa = idkhoa;
}
if (idphongban != 0)
{
themnhansu.idphongban = idphongban;
}
themnhansu.nghenghiep = nghenghiep;
themnhansu.chucvu = chucvu;
themnhansu.email = email;
themnhansu.sdt = sdt;
themnhansu.acc = account;
themnhansu.pw = "1";
data.SubmitChanges();
}
public void themns(string key, string id, string hovaten, DateTime ngaysinh, string quequan, string quoctich, string cmnd, string idphong, string chucvu, byte[] hinhanh, DateTime ngayvaolam, DateTime ngaynghiviec, string sohd, string sodienthoai, string gioitinh, string email, string tinhtrang, string tieusu, string bangcap, string mota)
{
nhansu ns = new nhansu();
ns.key = key;
ns.id = id;
ns.hovaten = hovaten;
ns.ngaysinh = ngaysinh;
ns.quequan = quequan;
ns.quoctich = quoctich;
ns.cmnd = cmnd;
ns.idphong = idphong;
ns.chucvu = chucvu;
ns.hinhanh = hinhanh;
ns.ngayvaolam = ngayvaolam;
ns.ngaynghiviec = ngaynghiviec;
ns.sohdld = sohd;
ns.sodienthoai = sodienthoai;
ns.gioitinh = gioitinh;
ns.email = email;
ns.bangcap = bangcap;
ns.mota = mota;
ns.tinhtrang = tinhtrang;
ns.tieusu = tieusu;
dbData.nhansus.InsertOnSubmit(ns);
dbData.SubmitChanges();
}
public nhansu Laynhansu(int iduser)
{
nhansu ketqua = (from tk in data.nhansus
where tk.iduser == iduser
select tk).Single();
return(ketqua);
}
public nhansu Laytaikhoan2(int iduser)
{
nhansu taikhoan = (from tk in data.nhansus
where tk.iduser == iduser
select tk).Single();
return(taikhoan);
}
public nhansu Laytaikhoan(string tendn)
{
nhansu taikhoan = (from tk in data.nhansus
where tk.acc == tendn
select tk).Single();
return(taikhoan);
}
public void Xoanhansu(int iduser)
{
nhansu xoanhansu = (from tk in data.nhansus
where tk.iduser == iduser
select tk).Single();
data.nhansus.DeleteOnSubmit(xoanhansu);
data.SubmitChanges();
}
private void Form1_Load(object sender, EventArgs e)
{
int i = 1366 / 2 - label1.Size.Width / 2;
label1.Location = new System.Drawing.Point(i, 23);
List <string> hinhthuc = new List <string>()
{
"Dịch", "Viết mới", "Nguyên văn"
};
htsoancb.DataSource = hinhthuc;
List <string> mucdo = new List <string>()
{
"Bình thường", "Quan trọng"
};
mucdocb.DataSource = mucdo;
dangnhap = taikhoan.Laytaikhoan(tk);
nguoisoan.Text = taikhoan.Laytaikhoan2(mobt.iduser).hoten.ToString();
chucvu.Text = taikhoan.Laytaikhoan2(mobt.iduser).chucvu.ToString();
Mabantin.Text = "BT" + string.Format("{0:0000}", mobt.idbantin);
chudebantin = taikhoan.Laychude();
List <string> dschude = new List <string>();
foreach (bantin_chude chude1 in chudebantin)
{
dschude.Add(chude1.tenchude.ToString());
}
chudecb.DataSource = dschude;
nhomnhancb.DataSource = taikhoan.Laytennhom();
//Load bản tin mở
chudecb.Text = taikhoan.Laychude().Single(x => x.idchude == mobt.idchude).tenchude.ToString();
tukhoa.Text = mobt.tukhoa;
tieude.Text = mobt.tieude;
htsoancb.Text = mobt.hinhthuc;
mucdocb.Text = (mobt.mucdo == 'B') ? "Bình thường" : "Quan trọng";
List <string> dsnhomdachon = new List <string>(mobt.nhomnhan.Split(new string[] { "," }, StringSplitOptions.None));
foreach (string item in dsnhomdachon)
{
nhomduocchon.Add(taikhoan.Laynhom(int.Parse(item)));
}
loaddata();
duongdanCT.Text = mobt.duongdanCT;
duongdanNhap.Text = mobt.duongdanNhap;
}
public void xoa(string key)
{
using (var trans = new TransactionScope())
{
dbData = new KetNoiDBDataContext();
nhansu ns = (from a in dbData.nhansus select a).Single(t => t.key == key);
dbData.nhansus.DeleteOnSubmit(ns);
var f = (from a in dbData.filens where a.keyns == key select a);
foreach (var fa in f)
{
filen file = fa;
dbData.filens.DeleteOnSubmit(fa);
}
dbData.SubmitChanges();
trans.Complete();
}
}
public account dangnhap(string account, string password)
{
bool ketqua = taikhoan.KTdangnhap(account, password);
if (ketqua)
{
nhansu dangnhap = taikhoan.Laytaikhoan(account);
account trave = new account();
trave.iduser = dangnhap.iduser;
trave.acc = account;
trave.password = password;
trave.quyen = dangnhap.quyen;
return(trave);
}
else
{
return(null);
}
}
public void Themnhansu(string hoten, string manv, short idkhoa, short idphongban, string nghenghiep,
string chucvu, string email, string sdt, string account)
{
int dem = (from tk in data.nhansus
select tk).ToList().Last().iduser;
nhansu themnhansu = new nhansu();
if (dem == 0)
{
themnhansu.iduser = 1;
}
else
{
themnhansu.iduser = dem + 1;
}
themnhansu.hoten = hoten;
themnhansu.manv = manv;
if (idkhoa != 0)
{
themnhansu.idkhoa = idkhoa;
}
if (idphongban != 0)
{
themnhansu.idphongban = idphongban;
}
themnhansu.nghenghiep = nghenghiep;
themnhansu.chucvu = chucvu;
themnhansu.email = email;
themnhansu.sdt = sdt;
themnhansu.acc = account;
themnhansu.pw = "1";
data.nhansus.InsertOnSubmit(themnhansu);
data.SubmitChanges();
}
private void Form1_Load(object sender, EventArgs e)
{
int i = (1383 - label1.Size.Width) / 2;
label1.Location = new System.Drawing.Point(i, 23);
List <string> hinhthuc = new List <string>()
{
"Dịch", "Viết mới", "Nguyên văn"
};
htsoancb.DataSource = hinhthuc;
List <string> mucdo = new List <string>()
{
"Bình thường", "Quan trọng"
};
mucdocb.DataSource = mucdo;
dangnhap = taikhoan.Laytaikhoan(tk);
nguoisoan.Text = dangnhap.hoten.ToString();
chucvu.Text = (dangnhap.chucvu == null) ? "" : dangnhap.chucvu.ToString();
ngaysoan.Text = string.Format("{0:dd/MM/yyyy}", DateTime.Now);
Mabantin.Text = "BT" + string.Format("{0:0000}", (int.Parse(taikhoan.Laybantincuoi().idbantin.ToString()) + 1));
chudebantin = taikhoan.Laychude();
List <string> dschude = new List <string>();
foreach (bantin_chude chude1 in chudebantin)
{
dschude.Add(chude1.tenchude.ToString());
}
chudecb.DataSource = dschude;
nhomnhancb.DataSource = taikhoan.Laytennhom();
}
