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