protected override void luu()
{
if (txtid.Text == "" || txtphong.Text == "")
{
mes.thongtinchuadaydu();
return;
}
if (_hdong == 0)
{
using (dbData = new KetNoiDBDataContext())
{
var lst = (from a in dbData.phongbans where a.id == txtid.Text select a).Count();
if (lst > 0)
{
mes.trunglap("Mã Phòng " + txtid);
return;
}
p.them(_key, txtid.Text, txtphong.Text, checkpq.Checked);
hs.add(txtid.Text, "Thêm Phòng Ban");
Biencucbo.obj = 1;
}
}
else
{
using (dbData = new KetNoiDBDataContext())
{
p.sua(_key, txtphong.Text, checkpq.Checked);
hs.add(txtid.Text, "Sửa Phòng Ban");
Biencucbo.obj = 1;
}
}
huy();
}
public List <account> dangnhap2(string taikhoan, string matkhau)
{
db = new KetNoiDBDataContext();
var dn = (from tk in db.accounts where tk.uname == taikhoan & tk.pass == matkhau & tk.IsActived == true select tk).ToList();
return(dn);
}
private void NapChucNangNguoiDung()
{
dbData = new KetNoiDBDataContext();
// lay user
//var user = gridView1.GetFocusedRow() as account;
//lay phong ban
var phongban = gv.GetFocusedRow() as phongban;
if (phongban == null)
{
return;
}
// lay danh sach quyen của user
// var l = db.PhanQuyen2s.Where(t => t.TaiKhoan == user.id);
var l = dbData.PhanQuyen2s.Where(t => t.TaiKhoan == phongban.id);
var q = from c in dbData.ChucNangs
select new ObjPhanQuyen
{
MaChucNang = c.MaChucNang,
TenChucNang = c.TenChucNang,
ChucNangCha = c.ChucNangCha,
Xem = LayQuyen(0, l, c),
Them = LayQuyen(1, l, c),
Sua = LayQuyen(2, l, c),
Xoa = LayQuyen(3, l, c)
};
treeList1.DataSource = q;
treeList1.ExpandAll();
}
public bool KiemTraKetNoi()
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load("appconn.xml");//mở file.xml lên
var s = xmlDoc.DocumentElement["conn"].InnerText;
if (s == string.Empty)
{
return(false);
}
// giải mã
var conn = md5.Decrypt(s);
var b = new SqlConnectionStringBuilder();
b.ConnectionString = conn;
Biencucbo.DbName = b.InitialCatalog;
Biencucbo.ServerName = b.DataSource;
var sqlCon = new SqlConnection(conn);
// gán cho DAL tren bo nhớ
DAL.Settings.Default.CCS_NSConnectionString = conn;
try
{
sqlCon.Open();
db = new KetNoiDBDataContext(sqlCon);
return(true);
}
catch (Exception ex)
{
}
return(false);
}
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();
}
public void btnthemphong(object sender, EventArgs e)
{
f_dsphongban frm = new f_dsphongban();
frm.ShowDialog();
var lst = (from a in new KetNoiDBDataContext().phongbans select a).ToList();
var frm2 = new KetNoiDBDataContext().phongbans;
}
protected override int load()
{
using (dbData = new KetNoiDBDataContext())
{
gd.DataSource = dbData.phongbans;
gv.BestFitColumns();
}
return(1);
}
private void DangNhap()
{
// dang xuat
foreach (var form in MdiChildren)
{
form.Close();
}
db.Dispose();
db = new KetNoiDBDataContext();
// dang nhap
var f = new f_login();
try
{
if (f.ShowDialog() == DialogResult.OK)
{
WindowState = FormWindowState.Maximized;
if (Biencucbo.idnv.Trim() != "AD")
{
btnskinht.Visibility = BarItemVisibility.Never;
}
var lst = (from a in db.skins select a).Single(t => t.trangthai == true);
Biencucbo.skin = lst.tenskin;
defaultLookAndFeel1.LookAndFeel.SetSkinStyle(Biencucbo.skin);
var lst2 = (from a in db.donvis where a.id == Biencucbo.donvi select a.tendonvi).FirstOrDefault();
Biencucbo.tendvbc = lst2;
//btninfo_account.Caption =
// LanguageHelper.TranslateMsgString("." + Name + "_btn_Wellcome", "Wellcome ") + Biencucbo.ten;
//btninfo_donvi.Caption = LanguageHelper.TranslateMsgString("." + Name + "_btn_DonVi", "Đơn vị ") +
// Biencucbo.donvi + "-" + Biencucbo.tendvbc;
//btninfo_phong.Caption = LanguageHelper.TranslateMsgString("." + Name + "_btn_BoPhan", "Bộ phận ") +
// Biencucbo.phongban;
//btnDb.Caption = Biencucbo.DbName;
//btnVersion.Caption = LanguageHelper.TranslateMsgString("." + Name + "_btn_Version", "Version ") +
// Assembly.GetExecutingAssembly().GetName().Version;
// duyet ribbon
duyetRibbon(ribbon);
}
else
{
Application.ExitThread();
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.ToString());
}
}
public static bool checkkhoaso(TextEdit txtdv, DateEdit txtngaynhap)
{
KetNoiDBDataContext db = new KetNoiDBDataContext();
//check khoa so
var khoasochungtu = db.khoasochungtus.FirstOrDefault(x => x.iddv == txtdv.Text); //ql2
var ql1 = db.donvis.FirstOrDefault(t => t.id == txtdv.Text);
var ql0 = db.donvis.FirstOrDefault(y => y.id == ql1.iddv);
var khoaso1 = db.khoasochungtus.FirstOrDefault(x1 => x1.iddv == ql1.iddv);
var khoaso0 = db.khoasochungtus.FirstOrDefault(x0 => x0.iddv == ql0.iddv);
//checkks
try
{
DateTime max = (DateTime)khoasochungtu.ngaykhoaso;
if (khoaso1 != null)
{
if (khoaso1.ngaykhoaso > max)
{
max = (DateTime)khoaso1.ngaykhoaso;
}
}
if (khoaso0 != null)
{
if (khoaso0.ngaykhoaso > max)
{
max = (DateTime)khoaso0.ngaykhoaso;
}
}
if (txtngaynhap.DateTime <= max)
{
XtraMessageBox.Show("Đã khoá sổ!");
return(false);
}
}
catch //chua co Khoa so thi Them Moi
{
var khoasochungtu2 = new khoasochungtu()
{
iddv = txtdv.Text,
ngaykhoaso = DateTime.Parse("29/09/2017")
};
db.khoasochungtus.InsertOnSubmit(khoasochungtu2);
db.SubmitChanges();
}
return(true);
}
protected override int load()
{
dbData = new KetNoiDBDataContext();
try
{
gd.DataSource = dbData.r_dsaccounts;
gv.BestFitColumns();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(1);
}
protected override int load()
{
try
{
using (dbData = new KetNoiDBDataContext())
{
gd.DataSource = dbData.dmchucvus;
gv.BestFitColumns();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(1);
}
protected override void luu()
{
if (txtid.Text == "" || txtchucvu.Text == "")
{
mes.thongtinchuadaydu();
return;
}
if (_hdong == 0)
{
using (dbData = new KetNoiDBDataContext())
{
if ((from a in dbData.dmchucvus where a.id == txtid.Text select a).Count() > 0)
{
mes.trunglap("Mã chức vụ " + txtid);
return;
}
}
try
{
cv.them(_key, txtid.Text, txtchucvu.Text);
hs.add(txtid.Text, "Thêm chức vụ");
Biencucbo.obj = 1;
mes.done();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
try
{
cv.sua(_key, txtchucvu.Text);
hs.add(txtid.Text, "Sửa chức vụ");
Biencucbo.obj = 1;
mes.done();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
Close();
}
protected override int load()
{
dbData = new KetNoiDBDataContext();
try
{
gd.DataSource = dbData.r_noicongtacs;
gv.ClearGrouping();
gv.Columns["khuvuc"].GroupIndex = 1;
gv.ExpandAllGroups();
gv.BestFitColumns();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(1);
}
protected override int load()
{
int obj = 1;
try
{
using (dbData = new KetNoiDBDataContext())
{
gd.DataSource = _tTodatatable.addlst((from a in dbData.khuvucs select a).ToList());
gv.BestFitColumns();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(obj);
}
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();
}
}
protected override int xoa()
{
int obj = 0;
try
{
db = new KetNoiDBDataContext();
ns.xoa(gv.GetFocusedRowCellValue("key").ToString());
hs.add(gv.GetFocusedRowCellValue("id").ToString(), "Xóa nhân sự");
obj = 1;
XtraMessageBox.Show("Done!");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(obj);
}
private void btnsave_Click(object sender, EventArgs e)
{
if (txtdataname.Text == "")
{
XtraMessageBox.Show("Database name is not be empty", "Warning");
return;
}
var thatluangplazaConnectionString_new = "";
thatluangplazaConnectionString_new = "Data Source = " + txtservername.Text + "; Initial Catalog = " +
txtdataname.Text + "; Persist Security Info = True; User ID = " +
txtuser.Text + "; Password = "******"";
var sqlCon = new SqlConnection(thatluangplazaConnectionString_new);
try
{
sqlCon.Open();
db = new KetNoiDBDataContext(sqlCon);
XtraMessageBox.Show("Connection succeeded");
Biencucbo.DbName = txtdataname.Text;
Biencucbo.ServerName = txtservername.Text;
thoat_luon = true;
// luu connstring mã hóa vào setting
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load("appconn.xml");//mở file.xml lên
xmlDoc.DocumentElement["conn"].InnerText = md5.Encrypt(thatluangplazaConnectionString_new);
xmlDoc.Save("appconn.xml");
DAL.Settings.Default.CCS_NSConnectionString = thatluangplazaConnectionString_new;
//Settings.Default.Save();
DialogResult = DialogResult.OK;
}
catch
{
XtraMessageBox.Show("Connection failed, please check again or contact Admin");
sqlCon.Close();
}
}
private void laydsd()
{
tungay = cbothoigian.DateTime;
denngay = new DateTime(cbothoigian.DateTime.Year, cbothoigian.DateTime.Month, DateTime.DaysInMonth(cbothoigian.DateTime.Year, cbothoigian.DateTime.Month));
db = new KetNoiDBDataContext();
try
{
gd.DataSource = db.LayDanhSachNhanSu(tungay, denngay);
gd1.DataSource = gd.DataSource;
gv.ClearGrouping();
gv.Columns["noicongtac"].GroupIndex = 1;
gv.Columns["phong"].GroupIndex = 2;
gv.ExpandAllGroups();
gv.BestFitColumns();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
