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(); }