public int RetriveContactByCityOrState(AddressBookModel addressBookModel)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("SpRetriveContactByCityOrState", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@state_name", addressBookModel.state);
connection.Open();
var Count = (int)command.ExecuteScalar();
SqlDataReader sqlDataReader = command.ExecuteReader();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
addressBookModel.person_id = sqlDataReader.GetInt32(0);
Console.WriteLine("Number of Conctacts beloning to entered City Or State {0}", addressBookModel.person_id);
}
}
return(Count);
}
}
