public void AddSpammer(SpammersModel model)
        {
            var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);

            if (_conn.State == ConnectionState.Closed)
            {
                _conn.Open();
            }
            var command = new SqlCommand();

            try
            {
                command.CommandText = "Add_tblSpamPhone";
                command.Connection  = _conn;
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@SpamPhone", model.PhoneNo).Direction = ParameterDirection.Input;
                command.Parameters.AddWithValue("@SpamName", model.Name).Direction     = ParameterDirection.Input;
                command.Parameters.AddWithValue("@Status", model.Status).Direction     = ParameterDirection.Input;
                command.Prepare();
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                _conn.Close();
            }
        }
        public List <SpammersModel> CheckSpammerByPhone(string phoneNo)
        {
            List <SpammersModel> lstSpams = new List <SpammersModel>();
            var query = string.Format("SELECT * FROM tbl_SpamPhone WHERE spam_phone = '{0}'", phoneNo);
            var _conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InfoWebAppDbStr"].ConnectionString);

            if (_conn.State == ConnectionState.Closed)
            {
                _conn.Open();
            }
            //Create command store procedure
            var command = new SqlCommand(query, _conn);

            try
            {
                var reader = command.ExecuteReader();
                while (reader.Read())
                {
                    var model = new SpammersModel();
                    model.Id      = reader.GetInt32(1);
                    model.PhoneNo = reader.GetValue(2) as string;
                    model.Name    = reader.GetValue(3) as string;
                    lstSpams.Add(model);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(lstSpams);
        }