public bool them(KetQuaTranDauDTO kqtd)
{
string query = string.Empty;
query += "INSERT INTO [ketquatrandau] ([MaKetQua], [SoBTDoiNha], [SoBTDoiKhach], [MaTranDau])";
query += "VALUES (@MaKetQua,@SoBTDoiNha,@SoBTDoiKhach,@MaTranDau)";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaKetQua", kqtd.MaKetQua);
cmd.Parameters.AddWithValue("@SoBTDoiNha", kqtd.SoBTDoiNha);
cmd.Parameters.AddWithValue("@SoBTDoiKhach", kqtd.SoBTDoiKhach);
cmd.Parameters.AddWithValue("@MaTranDau", kqtd.MaTranDau);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public bool them(KetQuaTranDauDTO kqtd)
{
bool re = kqtdDAL.them(kqtd);
return(re);
}
