public void Insert(CongNo info)
{
string sqlQuery = "insert into CongNo values ('" +
info.MaCN + "','" +
info.MaKH + "','" +
info.ThoiGian.ToShortDateString() + "',"+
info.SoTien+","+
info.DaTra + ")";
ExecuteNonQuery(sqlQuery);
}
public void Update(CongNo info)
{
string sqlQuery = "update CongNo" +
" set MaKH='" + info.MaKH + "'," +
"ThoiGian='" + info.ThoiGian.ToShortDateString() + "'" +
"SoTien="+info.SoTien+
"DaTra="+info.DaTra+
"where MaCN='" + info.MaCN + "'";
ExecuteNonQuery(sqlQuery);
}
public List<CongNo> GetList()
{
List<CongNo> list = new List<CongNo>();
string sqlQuery = "select * from CongNo";
reader = ExecuteReader(sqlQuery);
while (reader.Read())
{
CongNo congNo = new CongNo();
congNo.MaCN = reader["MaCN"].ToString();
congNo.MaKH = reader["MaKH"].ToString();
congNo.ThoiGian = (DateTime)reader["ThoiGian"];
congNo.SoTien = (double)reader["SoTien"];
congNo.DaTra = (double)reader["DaTra"];
list.Add(congNo);
}
return list;
}
public void Update(CongNo info)
{
data.Update(info);
}
public void Insert(CongNo info)
{
data.Insert(info);
}
