public bool them(ChiTietBXHDTO ctbxh)
{
string query = string.Empty;
query += "INSERT INTO [chitietBXH] ([MaCTBXH], [MaDoiBong], [MaBXH], [Thang], [Hoa], [Thua], [HieuSo], [Diem], [Hang], [TongSBT])";
query += "VALUES (@MaCTBXH,@MaDoiBong,@MaBXH,@Thang,@Hoa,@Thua,@HieuSo,@Diem,@Hang,@TongSBT)";
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("@MaCTBXH", ctbxh.MaCTBXH);
cmd.Parameters.AddWithValue("@MaDoiBong", ctbxh.MaDoiBong);
cmd.Parameters.AddWithValue("@MaBXH", ctbxh.MaBXH);
cmd.Parameters.AddWithValue("@Thang", ctbxh.Thang);
cmd.Parameters.AddWithValue("@Hoa", ctbxh.Hoa);
cmd.Parameters.AddWithValue("@Thua", ctbxh.Thua);
cmd.Parameters.AddWithValue("@HieuSo", ctbxh.HieuSo);
cmd.Parameters.AddWithValue("@Diem", ctbxh.Diem);
cmd.Parameters.AddWithValue("@Hang", ctbxh.Hang);
cmd.Parameters.AddWithValue("@TongSBT", ctbxh.TongSBT);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public bool them(ChiTietBXHDTO ctbxh)
{
bool re = ctbxhDAL.them(ctbxh);
return(re);
}
