public static int update(CA_LAM_VIEC clv)
{
string query = "update CA_LAM_VIEC set BAT_DAU = '" + clv.BAT_DAU
+ "' , KET_THUC = '" + clv.KET_THUC
+ "' , GIO = " + clv.GIO
+ " where CA = " + clv.CA;
return(Connect.sendQuery(query));
}
public static int insert(CA_LAM_VIEC clv)
{
string query = "insert into CA_LAM_VIEC values( " + clv.GIO
+ " , '" + clv.BAT_DAU
+ "' , '" + clv.KET_THUC
+ "' ) ";
return(Connect.sendQuery(query));
}
public static int delete(int ca)
{
string query = "delete from CA_LAM_VIEC where CA = " + ca + " ";
return(Connect.sendQuery(query));
}