public int update(string matt, string magv, DateTime ngaynhan, int tinhtrang) { try { using (QLTTEntities qltt = new QLTTEntities()) { TT_LUONGGV data = qltt.TT_LUONGGV.Where(p => p.MATT == matt).FirstOrDefault(); if (data != null) { data.MATT = matt; data.MAGV = magv; data.NGAYNHAN = ngaynhan; data.TINHTRANG = tinhtrang; qltt.SaveChanges(); return(1); } return(0); } } catch { return(0); } }
public int delete(string code) { using (QLTTEntities qltt = new QLTTEntities()) { TT_LUONGGV data = qltt.TT_LUONGGV.Where(p => p.MATT == code).FirstOrDefault(); if (data != null) { qltt.TT_LUONGGV.Remove(data); qltt.SaveChanges(); return(1); } } return(0); }
public DataTable get(string code) { using (QLTTEntities qltt = new QLTTEntities()) { TT_LUONGGV data = qltt.TT_LUONGGV.Where(p => p.MATT == code).FirstOrDefault(); if (data != null) { DataTable rtnTable = new DataTable(); rtnTable.Columns.Add("MATT", typeof(string)); rtnTable.Columns.Add("MAGV", typeof(string)); rtnTable.Columns.Add("NGAYNHAN", typeof(DateTime)); rtnTable.Columns.Add("TINHTRANG", typeof(int)); rtnTable.Rows.Add(data.MATT, data.MAGV, data.NGAYNHAN, data.TINHTRANG); return(rtnTable); } } return(null); }
public int insert(string matt, string magv, DateTime ngaynhan, int tinhtrang) { try { using (QLTTEntities qltt = new QLTTEntities()) { TT_LUONGGV data = new TT_LUONGGV() { MATT = matt, MAGV = magv, NGAYNHAN = ngaynhan, TINHTRANG = tinhtrang }; qltt.TT_LUONGGV.Add(data); qltt.SaveChanges(); return(1); } } catch { return(0); } }