public bool AddChiTiet(ChiTietBaoCaoTonDTO ctbct)
{
try
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
string sql = "insert into ChiTietBaoCaoTon values(@MaChiTiet," +
"@MaBaoCaoTon," +
"@MaSach," +
"@TonDau," +
"@TonCuoi," +
"@PhatSinh)";
SqlCommand cmd = new SqlCommand(sql, _connection);
cmd.Parameters.Add("@MaChiTiet", SqlDbType.Char).Value = ctbct.MaChiTietBaoCaoTon;
cmd.Parameters.Add("@MaBaoCaoTon", SqlDbType.Char).Value = ctbct.MaBaoCaoTon;
cmd.Parameters.Add("@MaSach", SqlDbType.Char).Value = ctbct.MaSach;
cmd.Parameters.Add("@TonDau", SqlDbType.Int).Value = ctbct.TonDau;
cmd.Parameters.Add("@TonCuoi", SqlDbType.Int).Value = ctbct.TonCuoi;
cmd.Parameters.Add("@PhatSinh", SqlDbType.Int).Value = ctbct.PhatSinh;
cmd.ExecuteNonQuery();
_connection.Close();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "jhgjdhghfghjgfh");
_connection.Close();
}
return(false);
}
public bool AddChiTietBaoCao(ChiTietBaoCaoTonDTO ctbct)
{
return(objCTBCT.AddChiTiet(ctbct));
}
