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)); }