public bool AddChiTiet(ChiTietBaoCaoCongNoDTO ctbccn) { try { if (_connection.State != ConnectionState.Open) { _connection.Open(); } string sql = "insert into ChiTietBaoCaoCongNo values(@MaChiTiet," + "@MaBaoCaoCongNo," + "@MaKhachHang," + "@NoDau," + "@NoCuoi," + "@PhatSinh)"; SqlCommand cmd = new SqlCommand(sql, _connection); cmd.Parameters.Add("@MaChiTiet", SqlDbType.Char).Value = ctbccn.MaChiTietBaoCaoCongNo; cmd.Parameters.Add("@MaBaoCaoCongNo", SqlDbType.Char).Value = ctbccn.MaBaoCaoCongNo; cmd.Parameters.Add("@MaKhachHang", SqlDbType.Char).Value = ctbccn.MaKhachHang; cmd.Parameters.Add("@NoDau", SqlDbType.Decimal).Value = ctbccn.NoDau; cmd.Parameters.Add("@NoCuoi", SqlDbType.Decimal).Value = ctbccn.NoCuoi; cmd.Parameters.Add("@PhatSinh", SqlDbType.Decimal).Value = ctbccn.PhatSinh; cmd.ExecuteNonQuery(); _connection.Close(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message + "jhgjdhghfghjgfh"); _connection.Close(); } return(false); }
public bool AddChiTietBaoCao(ChiTietBaoCaoCongNoDTO ctbccn) { return(objCTBCCN.AddChiTiet(ctbccn)); }